Session debug hangs on PBSDE.DEBUG_LOOP

[jvaldezio]

Hi,

I saw a previous post about session debug hangs on PBSDE.DEBUG_LOOP, specifically in the folowing statement:

------------------------------------------
declare
ret binary_integer;
begin
ret := PBSDE.DEBUG_LOOP;
end;
------------------------------------------

I saw the following solution on the Oracle note ID 1074885.1:

Solution
Do not run PL/SQL Developer in debug mode against an Oracle database.

That's right? Pl/SQL Developer IDE have a problema in debug mode where there is no solution?

Thanks in advance

 

[Marco Kalter]

That is of course not a solution. But it's the cheapest solution for Oracle Support. The loop above is generated internally by the Oracle Debug system (sys.dbms_debug).

 

[jvaldezio]

Thanks Marco,

but, the hang happen only executing the debug over Pl/SQL Developer. Using another tool to debug (like we did, we had used SQL Developer from Oracle), the hang for the same situation does not happen.

Sounds like an issue on Pl/SQL Developer IDE.

Why it happens only sometimes, and why it happens only with PL/SQL Developer since the DEBUG process from Oracle side is the same for any tool?

Thanks