文档解释
ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword
Cause: The trigger statement is missing the BEFORE/AFTER/INSTEAD OF clause.
Action: Specify either BEFORE, AFTER or INSTEAD OF.
?
ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword
官方解释
为了创建或修改触发器,必须使用 BEFORE、AFTER 或 INSTEAD OF 关键字之一,表明该触发器将在什么条件下触发。
常见案例
create table trigger on table_name
after update or delete
begin
…
end
正常处理方法及步骤
1. 在 “after update or delete” 之前加入关键字 AFTER:
create table trigger on table_name
after after update or delete
begin
…
end
2. 补全完整的触发器语句:
create trigger trigger_name
on table_name
after update or delete
as
begin
…
end