rudimentary issue basic pl sql console output

rudimentary issue basic pl sql console output  using -'sql,oracle,plsql,oracle-sqldeveloper,dbms-output'

I am using SQL Developer and want to output the contents of a variable to the console using DBMS_OUTPUT.PUT_LINE().  I am running the following code that adds the numbers 1 through 5 inclusive but I'm not seeing any output.  

n_counter NUMBER := 5; -- Substitute this variable
n_sum     NUMBER := 0;
  WHILE n_counter != 0
    n_sum := n_sum + n_counter;
    n_counter := n_counter -1;

Additionally, do you Know of better resources for troubleshooting issues than the incredibly dense Oracle PL/SQL documentation? [similar to Java SE7 API?]

asked Sep 14, 2015 by FraCopeland
0 votes

1 Answer

0 votes

Since you are using SQL Developer, you have a couple of options.

In SQL Developer, go to View | DBMS Output to ensure that the DBMS Output window is visible. In the DBMS Output window, choose the "plus" icon and select the connection that you want to write data to the DBMS Output window. Then run the PL/SQL block in the SQL Worksheet window using the right arrow (Ctrl+Enter in Windows). You'll see the output appear in the DBMS Output window.

Alternately, you can put both the SQL*Plus SET SERVEROUTPUT ON command and the PL/SQL block in the SQL Worksheet and run it as a script (F5 in Windows). That will display the output immediately below the "anonymous block completed" message in the Script Output window.

answered Sep 14, 2015 by ZacHuntingt