Unable to Initialize the debugger

[ranchan02]

Hi Everyone:

I want to test this procedure that I wrote in PL/SQL Developer, but when I click on the debugger button in the Test Window, I get this error message:

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

Could someone tell me how to get this to work properly? Here's what I have:

--
PL/SQL Developer - Version 6.0.2.880
OS - Windows XP version 6.0 (build 2600) Service Pack 1
Database - Oracle Database 10g Release 10.1.0.2.0
--

Thank you!

 

[Marco Kalter]

You probably need to grant the DEBUG CONNECT SESSION system privilege. This is a new requirement on Oracle10g. Version 6.0.3 will show a more to-the-point error message.

 

[ranchan02]

Hi Marco,

Thanks for the reply back. I'm new to Oracle, so how would I go about granting the privileges? Do I go into Enterprise Manager or something?

 

[Marco Kalter]

Start PL/SQL Developer, connect as a DBA (e.g. SYS), open the Users folder, right-click on the Oracle user that needs to be able to debug and select Edit from the popup menu, go to the System Privileges tab page, click on +, select the DEBUG CONNECT SESSION privilege, and press the Apply button.

 

[Thomas Langenberg]

Hi,

i'm using PLSQL/Dveloper version 5.1.6.747
But after grant the DEBUG CONNECT SESSION system privilege there is no more error but at the test window i can't trace the source, it just runs the script.
Can anybody help me ?

PL/SQL Developer
Version 5.1.6.747 (MBCS)
01.7989 - Unlimited user license
Windows XP version 6,0 (build 2600) Service Pack 1

Physical memory : 515.052 kB (153.680 available)
Paging file : 1.259.640 kB (947.408 available)
Virtual memory : 2.097.024 kB (2.016.000 available)

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins

Aliases
ALCOBNT
ALMA
BALLBNT
Beq-Local
BNP2004
...

Homes
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll

TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: Version 8.1
Oracle Database 10g Release 10.1.0.3.0
Oracle Database 10g Release 10.1.0.3.0 - 64bit Production

 

[Marco Kalter]

On Oracle10g a program must be compile "with debug information", otherwise you cannot step into it. To do so, right-click on the object and select "Add debug information".