Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_output from dbms_jobs procedures
In article <1134550096.100826.241610_at_g14g2000cwa.googlegroups.com>,
sybrandb_at_yahoo.com says...
> Right now, your dbms_output is ending up in a 'black hole' (in reality
> the PGA), and this may cause your procedure to fail.
>
Hi Sybrand, how may this cause the procedure to fail? I know that if running the procedure in sqlplus the buffer may be exceeded causing an exception but my understanding (perhaps incorrect?) was that the output would simply be disregarded unless being run by a "dbms_output-aware" tool?
-- jeremyReceived on Wed Dec 14 2005 - 04:59:33 CST
![]() |
![]() |