Q: DBMS_OUTPUT display while processing?
From: <ewong74_at_netscape.net>
Date: Sat, 07 Aug 1999 23:23:56 GMT
Message-ID: <7oif65$mbk$1_at_nnrp1.deja.com>
Hi,
Date: Sat, 07 Aug 1999 23:23:56 GMT
Message-ID: <7oif65$mbk$1_at_nnrp1.deja.com>
Hi,
[Quoted] [Quoted] 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.
[Quoted] I tried to have DBMS_OUTPUT.PUT_LINE in every single procedure to print [Quoted] 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. [Quoted] 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 Sun Aug 08 1999 - 01:23:56 CEST