Unable to step into debug

[AlexH]

Trying to debug in a test window, but when clicking Start debugger icon ( or using F8 ) it start to execute, but runs to the end. The other icons do not become active.

Things checked done so far.
The packages have been recompiled with debug and the tick shows on the Add debug information
They have been dropped and recreated.
The user has both these priv DEBUG ANY PROCEDURE DEBUG CONNECT SESSION
The user is the owner of the package
Using version 9.0.2, have tried upgrading to 12.0.7 but still the same behaviour.
It has worked in the past on this package and others.
Running - Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Any other suggestions or things to check.

thanks

 

[Marco Kalter]

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 %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[John Nagtzaam]

Are you on a RAC? I had the same problem. Solved it by connecting to a specific instance.

 

[Jens Naumann]

May be this is a senseless answer, but it's different behaviour if You press F8 (execute) or F9 (debug).
Regards