Xref: alice comp.databases.oracle.server:60807 comp.databases.oracle.tools:29800
Path: alice!news-feed.fnsi.net!netnews.com!newspeer1.nac.net!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: ewong74@netscape.net
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Q: DBMS_OUTPUT display while processing?
Date: Sat, 07 Aug 1999 23:23:56 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 19
Message-ID: <7oif65$mbk$1@nnrp1.deja.com>
X-Article-Creation-Date: Sat Aug 07 23:23:56 1999 GMT
X-Http-User-Agent: Mozilla/4.6 [en] (X11; U; SunOS 5.6 sun4u)
X-Http-Proxy: 1.0 x36.deja.com:80 (Squid/1.1.22) for client 204.162.103.135
X-MyDeja-Info: XMYDJUIDewong74

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.