Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_OUTPUT.PUT_LINE

Re: DBMS_OUTPUT.PUT_LINE

From: bmlam <bmlam_at_online.de>
Date: 2000/04/30
Message-ID: <390C5E95.ABEA06A7@online.de>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US