ORA-04091: table string.string is mutating, trigger/function may not see it

ORA-04091: table string.string is mutating, trigger/function may not see it
Cause: A trigger (or a user defined plsql function that is referenced in this statement) attempted to look at (or modify) a table that was in the middle of being modified by the statement which fired it.
Action: Rewrite the trigger (or function) so it does not read that table.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:38

ORA-04091：表字符串。字符串是mutating，触发器/函数可能看不到它,
.原因：触发器（或在此语句中引用的用户定义的plsql函数）尝试查看（或修改）被触发它的语句所修改的表。,
.操作：重写触发器（或函数），使其不读取该表。,
.

aiaiDBA

13718043309

010-86462881

ORA-04091: table string.string is mutating, trigger/function may not see it

1 个回答

相似问题