Skip to Main Content
Forums

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!

How to flush dbms_output.put_line() periodically?

Syed UllahMay 21 2010 — edited May 21 2010
Oracle version is 11 and OS is AIX.

I am running a stored Oracle procedure that prints some messages using dbms_output.put_line().
The procedure runs for a long time and until it finishes, nothing is printed.

Is there a way to tell dbms_output.put_line() to flush the output from time to time and not wait
till the whole procedure completes?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2010
Added on May 21 2010
3 comments
4,050 views