How to get output during(!) procedure-run / flush dbms_output.put_line
Hello again,
during a migration script written in plsql we print several status information to the screen using dbms_output.put_line.
for your background information:
the script does commits every x lines during a mass update. Anytime a commit is done i want to have the output: Timestamp + number of commited rows.
Unfortunately the output by dbms_output.put_line is only flushed to sqldeveloper after the procedure is completed.
So i have all the times after the migration is completed, but if possible i need it the information when it is put in the dbms_output-stack.
Is there any way to flush the output while the procedure is still running? Are the any alternatives to dbms_output.put_line which could help?
Oracle is 10.2.0.4
many thanks,
Andreas
Edited by: Andreas S. on 11.03.2011 01:38