Re: flushing DBMS_OUTPUT.putline output

From: Gjlinker <gjlinker_at_aol.com>
Date: 21 Jan 1999 23:05:00 GMT
Message-ID: <19990121180500.10468.00000321@ngol05.aol.com>

Hi,

Yes, this is the big disadvantage of dbms_output. I've written a similar package that will not use a buffer but prompt the messages immediately. I'll call it OraDebug and will be posted soon on

http://members.aol.com/gjlinker

Regards, Gerrit-Jan Linker

In article <77j33o$4cb$1_at_news1.tc.umn.edu>, wagner_at_cs.umn.edu (Paul Wagner) writes:

>I've noticed that if I have debugging output in a PL/SQL procedure
>using DBMS_OUTPUT.putline(), it all is displayed after execution
>is complete. Is there any way of flushing the output at the point
>of its particular execution? I'd like to see the relative amount
>of time different parts of the procedure take, and it would be
>helpful to see the output as the statements are being executed
>rather than all at the end.
>
>Thanks in advance for any ideas,
>
>Paul
Received on Thu Jan 21 1999 - 17:05:00 CST