Re: Q: DBMS_OUTPUT display while processing?

From: Kenneth C Stahl <>
Date: Mon, 16 Aug 1999 09:29:51 -0400
Message-ID: <>

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 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
> Share what you know. Learn what you don't.
Received on Mon Aug 16 1999 - 15:29:51 CEST

Original text of this message