PL/SQL (MOSC)

MOSC Banner

how to force dbms_output.put_line to write the buffer more frequently

edited Jun 24, 2009 1:25PM in PL/SQL (MOSC) 6 commentsAnswered
Hello All,

 I use dbms_output.put_line() statements in my pl/sql code to help me log and debug my scripts. 
However I noticed that after upgrading to oracle 10g,  the buffer is not written to screen untill the code block is fully complete. 
This is a problem, becasue:
1- I cannot use it to monitor progress of let's say a long loop in my pl/sql
2- If I run into a error and my plsql or stored procedure terminates, I will get no messages on screen or spool file to help me find the problem

Is there a fix, or workaround, to force dbms_output to flush buffer more frequently, or even better flush buffer real-time?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center