Re: Q: DBMS_OUTPUT display while processing?

What you really need to do is write a listener process that will perform a dbms_output.get_line.

I thought I had an example program which illustrates how this is done but right now I'm unable to locate it. The concept is fairly simple. You write a Pro-C application with an embedded pl/sql block which constantly loops to perform dbms_output.get_line and then writes the output to stdout or to a file.

Ken

ewong74_at_netscape.net wrote:

> Hi,
>
> I have a large PL/SQL package with 20 procedures within the package.
> The purpose of the package is do some batch process which will take
> about 10 hours.
>
> 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?
>
> Thanks in advance.
>
> Ed
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 16 1999 - 15:29:51 CEST