debugger hanging

[fabrice]

Hello,
for a long time, our debugging process hangs when we stop them or when error occur.
A small code like this :

declare
CURSOR c IS
SELECT 1 FROM dual;
r c%ROWTYPE;
begin

  OPEN c;
  FETCH c INTO r;
  CLOSE c;

end;

When executing this code in a test windows, if we want to stop on the fetch line with the break buton, for example, PSD hang, and some time consume 50% of processor. (version 11 an 12 and 4 PC on differents windows, oracle 11 enterprise).
Its the same when error occur.
If we don't stop

I suppose PSD is not the responsible, perhaps oracle configuration or grant.
What do you think about this?

 

[Marco Kalter]

I copied your test script, stepped through the code until the FETCH line, and pressed the "Break execution" button on the toolbar. Execution stopped with a "ORA-06543: PL/SQL: execution error - execution aborted" exception as expected.

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 12\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 12 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 12).

 

[fabrice]

hello,
debug.txt send to support@allroundautomations.com

 

[fabrice]

Marco, did you found something wrong in my debug.txt.
Is someone have idea to resolving my probleme?

 

[fabrice]

I always have the probleme.
I tried on a Oracle9i Enterprise Edition and everything is ok.
i obtained this ORA-06543: PL/SQL : erreur d'execution - execution interrompue.
But on Oracle Database 11g Enterprise, PSD block and the error isn't cath.
Anyone to help?