Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot drop a procedure
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