Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can't drop Procedure
Hello,
I could not able to drop this procedure.
SVRMGR> select owner, object_name, object_id, object_type from all_objects
2> where object_name='UPDINVDT';
OWNER OBJECT_NAME OBJECT_ID OBJECT_TYPE
----- ------------------------ ---------------------- --------------- SCOTT UPDINVDT 35772 PROCEDURE
1 row selected.
SVRMGR> drop procedure UPDINVDT;
drop procedure UPDINVDT
*
ORA-04043: object UPDINVDT does not exist
SQL> show user
user is "SCOTT"
Thanks ... Received on Tue Jun 25 2002 - 02:57:52 CDT