Err on after update trigger
the code I've tried so far is:
CREATE OR REPLACE TRIGGER New_Emp_Ver_add
after update
on hr.per_addresses
for each row
begin
insert into NEO_EMP_VERIFICATION_add
(ADDRESS_LINE_1,
ADDRESS_LINE_2,
TOWN_OR_CITY,
REGION_2,
POSTAL_CODE)
VALUES
(OLD.ADDRESS_LINE_1,
OLD.ADDRESS_LINE_2,
OLD.TOWN_OR_CITY,
OLD.REGION_2,
OLD.POSTAL_CODE);
END;
the old.xxx is obviously the value of the data before it was updated,
I keep getting the error '13/9 PL/SQL: ORA-00984: column not allowed here'
in the values section.