DBA trigger view problem

From: Tom <cmc3232_at_yahoo.com>
Date: Sat, 21 Jul 2001 21:34:52 GMT
Message-ID: <S9t37.36317$gb6.4188463@news20.bellglobal.com>

I have an user account have read access to dba_triggers table from SQLplus. However, try to compile a package with a function using the same select statement that I use in SQLplus. It gave an error.

Her is the finding:

SQL> select * from all_objects where object_name ='DBA_TRIGGERS';

OWNER      OBJECT_NAME                     OBJECT_ID OBJECT_TYPE  CREATED

LAST_DDL_

---------- ------------------------------ ---------- ------------ --------- 
---------
SYS        DBA_TRIGGERS                          799 VIEW         13-OCT-99
13-OCT-99
PUBLIC     DBA_TRIGGERS                          800 SYNONYM      13-OCT-99
13-OCT-99
SYSTEM     DBA_TRIGGERS                         1043 SYNONYM      13-OCT-99

13-OCT-99 SQL> @util.sql
Package created.
No errors.
Warning: Package Body created with compilation errors. Errors for PACKAGE BODY UTIL:

LINE/COL ERROR

-------- -----------------------------------------------------------------

494/7 PL/SQL: SQL Statement ignored
495/12 PLS-00201: identifier 'SYS.DBA_TRIGGERS' must be declared SQL> Here is the statement:

 SELECT table_name into tmp_tab_cnt

      FROM dba_triggers
      WHERE table_name = tabname
      AND trigger_name like '%_EPPG_AI%'
      ;

What has clobber up ? The View owed by SYSTEM, the synonym owned by PUBLIC ?

Thanks for any help. Received on Sat Jul 21 2001 - 16:34:52 CDT