Re: Cannot drop a procedure

From: joseph Li <lijoecyn_at_netspace.net.au>
Date: 13 May 1998 12:38:19 GMT
Message-ID: <6jc47r$e1q$2@otis.netspace.net.au>

Have a look at the view DBA_DDL_LOCKS as well. This view is defined within CATBLOCK.sql . Looks like somebody is still using the procedure.

Regards
Joe

In article <6ja553$fgf_at_news.Hawaii.Edu>, kittu_at_Hawaii.Edu (Chakravarthy KM Nalamotu) says:
>
>Hello Oracle Users,
>When I try to drop a procedure, it just hangs there,
>and does nothing. I checked the locks throught EM,
>couldn't find anything specific. Please let me know
>if you have come across a smililar situation before,
>or if I am missing something.
>Thanks,
> Kittu.
>
Received on Wed May 13 1998 - 07:38:19 CDT