General Database Discussions

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;

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