Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: DBMS_OUTPUT display while processing?
ewong74_at_netscape.net wrote:
>
> Hi,
[snip]
> I tried to have DBMS_OUTPUT.PUT_LINE in every single procedure to print
> out the status so that I can monitor each process(to see if there is
> errors) while the package is still running. However, the DBMS_OUTPUT
> didn't display until the whole package is done. This is very annoying.
> Is there any work around?
DBMS_OUTPUT doesn't display anything. It just stores text in a buffer to be regurgitated later. Sqlplus fetches the contents of the buffer for you and displays it.
Within your own procedures you can fetch the text from the DBMS_OUTPUT buffer and do whatever you want with it -- you can store it in a table or write it to a file. We use this approach to write debugging messages to a file via the UTL_FILE package.
I'm afraid I don't remember how to fetch from the buffer -- I wrote it once, buried it in a package, and forgot the details -- and I don't have the manual handy at the moment. However it wasn't hard to figure it out from the manual.
Scott McKellar mck9_at_swbell.net
http://home.swbell.net/mck9/pls/
Received on Sun Aug 08 1999 - 08:00:07 CDT