Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_output and trigger
As far as I discovered, before being flushed to stdout, the output goes
to your PGA.
If the output is never flushed, you can run out of PGA.
That happened to me once.
So you may think the output is going into a 'black hole', but it isn't,
and it can potentially bite you.
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Oct 07 2005 - 03:25:34 CDT