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 from dbms_jobs procedures

Re: dbms_output from dbms_jobs procedures

From: <sybrandb_at_yahoo.com>
Date: 14 Dec 2005 00:48:16 -0800
Message-ID: <1134550096.100826.241610@g14g2000cwa.googlegroups.com> 





No.


You need to replace dbms_output calls by utl_file calls.
You can't redirect stdout of the job processor.
Right now, your dbms_output is ending up in a 'black hole' (in reality
the PGA), and this may cause your procedure to fail.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Wed Dec 14 2005 - 02:48:16 CST












Original text of this message













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