Return
-
Title
Can not see the DBMS OUTPUT when debugging a procedure. -
Description
I used to be able to debug a procedure and see the DBMS OUTPUT for the script in the Output window. Now when I debug the same procedure, it will just say, procedure ran successfully but does not show any output.
-
Cause
The procedure script started out with a DBMS OUTPUT buffer equal to 10,000,000.
-
Resolution
Change the DBMS OUTPUT buffer size from 10,000,000 to 1,000,000 in the first line of the procedure script.