Re: log for dbms_output.put_line

"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 Received on Thu Mar 30 2006 - 06:57:39 CST