Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Can't drop Procedure

Can't drop Procedure

From: Md Irfan <irfan_pk_at_hotmail.com>
Date: 25 Jun 2002 00:57:52 -0700
Message-ID: <c42168e7.0206242357.184a0e21@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US