Re: DBMS_OUTPUT in PL/SQL package . . .

That is the way DBMS_OUTPUT works. If you want to get real-time feedback you have to get creative. I haven't done it but I have heard others say that you can use PIPES to do this. Or you could write the outputs to a generic table and then select the info written (after committing the insert). This method can hinder performance somewhat and you would have to be careful when you did your commits that you didn't commit something you did not want to. Or you can just wait till the program is done.

Sorry I couldn't be of more help,
Patrick Flahan
flahan_at_earthlink.net

PS - If anyone has used PIPEs for debugging I would like to know more about how that is implemented. Thanks.

Susan Frady <sfrady_at_mail.sdsu.edu> wrote in message 360AD4A9.1AA6_at_mail.sdsu.edu...
>Hi All -
>
>I have a PL/SQL database procedure to which I've added some
>DBMS_OUTPUT.PUT_LINE statments as an aid to debugging. The thing is, I
>don't receive these messages "real-time," while the procedure is
>actually running through the selected records. It finishes processing
>and then spits out the messages, almost as an afterthought.
>
>Is this just the way DBMS_OUTPUT is processed, or is there a way to get
>the messages as processing occurs?
>
>Any info will be appreciated!
>
>Susan Frady
>San Diego State University
Received on Fri Sep 25 1998 - 06:00:31 CEST