Test scripts not working under Oracle 11g

[Jeremy]

Hi,

I continue to be frustrated by problems when trying to run Test scripts using PL/SQL Developer v9.0.0.1601 against my packages and functions under Oracle 11g (11.1.0.7.0). Basically when I try to "Break" a script when it isdebugging and stepping through code it will either hang (have to ctrl-alt-delete via windows XP) or not respond at all (when I have to kill off the Oracle sessions and close and re-open PL/SQL Developer. Either way this is vert time consuming and frustrating.

Can this be fixed please?

Thanks,

Jeremy

 

[Marco Kalter]

What happens if you create a little Test Script like this and break on the first line?

begin
  null;
end;

Does this also cause a hang-up? Or are there specific conditions to reproduce this issue?

 

[Jeremy]

Hi,

Tried that and it throws a blank Error poup box but at least does not hang. The error seems to occur on almost any packaged function on any DB (dev or prod, RAC or non-cluster) that I try. all on 11.1.0.7.0 version.

 

[Marco Kalter]

A blank error message box is a bit strange. 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 PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[WexSoft]

This seems to be related to my "Debugger not working" post, as I did get the blank error popup when I tried to terminate the debugger session (for the small test script I included) that was not allowing me to debug (as the debug icons were disabled/greyed out).

Not having the debugger is a fairly serious issue, and for bigger test scripts or calls to stored procedures, PSD seems to hang requiring Task Manager to kill it and reload, all very time consuming and frustrating.