一個觸發器試圖修改或查詢目前正在觸發器語句修改的表。建議改一下你的觸發器邏輯。

網上也有解釋:

error:

ora-04091: table name is mutating, trigger/function may not see it

cause:

a statement executed a trigger or custom pl/sql function. that trigger/function tried to modify or query a table that is currently being modified by the statement that fired the trigger/function.

action:

the options to resolve this oracle error are:

rigger/function so that it does not try to modify/query the table in question.

for example, if you've created a trigger against the table called orders and then the trigger performed a select against the orders table as follows:

create or replace trigger orders_after_insert

after insert

on orders

for each row

declare

v_quantity number;

begin

select quantity

into v_quantity

from orders

where order_id = 1;

end;

you would receive an error message as follows:

when you create a trigger against a table, you can't modify/query that table until the trigger/function has completed.

remember that you can always use the :new and :old values within the trigger, depending on the type of trigger.

總結

以上是生活随笔為你收集整理的oracle数据库视图有红叉,oracle触发器 前面的红叉是什么意思的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。