Rauf Sarwar wrote:
> 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
Or call a second procedure straight after the first one, that captures
the dbms_output buffer with GET_LINES and writes it out to a file. Then
you don't have to change the original procedure.
Received on Thu Mar 30 2006 - 09:34:01 CST
