Trigger -- invalid identifier?
606275Sep 15 2009 — edited Sep 16 2009Why am I receiving the following error for the following trigger?
"PL/SQL: ORA-00904: "N_ROW"."ID":invalid identifier
CREATE TRIGGER DELETE_ROW
AFTER INSERT ON SCHEMA1.TABLE1 REFERENCING NEW AS N_ROW
FOR EACH ROW
WHEN (N_ROW.FILE_SIZE > 2000000)
BEGIN
DELETE FROM SCHEMA1.TABLE1 WHERE ID = N_ROW.ID;
END;
Note: the column "ID" does exist in the referenced table