PL/SQL (MOSC)

MOSC Banner

Err on after update trigger

edited Sep 29, 2009 3:47AM in PL/SQL (MOSC) 9 commentsAnswered
 I'm trying to create/compile a trigger to audit changes in employee data,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center