Search code examples
plsqloracle-sqldeveloperplsql-package

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

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.

Solution

  • 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