SQL Developer

Hi everyone,

after I learned that we can disable JDWP for debugging I encountered a problem with SQL Dev.

First of all: Yes I know that disabling JDWP is not "officially" supported (DatabaseDebuggerDisableJDWP=true). BUT I have no other way of debugging because of Firewall restrictions.

So please keep in mind that this is my only option.

Now to the problem (step by step):

1. compiling the package (spec & body) for debug.
2. I'm pressing the debug button and select the procedure I want to debug.
3. The UI switches to the Debug UI and I get the Log Messages you see below
4. In the log it says that the connection was established and right after that: the debugger connection failed/aborted with the process to be debugged (not sure what the correct english translation is)
5. The UI stays in Debug mode and there is no way to end it. (screenshot of UI attached below)

I can press the red square but nothing will happen. Pressing the "X" to close SQL Dev also does NOT work.

But the UI is still responsive and most things work (opening / closing objects; select in worksheets etc) but it just wont cancel the debug mode.

Only solution is to kill the sqldeveloper task.

This problem only occurs in 80% of the time I try to debug this pkg. In the other 20% it works randomly. The package has no "special" code (e.g. conditional compilation ) but it is quite large (8000 lines of code).

Debugging works fine with other (smaller) packages.

Log for PKG when it gets stuck:

Verbindung mit der Datenbank BT30 ZZV OWNER.

Debugger versucht, sich mit der Datenbank zu verbinden.

PL/SQL wird ausgeführt: ALTER SESSION SET PLSQL_DEBUG=TRUE

PL/SQL wird ausgeführt: DECLARE

                      id VARCHAR2( 30 );

                    BEGIN

                      id := DBMS\_DEBUG.initialize( 'xxx.xxx.xxx.x', 0 );

                      DBMS\_DEBUG.debug\_on( TRUE );

                    END;

Debugger mit Datenbank verbunden.

Debugger-Verbindung mit zu debuggendem Prozess wurde unterbrochen.

Log for working PKG:

Verbindung mit der Datenbank BT30 ZZV OWNER.

Debugger versucht, sich mit der Datenbank zu verbinden.

PL/SQL wird ausgeführt: ALTER SESSION SET PLSQL_DEBUG=TRUE

PL/SQL wird ausgeführt: DECLARE

                      id VARCHAR2( 30 );

                    BEGIN

                      id := DBMS\_DEBUG.initialize( 'xxx.xxx.xxx', 0 );

                      DBMS\_DEBUG.debug\_on( TRUE );

                    END;

Debugger mit Datenbank verbunden.

Source Breakpoint: CHECK_211.pls:11

---------- > Pressed Abort

ORA-06543: PL/SQL: Ausführungsfehler - abgebrochen

PL/SQL wird ausgeführt: BEGIN

                      DBMS\_DEBUG.debug\_off();

                    END;

Prozess beendet.

Abmeldung von der Datenbank XXXXX.

Debugger von Datenbank abgemeldet.