When using Oracle's sqlplus, you can see output from dbms_output if you put the following command at the beginning of the sql file being used:
set serveroutput on format wrapped size 1000000
After that, put:
dbms_output.ENABLE(10000);
then you can do output commands like:
dbms_output.put_line('started: '||sysdate);
set serveroutput on format wrapped size 1000000
After that, put:
dbms_output.ENABLE(10000);
then you can do output commands like:
dbms_output.put_line('started: '||sysdate);
Version 5.1 last modified by Geoff Fortytwo on 11/07/2010 at 19:17
Document data
Attachments:
No attachments for this document