sql - ORA-04079: 无效的触发器规范 -- 行级触发器

Question

我正在尝试创建一个触发器来通知员工姓名何时更改。

 create or replace trigger name_change
 after update on employee_table
 for each row when (old.e_name != new.e_name);
 begin
 dbms_output.putline(:old.e_name || 'changed their name to' || :new.e_name);
 end;

不确定错误来自哪里。

标签： sqloracledatabase-trigger

Answer 1

后面不能有分号when (old.e_name != new.e_name)