ORA-04084: cannot change NEW values for this trigger type

Error: ORA-04084: cannot change NEW values for this trigger type

Cause: New trigger variables can only be changed in before row insert or update triggers.

Action: Change the trigger type or remove the variable reference.

Example:

create table a(id number,ROWCHANGEDATE date);

CREATE OR REPLACE TRIGGER a_UPDATE

AFTER UPDATE ON a

REFERENCING NEW AS NEW OLD AS OLD

FOR EACH ROW

BEGIN

:NEW.ROWCHANGEDATE:=sysdate;

END;

/

ERROR at line 1:

ORA-04084: cannot change NEW values for this trigger type

Change the trigger type from after to before:

CREATE OR REPLACE TRIGGER a_UPDATE

BEFORE UPDATE ON a

REFERENCING NEW AS NEW OLD AS OLD

FOR EACH ROW

BEGIN

:NEW.ROWCHANGEDATE:=sysdate;

END;

/

Trigger created.