dbms_output.put_line() is getting commented and not printing anything in the output except "PL/SQL procedure successfully completed"

Question

When I am using dbms_output.put_line() in any of of Pl/SQL program, this line is not getting printed and it is not showing any kind of error message, whenever I am running my program is is just printing "PL/SQL procedure successfully completed".

For an example When I am running the following piece of code it is showing the similar behaviour and not printing anything.

DECLARE 
   message  varchar2(20):= 'Hello, World!'; 
BEGIN 
   dbms_output.put_line(message); 
END;

When I am running the above code, the output is the following:

PL/SQL procedure successfully completed

Moreover on my worksheet screen the dbms_output.put_line() is showing in colors like it is commented out. Although I have checked many times nothing is commented.

Corrected tag. [SQL Developer](https://www.oracle.com/database/technologies/appdev/sqldeveloper-landing.html) and [PL/SQL Developer](https://www.allroundautomations.com/products/pl-sql-developer/) are two different products. — William Robertson, Nov 06 '20 at 22:29

score 3 · Answer 1 · answered Nov 06 '20 at 16:22

Since you are using SQL Developer make sure to follow the steps:

Go to View
Click on Dbms Output (this will create a window on SQL Developer)
Click the + button, this will create a prompt.
Select the connection, the selected connection will appear and the background of Dbms Output will turn white
Run the procedure.

Gary_W · Accepted Answer · 2020-11-06T16:18:43.453

1

Don't forget to set serveroutput on. View/DBMS output/pick the connection to show the output window. In SQL Plus:

set serveroutput on size unlimited

edited Nov 06 '20 at 16:18

answered Nov 06 '20 at 16:13

Gary_W

9,933
1
22
40

Thank You very much, running this command at the top of the program worked. Thank you again – FaizanNehal Nov 06 '20 at 16:24

dbms_output.put_line() is getting commented and not printing anything in the output except "PL/SQL procedure successfully completed"

2 Answers2