Re: dbms_output from dbms_jobs procedures

Howdo Guys,

DBMS_OUTPUT should not cause a PL/SQL program to fail, PROVIDING the buffer it writes to is large enough to accept the output. This is what is set with the DBMS_OUTPUT.ENABLE procedure. Its default is something like 2000 bytes.

If your output from DBMS_OUTPUT is greater than that, then you'll get an error and your procedure will fail.

Instead of using DBMS_OUTPUT, why not create a debugging procedure to write the output to a table using PRAGMA AUTONOMOUS_TRANSACTION, and just call that instead?

The Autonomous Transaction Pragma is perfect for such a purpose. If you need more information , check the Oracle PL/SQL User Guide, which you can download in PDF format from Technet.

Hope this helps.

James Received on Wed Dec 14 2005 - 08:06:23 CST