Dubeg on oracle 10g RAC

[Xiaojun]

Can anyone tell me how to dubeg a stored procedure on oracle 10g RAC?

Thx

 

[Marco Kalter]

The debugger works from within the Test Window. Just select a procedure or function in the Object Browser, right-click on it, and select the 'Test' item from the popup menu. Now you can set values for the parameters, and press the Start Debugger (F9) button in the toolbar of the Test Window. Now you can step through your code, set breakpoints, view or set variable values, and so on. See chapter 4 in the User's Guide for more details.

 

[Xiaojun]

Hi Marco, I have no problem to debug a stored procedure in oracle 9i and 10g. But I don

 

[Kram]

Same for me...when I first log into the RAC and test the procedure in the debugger all is fine. Change the procedure, compile, refresh the procedure and test again. Now it hangs.

Then you start getting into some of the other issues reported in other threads where you cannot "Break (Shift+Esc)" out of the test window. You have to quit using the Task Manager.

If I do the same process connected to an explicit node then it works perfectly. I am using 7.0.1 in XP.

 

[rbrooker]

try connecting to a single instance of the cluster for debug purposes...

 

[Grisa]

Hi,

I tried to use only one instance, but faced the debugger was still hanging. Any other options?
Oracle 10G, client 9.2

 

[Nico Scholtz]

We experience the same problem. We have also tried connecting to a single instance but same problem.

Any suggestions out there?