Re: log for dbms_output.put

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 30 Mar 2006 07:46:54 -0800
Message-ID: <1143733614.474048.235710@g10g2000cwb.googlegroups.com>

Mark C. Stock wrote:
> "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
> news:1143723313.502890.180680_at_z34g2000cwc.googlegroups.com...
> :
> : 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
> :

> -- if the GTT is configured to preserve data across commits and will be
> accessed in the same session

>
> ++ mcs

I was not referring to "Global" Temp Table. Temporary as in a table that can be truncated/dropped at anytime.

Wrong choice of word perhaps... maybe "ordinary" or "simple" or just "table" would be better instead.

Regards
/Rauf Received on Thu Mar 30 2006 - 09:46:54 CST

Re: log for dbms_output.put_line