Re: DBMS_OUTPUT in PL/SQL package . . .

That's the way DBMS_OUTPUT works. You can try to use utl_file package instead of dbms_output. If you are in Unix, keep writing debug output into
a file and in another xterm run tail -f file_name. It will show output "real-time"

Another way is to write a daemon that is getting messages from a PL/SQL proc via an Oracle pipe and writing it to standard output.

Sergei

Susan Frady wrote:
>
> 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 - 08:20:16 CEST