Re: DBMS_OUTPUT in PL/SQL package . . .

I know this would be a pain, but for debugging, you can use the TEXT_IO package instead of the DBMS_OUTPUT package. The problem is that I think you will have to do your debugging and compiling on the client side, in something like procedure builder. Once you have tested it you can remove the debugging statements and compile on the server. Text_io has many of the procedures that dbms_output has such as put_line, etc.

I was hoping for some kind of flush statement for dbms_output that would do what we want but it doesn't look like there is one.

Susan Frady 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 Sat Oct 03 1998 - 03:28:21 CEST