It's possible that this package is being called by some program now.

If possible, bounce the db and then drop the package. Or you need to
identify which program is calling this anf stop the program.

You can also call "deptree_fill" to find the dependancy tree stuff on this
package.

HTH.

Guang


----- Original Message -----
From: ""Lages, Carl"" <[Email Address Removed] Friday, August 31, 2001 2:10 PM
Subject: cannot drop package


>Hi,
>I am trying to drop a package and my session just hangs. I have tried using
>toad and sql*plus and from different pc's. I also tried to create or
>replace
>the package and that just hangs also. I have the correct permissions. I
>checked for a lock onthe object but there were none. What else could I try?
>The sql is fine because if I try to create the package under a different
>name it works.
>Thanks in advance,
>Carl


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Oracle LazyDBA home page