Error druing debuging

[Slawomir Glodzik]

Hello there,

All the time, since begining of 15 version is problem with debuging, when I starting debug and got diconnect or something like that which is disconnecting from database debuger on test window is geting block, i have to kill in task manager program, there is no way to do it without this, debuger is running, but i can't do anything.

 

[Marco Kalter]

This is indeed a known issue. The process hangs in a database function call, and does not return control. We currently do not yet have a solution.

 

[William Robertson]

Not a solution, but rather than killing via Task Manager you can often cancel the currently executing call from another window (or another instance of PL/SQL Dev if running in dual session mode - or SQL*Plus of course but you need to find the sid/serial you want to cancel). This at least restores control and leaves all your work in place.

alter system cancel sql 'sid,serial';

Requires alter system privilege and Oracle 12.2 (the feature was added in 18c but later backported).

In recent versions of PL/SQL Dev you can set this up as a custom tool in the Session Browser.

 

[fraenkg]

I noticed that after the session was terminated, control was returned to the program, but it was no longer possible to execute it step by step in the debugger. A "run" always seems to be executed instead of a "step".