ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword ORACLE 报错 故障修复 远程处理

文档解释

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