Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: log for dbms_output.put_line
Mark C. Stock wrote:
> <sybrandb_at_yahoo.com> wrote in message
> news:1143701815.215428.232400_at_i40g2000cwc.googlegroups.com...
> : There is no log. If you use dbms_output in procedures running through
> : dbms_job your output will go to /dev/null.
> : You need to replace dbms_output by utl_file, or send the output using
> : dbms_pipe calls.
> :
> : --
> : Sybrand Bakker
> : Senior Oracle DBA
> :
>
> -- or an autonomous transaction
>
> ++ mcs
Or insert them into a temporary table and then just run select on it afterwards.
Regards
/Rauf
Received on Thu Mar 30 2006 - 06:55:13 CST