Re: Displaying output before script terminates, using svrmgrl
Date: Wed, 19 Dec 2001 01:42:30 GMT
Message-ID: <agST7.138761$Ga5.21656829_at_typhoon.tampabay.rr.com>
From the Oracle 8i Supplied PL/SQL Packages reference manual:
Messages sent using DBMS_OUTPUT are not actually sent until the sending subprogram or trigger completes. There is no mechanism to flush output during the execution of a procedure.
A flush would've been a nice option.
One alternative is to use autonomous transaction and write/commit to a table
and check from it
"Mary" <mary.l.sullivan_at_marconi.com> wrote in message
news:3691f489.0112070823.58c88d40_at_posting.google.com...
> I have a sql script that will take any where from 2 minutes to many
> hours to complete. I would like to see the output while the script is
> running, to determine the length of time. I know DMBS_OUTPUT package
> only displays the buffer when the script is complete - is there a way
> around this? Or is there another option?
>
> Thanks!
>
Received on Wed Dec 19 2001 - 02:42:30 CET