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