unable to initialize debugger

[jhughes]

I am able to use a test script to execute (F8) a procedure within a package, however whenever I try to debug (F9) the code, it immediately errors off with the following error message:
--------------------------------------
Unable to initialize debugger.

ORA-04063: package body "SYS.DBMS_PIPE" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.PBREAK", line 256
ORA-06512: at "SYS.PBSDE", line 83
ORA-06512: at "SYS.DBMS_DEBUG", line 224
ORA-06512: at line 4
------------------------------------

My userid has the following system privileges
CREATE SESSION
DEBUG ANY PROCEDURE
DEBUG CONNECT SESSION

I also have the debugger preferences to "ALWAYS add debug info for connections" for this connection. I also double checked that the "Add debug information" is selected when I right-click on the package that I'm trying to debug the procedure in.

I am using PSD 6.0.6.947 and connected to Oracle 10g (10.1.0.4.0).

Does anyone see what I'm missing as for the reason this is not working?

Thanks in advance
Jason

 

[Marco Kalter]

The key error message is:

ORA-04063: package body "SYS.DBMS_PIPE" has errors

This indicates that the system packages are inconsistent. You will have to investigate the DBMS_PIPE package body error and fix it.

 

[jhughes]

I passed your message on to the DBA who found the underlying problem and fixed SYS.DBMS_PIPE. The debugger is now working.

Thanks!