The debugger hangs when the executed procedure violates a constraint.
Sample:
CREATE TABLE dbg_err (col1 NUMBER(5) NOT NULL) TABLESPACE USERS;
CREATE OR REPLACE PACKAGE dbg_err_pck IS
PROCEDURE tst;
END dbg_err_pck;
/
CREATE OR REPLACE PACKAGE BODY dbg_err_pck IS
PROCEDURE tst IS
BEGIN
INSERT INTO dbg_err VALUES(NULL);
END tst;
END dbg_err_pck;
/
If I execute the procedure in a test window I get the expected error, but if I execute the procedure in the PLSQLDeveloper debugger, the debugger does not return. If I try to terminate this session I get "Access violations" in oran11.dll, ntdll.dll. I have to kill the PLSQLDeveloper process in the task manager.
The issue is reproducible.
PL/SQL Developer Version 8.0.0.1480
Windows XP Professional 5.1 Build 2600 (Service Pack 2)
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
Regards