Sandeep Talabathula

dbms_output.put_line NOT WORKING

September 6, 2012

In SQL Developer, do you ever face issue while running some test oracle script like below and want to see the dbms output..? and you don't see the dbms output..

DECLARE

l_name VARCHAR2 (50) := 'Steven Feuerstein';

BEGIN

DBMS_OUTPUT.put_line ( TRANSLATE (l_name, 'e', '2'));

END;

Then here is what you got to do .. just add the below snippet on the top and now you should see the dbms output :

set serveroutput on format wraped;


Originally posted on Things on Tech.

← All posts