sqldeveloper - DBMS_OUTPUT.PUT_LINE() Doesn't Work

plsql oracle-sqldeveloper dbms-output
Neil picture Neil · Apr 12, 2018 · Viewed 8.5k times · Source

I am trying to print the value passed to the DBMS_OUTPUT.PUT_LINE() function to the DBMS_OUTPUT screen in SQL Developer. No matter what I pass to the function, nothing gets printed in the output window.

I have turned on the DBMS Output window and even connected with an available connection. But on running the following script, only "PL/SQL procedure successfully completed" gets printed in the Script Output window, nothing in the Dbms Output window.

Also I have set the buffer size to 30000, which I guess is enough for printing the string 'test'. Running the command set serveroutput on also didn't work.

Cannot get to print!

When I try the same script in SQLPlus in the command prompt, it works fine and prints 'test' before printing "PL/SQL procedure successfully completed".

Kindly help. Thanks.

Answer

Neil picture Neil · Apr 14, 2018

Upon going through the Oracle community forums, I learned that SQL Developer 17.x which I am using does not provide support to Oracle 10g.

Older version of the SQL Developer 4.x will support Oracle 10g and retrieve DBMS_OUTPUT buffer to display it on the screen.

Since I only had a small database set up for my homework and did not want to downgrade to an older SQL Developer, I upgraded to Oracle 11g XE and it worked. All input given to DBMS_OUTPUT.PUT_LINE() procedure now appears in the Dbms Output window.

Related questions

How to redirect the output of DBMS_OUTPUT.PUT_LINE to a file?

I need to debug in pl/sql to figure times of procedures, I want to use: SELECT systimestamp FROM dual INTO time_db; DBMS_OUTPUT.PUT_LINE('time before procedure ' || time_db); but I don't understand where the output …

Read More
Rudimentary issue: basic PL/SQL console 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. …

Read More
Printing the value of a variable in SQL Developer

I wanted to print the value of a particular variable which is inside an anonymous block. I am using Oracle SQL Developer. I tried using dbms_output.put_line. But it is not working. The code which I am using …

Read More