dbms_output in SQL Developer

In sqlplus , you can shorten some of the SET options and it works the same as if the full command is issued.

Get Zahir Mohideen’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

For example , to print the output from dbms_output , you can either use SET SERVEROUT ON or SET SERVEROUTPUT ON.

SQL> set serverout on
SQL> begin
 2 dbms_output.put_line (‘hello Zahir’);
 3 end;
 4 /

hello Zahir
PL/SQL procedure successfully completed.

SQL> set serveroutput on
SQL> begin
 2 dbms_output.put_line (‘hello Zahir’);
 3 end;
 4 /

hello Zahir
PL/SQL procedure successfully completed.

But in SQL developer it expects the full text of the command . If you the first set of commands ( aka SET SERVEROUT ON) , you would get a warning message .

line 1: SQLPLUS Command Skipped: set serverout on
anonymous block completed

If you issue the latter , it works fine.

Originally published at https://zahirmohideen.blogspot.com/2014/03/dbmsoutput-in-sql-developer.html