ORA-20000: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD

From: Charlie Mengler <charliem_at_mwh.com>
Date: Thu, 01 Mar 2001 11:23:52 -0800
Message-ID: <F001.002C1269.20010301105051@fatcity.com>

Oracle V7.3.4.3 on V2.6 Solaris
For all practical purposes "MWH" owns all objects in this application. AFAIK The object does exist as shown below and as the owner and with CREATE ANY PROCEDURE priv MWH should be able to compile it.

So why do I keep getting these ORA-20000 errors?????????????????????

SQL> exec dbms_ddl.alter_compile('TRIGGER',user,'CDH_AFT_UPD_ROW'); begin dbms_ddl.alter_compile('TRIGGER',user,'CDH_AFT_UPD_ROW'); end;

*

ERROR at line 1:
ORA-20000: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1

SQL> sho user
user is "MWH"
SQL> exec dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); begin dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); end;

*

ERROR at line 1:
ORA-20000: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1

SQL> select * from user_objects where object_name = 'CDH_AFT_UPD_ROW'; #:-)

OBJECT_NAME

OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_ ---------- ------------- --------- --------- TIMESTAMP

STATUS

CDH_AFT_UPD_ROW
49325 TRIGGER 14-MAR-99 01-MAR-01 2001-03-01:10:19:34
VALID SQL> connect sys/pass
Connected.
SQL> grant execute on dbms_ddl to MWH;

Grant succeeded.

SQL> connect mwh/pass
Connected.
SQL> exec dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); begin dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); end;

*

ERROR at line 1:
ORA-20000: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1

SQL> connect sys/pass
Connected.
SQL> grant create any procedure to MWH;

Grant succeeded.

SQL> connect mwh/pass
Connected.
SQL> exec dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); begin dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); end;

*

ERROR at line 1:
ORA-20000: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: charliem_at_mwh.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Mar 01 2001 - 13:23:52 CST