Trigger Problem !

    I created a table with the following trigger in Oracle 8.0.3 on a NT machine:

CREATE OR REPLACE TRIGGER "BEF_ROW_UPDT_TS" BEFORE INSERT OR UPDATE OF "DESCRIPTION", "ID" ON "TTABLE" REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW BEGIN :new.LASTUPDTDATE:=SYSDATE;:new.REFCOUNTER:= :old.REFCOUNTER+1;
END ;

    However, when I tried to update the "DESCRIPTION" of "TTABLE", I received the following error message:

SQLSTATE: S1000
Native Error Code: 4098
Driver Message: ORA-04098 'BEF_ROW_UPDT_TS' is invalid and failed re-validation.

    I could not figure out what went wrong ? Please help. Thx. Received on Mon Jun 01 1998 - 00:00:00 CEST