Error received while debugging any procedure:
"ORA-03113: end-of-file on communication channel"
Immediately after that, Toad hangs and results with this error:
1) Verify if your user has all the necessary privileges to debug procedures. Here are the list of privileges that Oracle requires for debugging.
GRANT ALTER ANY PROCEDURE TO user_name
GRANT CREATE ANY PROCEDURE TO user_name
GRANT ALTER SESSION TO user_name
GRANT CREATE SESSION TO user_name
GRANT EXECUTE ON DBMS_DEBUG to public
With Oracle 10g, you need these additional privileges:
GRANT DEBUG ANY PROCEDURE TO user_name
GRANT DEBUG CONNECT SESSION TO user_name
2) Make sure that your user has access to the V$SESSION view.
3) Verify that your SYS.DBMS_DEBUG package is valid.
4) Try patching your database server to the latest patch. The newer patches may fix bugs for the Oracle server.