错误现象为:
The following error has occurred:ORA-04091: table EXTUSER.SN_PN is mutating, trigger/function may not see it
ORA-06512: at "EXTUSER.SN_PN_UPDATE", line 2
ORA-04088: error during execution of trigger 'EXTUSER.SN_PN_UPDATE'
The following error has occurred:ORA-04091: table EXTUSER.SN_PN is mutating, trigger/function may not see it
ORA-06512: at "EXTUSER.SN_PN_UPDATE", line 2
ORA-04088: error during execution of trigger 'EXTUSER.SN_PN_UPDATE'
解决方案 »
- ORACLE中sql语句问题,麻烦大侠给指点一下!
- 3个以上inner join,是否会减低效率?
- 请教大侠,在oracle中,什么是machine arithmetic,什么是library arithmetic啊
- 急招ORACLE高手,优化人员!
- 求一语句,取得不重复数字的最小值
- oracle服务器安装后,其他计算机通过配置本地网络服务名访问该服务器时,总是无法连接成功!
- 请问如何将Oracle的SQL脚本的执行结果存到一个文件里?
- ORACLE查询
- 请关注:Oracle中日志的问题。
- oracle第一次安装后启动和监听问题
- select * from dba_users where ...的奇怪问题?
- 关于report的问题--非法的打印条件?
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.
before update on sn_pn
for each row
begin
:new.record_time:='sysdate' ;
end sn_pn_update;
TRIGGER extuser.sn_pn_update
before update on sn_pn
for each row
begin
:new.recoder_time='sysdate';
/*
或用
select sysdate into :new.recoder_time from daul;
*/
end;