When running the debugger in SQL Developer either the debugger immediately connects then disconnects after executing the code WITHOUT stopping at breakpoints or the debugger hangs and the only actions I can choose is to terminate or to pause.
The first issue happens a lot more frequently. I am attempting to debug a procedure in a package where the there are several breakpoints throughout the code including at the very start. After checking my tables in which the procedure acts upon before and after running the debugger I can see that the data has been altered so the debugger has ran through the procedure and executed the code without stopping. I have checked this on very simple code where the breakpoint code has been called and have experienced the same result.
Im using 64bit Win7 -
JDK - 1.7.0 update 40
Output:
LOAD TIME : 329UsersCache.fillIn() time = 4 ret==null?: true
UsersCache.fillIn() time = 3 ret==null?: true
tableAlias.cardinality()==0
UsersCache.fillIn() time = 4 ret==null?: true
UsersCache.fillIn() time = 3 ret==null?: true
tableAlias.cardinality()==0
UsersCache.fillIn() time = 4 ret==null?: true
tableAlias.cardinality()==0
tableAlias.cardinality()==0
tableAlias.cardinality()==0
Debugger Output:
Connecting to the database Layout Pro.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '*****', '*****' )
Debugger accepted connection from database on port *****.
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.DISCONNECT()
Process exited.
Disconnecting from the database Layout Pro.
Debugger disconnected from database.
Thanks in advance,
James