Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to get output during(!) procedure-run / flush dbms_output.put_line

Andreas S.Mar 11 2011 — edited Mar 11 2011
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
This post has been answered by smon on Mar 11 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2011
Added on Mar 11 2011
3 comments
760 views