oracle不能操作触发器所在表的数据。 ORA-04091 table string.string is mutating, trigger/function may not see itCause: A trigger (or a user defined PL/SQL 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.
1。用行级before得到要删除的行
2。将其保存在包的变量里面。
3。在语句级触发器里面删除。