Recent content by JazzyJake

I find that I cannot break in a debug session until the debugger has stopped at a breakpoint. If I try to break a non-stopped process, one of the sessions stays active and has to be KILLed. Often the package I'm debugging stays locked and we have to bounce the database (easiest solution) to...

Interesting, no error for this: create or replace procedure compiler_wrong_hint is l_hint_var varchar2(100) := 'xxx'; begin -- begin null; exception when others then dbms_output.put_line(l_hint_var); end; end;

See these threads for more info on this problem: (1) PLSQL Developer hangs on PBSDE.DEBUG_LOOP (WAIT = pipe get). (2) Debugger Hanging Increasing the shared pool did not help us.

Could this be another manifestation of the bug discussed in this thread: PLSQL Developer hangs on PBSDE.DEBUG_LOOP (WAIT = pipe get). When the debugger hangs, we get a 7445 error in the system log indicating that the real problem is with a named pipe, not the debugger itself. The Oracle...

We are using Oracle 9.2.04. Thanks for the suggestion, but we do not have after servererror triggers on the DB. I've had reports that the problem exists in other applications also, so my suspicions that this is an Oracle problem and not a PLSD problem seem to be confirmed. No progress on our...

We're experiencing the problem in PLSD 6.0.2 using Oracle release 9.2.04. We started seeing the problem after installing Oracle Security Patch #68, but we haven't conclusively pegged that as the cause. Reloading the package did not help, we resized the SGA and are waiting to see. The problem...