ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ora-04091错误

ora-04091错误

原创 Linux操作系统 作者:junsansi 时间:2007-07-20 00:00:00 0 删除 编辑
ORA-04091 table string.string is mutating, trigger/function may not see it

Cause: 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.

今天遇着这个问题,网上搜索了半天,最后同事的提醒下想明白了,行级触发器不能触发读取或修改变化的表(正在修改、插入)

记录一下,以后要注意~~~


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7607759/viewspace-22264/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 发水啦~~~~
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-21

  • 博文量
    640
  • 访问量
    4126003