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
DBMS_JAVA may be invalid
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'
The DBMS_JAVA.SET_OUTPUT procedure is used to re-direct all Java outputs to the DBMS_Output text buffer
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy