Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: flushing DBMS_OUTPUT.putline output. Use OraDebug

Re: flushing DBMS_OUTPUT.putline output. Use OraDebug

From: <gjlinker_at_geocities.com>
Date: Tue, 26 Jan 1999 20:15:23 GMT
Message-ID: <78l7oj$ceq$1@nnrp1.dejanews.com>


This is just to confirm to you all that OraDebug is available for download from

http://members.aol.com/gjlinker

Regards, Gerrit-Jan Linker

In article <19990121180500.10468.00000321_at_ngol05.aol.com>,   gjlinker_at_aol.com (Gjlinker) wrote:
>
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 26 1999 - 14:15:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US