文档解释 ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyWord Cause: The trigger statement is missing the BEFORE/AFTER/INS
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
--结束END--
本文标题: ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword ORACLE 报错 故障修复 远程处理
本文链接: https://www.lsjlt.com/news/525248.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0