Re: DBMS_OUTPUT.PUT_LINE

Michael Woo schrieb:

> I only use dbms_output for informational and debugging messages (limited).
>
> For a production job, I will actually use the package utl_file to create a
> log file.
>
> To summize what needs to be done in psuedo code:
>
> open log file
> write to log file
> flush write buffer when needed
> close log file
>
> In a unix environment, I can then tail the log file to monitor the job.

And of course you want to include the -f option. It works pretty well for me to keep track where my PL/SQL procedure is at, at any given time Received on Sun Apr 30 2000 - 00:00:00 CDT