Skip to main content

Posts

Showing posts from September, 2012

dbms_output.put_line NOT WORKING

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;