Compilation Lockup

Please help save me from myself. I frequently try to recompile packages while they are in use elsewhere, such as in a scheduled job. This causes Toad to hang, even if the Cancel button is pushed. Can you check to see if the package/procedure/function or view is in use and give me a "Really? You really want to do this?" warning? This would save me a lot of grief resetting things after I make the mistake.

Hi Brian,

What version are you on? I fixed something very similar a few versions ago.

-John

16.0.90.1509

Toad for Oracle Xpert (64-bit)

Add Ons: DB Admin Module

~WRD000.jpeg

I don't see a great way in the data dictionary to tell if a package is in use. All I see on the internet is various ways of looking at currrent SQL of different sessions and trying to determine if there is a package call in there.

John,

I may have found a way: I set up a long running job and then searched DBA_DDL_LOCKS:

SELECT * FROM DBA_DDL_LOCKS WHERE OWNER = 'AMIADM' AND NAME = 'RAWLOAD_INTERVAL_PKG';

~WRD000.jpeg

Ah. Good call. I'll explore that soon. Will probably make it an option.