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

Home -> Community -> Mailing Lists -> Oracle-L -> TRIGGER COMPILE problem .. looks EASY ??

TRIGGER COMPILE problem .. looks EASY ??

From: <bruce.taneja_at_mcd.com>
Date: Fri, 26 Jan 2001 10:36:11 -0600
Message-Id: <10753.127599@fatcity.com>


I did a full import from 8.0.6 to 8.1.7..

Here is the trigger that fails to compile:

  1 create or replace trigger TRG.TBMDPMODBSIUD   2 before insert or update or delete on TRG.TBMDPMOD   3 declare
  4 begin
  5 sys.inf_product_check;
  6* end;
SQL> / Warning: Trigger created with compilation errors.

SQL> show errors
Errors for TRIGGER TRG.TBMDPMODBSIUD:

LINE/COL ERROR

-------- -----------------------------------------------------------------
3/1      PLS-00201: identifier 'SYS.INF_PRODUCT_CHECK' must be declared
3/1      PL/SQL: Statement ignored
Received on Fri Jan 26 2001 - 10:36:11 CST

Original text of this message

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