Return
-
Title
Ora-03113 Error occurs while attempting to debug a procedure, a function or a package -
Description
Upon attempting to debug any procedure, function, or a package, the user receives an Ora - 03113 error. Upon running the sql monitor under Database | Monitor | Sql Monitor, the user was able to identify that the error is caused this statement.
BEGIN DBMS_JAVA.SET_OUTPUT(20000); END -
Cause
DBMS_JAVA may be invalid
-
Resolution
RESOLUTION #1
Re-compile DBMS_JAVA package in the SYS schema and make sure its valid
RESOLUTION #2
Turn off the DBMS_JAVA output | go to VIEW | OPTIONS | Debugger | uncheck the 'Enable DBMS_JAVA Output' -
Additional Information
The DBMS_JAVA.SET_OUTPUT procedure is used to re-direct all Java outputs to the DBMS_Output text buffer