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

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

debug file transferred by e-mail
Regards

any hints, any news?

Can you confirm that you can cancel by pressing the "Break" button?

Yes, I can cancel the debug session by pressing the 'Break' button but the PLSQL Developer is completely blocked. The Window title shows "Keine R