Skip to Main Content

trigger - must be declared error

marcoJul 19 2011 — edited Jul 19 2011
Hi all,

I'm trying to create trigger:
CREATE OR REPLACE TRIGGER TBI_ID
 BEFORE 
 INSERT
 ON zoo.risk_eval#ctypein
 REFERENCING OLD AS OLD NEW AS NEW
 FOR EACH ROW
BEGIN
  :new.id := zoo.risk_eval_ctypein#id_seq.NEXTVAL;
END;
Here is error message:
ORA-24344: success with compilation error
2/14    PLS-00201: identifier 'ZOO.RISK_EVAL_CTYPEIN#ID_SEQ' must be declared
2/3     PL/SQL: Statement ignored
What I'm missing?
Comments
Post Details
Added on Jul 19 2011
7 comments
976 views