"Add debug Information" hangs ?

[ams]

Hello Marco,

I gave the PLSD 30-day-installation to my collegue with the words "Try it, it's fantastic !"
Today he does and has the following effect:

When he wants to "Add debug information" to a package or function or procedure (right mouse click, Add ...) he gets the waiting cursor forever.

The database is 8.1.4.7.

Do you have a hint for him (and me)

Thank you

Regards
Andree

 

[Marco Kalter]

There are 3 possibilities:

1. The object is currently used (executed) in another session. In this case you cannot recompile the object (which is what "add debug information" does) until execution in the other session stops. The default time-out for such a lock is 10 minutes though, so it shouldn't be "forever".

2. The package/procedure/function has something that the Oracle Debugger "does not like". You can verify this in SQL*Plus by typing:

SQL> alter function your_function compile debug;

or

SQL> alter package your_package compile debug body;

3. There is a client/server compatibility issue. To verify, go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply.

 

[ams]

Hello Marco,

this morning we tried to apply your hints. But ... seems that everything is ok overnight. Compiling with PLSD as well as "Add debug information" worked well without any change. So I presume that your no. 1 proposal (object currently in use) was the one, because the others cannot vanish without a change... but in fact I don't know.

[My collegue told me that after killing the PLSD session he had had to restart the whole database to be able to work on with it. The Datebase was 8.1.7.4, not 8.1.4.7]

Thank you very much again !
Regards
Andree