Cannot Debug Procedures

[Aninha]

Hello, guys!

I'm trying to debug a procedure in PL/SQL but it's not working. See the steps that I'm proceding bellow:

1) Mouse's right click in procedure's name;
2) Check "Add debugging information" option;
3) Mouse's right click in procedure's name again;
4) Click "Test" option;
A Test Script window open and I fill value field (parameter);
5) Click "Start Debugger";

When I finish theses steps, the window remains in executing status (but nothing has executed I'm sure!);

Although I had choose debug option, Step over/in buttons remains disabled and the window apparently froze.

It is very hard to cancel this execution (I'm clicking Session -> break option but it takes a very long time to cancel the process).

Rarely, the same steps described works for a moment, in an specific trying, but when I repeat it, it doesn't working anymore...

IT IS VERY ODD!

HELP!

PL/SQL Information

Version 8.0.1.1498
Windows XP Professional 5.1 Build 2600 (Service Pack 3)
Oracle 10g DB

 

[Marco Kalter]

Can you update to 8.0.4 and try again?

 

[Aninha]

Hi, Marco!

I'm new in this forum and I didn't receive any warnings to check your message.

This whole week was Carnival in Brazil and that's why I spent so many time to reply you.

I'll update right now and then send you a feedback.

Thanks for your help.

 

[Aninha]

Marco, just one more question: Can be a higher version?

 

[Gustavo]

Hi, Ana,

You can try with a later version, no problem. BTW, are you connecting to a RAC-enabled instance?

Regards,
Gustavo

 

[DeerMusic]

Gustavo,

I'm working with a RAC-enabled instance. How might that be relevant to the debugger problem?

Thanks!

// Jack

 

[Gustavo]

Hi, Jack,

Marco has reported that there is a problem in the way Oracle API makes calls to the database while debugging on RAC.

"The Oracle Debug API (sys.dbms_debug) internally uses dbms_pipe messages to communicate between the controlling session and the debug session, which apparently can fail on RAC systems. The only workaround is to modify the tnsnames.ora file to connect to only 1 node of the cluster without load balancing and failover."

Regards,
Gustavo

 

[DeerMusic]

Many thanks, Gustavo!

 

[Gustavo]

You're welcome!