Is the package currently being executed? Check the
'OBJECT' field of v$access for the package name.

HTH,
-Chris

> -----Original Message-----
> From: Lages, Carl [mailto:[Email Address Removed] Sent: Friday, August 31, 2001 2:16 PM
> To: LazyDBA.com Discussion
> 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
>
>
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

LEGAL NOTICE - Unless expressly stated otherwise, this message is
confidential and may be privileged. It is intended for the addressee(s)
only. Access to this e-mail by anyone else is unauthorized. If you are not
an addressee, any disclosure or copying of the contents or any action taken
(or not taken) in reliance on it is unauthorized and may be unlawful. If you
are not an addressee, please inform the sender immediately.
Oracle LazyDBA home page