Re: real-time tracing

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 09 Nov 1998 19:45:25 GMT
Message-ID: <01be0c18$d2228a60$0300a8c0@WORKSTATION>

You could change the dbms_output calls to util_file calls, and use 'tail -f' on the file if you are running under Unix.

Jonathan Lewis

tobrien_at_reveregroup.com wrote in article <727f7h$mo9$1_at_nnrp1.dejanews.com>...
> Is there a way to print output to the screen during program
execution? I
> have a pl/sql program that loads a large volume of rows and I'd
like to see
> its progress throughout execution (say every thousand rows) as well
as at
> termination. Right now I use dbms_output to print stats, but I can
only see
> them when the program terminates. Any way around this?
>
> -----------== Posted via Deja News, The Discussion Network
==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your
Own
>
Received on Mon Nov 09 1998 - 13:45:25 CST