Initialize Debugger Problem

[jmcgeever]

Hi all,

I have recently installed PL/SQL Developer version 5.1.2.682 on a PC with Oracle Client 8.1.7.3. and Windows NT4 SP6.

When I try I run the debugger I get the following error message:

'Unable to initialize debugger
Note: Debugging is only available on Oracle 7.3.4 or later'

Any assistance in resolving this issue would be greatly appreciated.

Regards

Josie McGeever

 

[Marco Kalter]

PL/SQL Developer uses the standard dbms_debug package for debugging. Maybe the package is not installed, or maybe you don't have execute privilege on the package. To find out what exactly goes wrong, execute the following PL/SQL block in SQL*Plus:

declare
  debug_session_id varchar2(100);
begin
  debug_session_id := sys.dbms_debug.initialize;
  sys.dbms_debug.debug_on;
end;
/

Let me know how this turns out.

------------------
Marco Kalter
Allround Automations

 

[dwwang]

I have the same problem and I run the suggest anonmous block and receive the following errors:

declare
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure "SYS.DBMS_SESSION"
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_DEBUG", line 199
ORA-06512: at line 4

It works before. Do you have any suggestion?

Dennis

 

[Marco Kalter]

You can try to reload the Oracle debug packages. Logon to the server computer, go to $ORACLE_HOME/rdbms/admin, start SQL*Plus under the SYS account, and run pbload.sql.

------------------
Marco Kalter
Allround Automations