Debugger Hangs When Starting

[suess]

Hi

I have an issue with the debugger thread hanging when debugging test scripts. Even just opening a new test script and starting the debugger causes the debug thread to hang. Pl/SQL is still running, but I can't close the script window because a dialog shows that says a thread is running. Clicking Terminate button on the dialog, does nothing. Clicking the Break (red lightening bold) has no result. Attempting to kill the debug thread from task manager has no result. My only option is to end the complete Pl/SQL task from task manager.

Then PL/SQL is really slow to open the next time.

I have tried uninstalling and manually cleaning up the left over registry keys and folders and re-installing. But the same problem occurs.

I'm running version 13.0.0.1883.

 

[suess]

Update. I found that if you don't have at least one line in the begin/end section with a line terminator (, the debugger thread goes into a race condition and there is no way to get out of it except to kill the entire pl/sql tree.

I was missing a line termination ( on one line and this was causing a the debugger race condition on one of my scripts.

Starting a new empty test window will cause the same race condition unless dbms_output.put_line('output'); is added.

It would be really nice if this was fixed. A missing ( in a large script could be difficult to find manually and having to kill pl/sql is not optimal.

declare
-- Local variables here
i integer;
begin
-- Test statements here
dbms_output.put_line('output');
end;

 

[Marco Kalter]

This has been fixed for the upcoming 13.0.1 patch release. A parsing error in the PL/SQL Block of the Test Window could hang the debugger.

 

[suess]

Cool! Thanks!