17,086
社区成员
发帖
与我相关
我的任务
分享触发器/函数不能读?
写触发器时,老出现下列错误!
003-10-19 15:35:06.666 ORA-04091: 表 SYSTEM.BP_SHIPMENTPLANLINE 发生了变化，触发器/函数不能读
ORA-06512: 在"SYSTEM.BP_SHIPMENTPLANLINE_TRG", line 16
ORA-04088: 触发器 SYSTEM.BP_SHIPMENTPLANLINE_TRG 执行过程中出错
; State=42000; ErrorCode=4091
003-10-19 15:35:06.666 ORA-04091: 表 SYSTEM.BP_SHIPMENTPLANLINE 发生了变化，触发器/函数不能读
ORA-06512: 在"SYSTEM.BP_SHIPMENTPLANLINE_TRG", line 16
ORA-04088: 触发器 SYSTEM.BP_SHIPMENTPLANLINE_TRG 执行过程中出错
; State=42000; ErrorCode=4091
...全文
请发表友善的回复…
发表回复
chanet 2004-01-10
- 打赏
- 举报
可以看一下你的触发器代码吗？
shipatrioc 2004-01-10
- 打赏
- 举报
谢谢牧师，问题我已经知道了，就是在一个表里的行级触发器里，不能再对该表进行查询！
shipatrioc 2004-01-09
- 打赏
- 举报
能具体谈谈什么叫“按变异表方式处理! ”吗？
yangqingdelphi 2003-10-20
- 打赏
- 举报
按变异表方式处理!
tolywang 2003-10-20
- 打赏
- 举报
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.
================================================================================
ORA-06512 at stringline string
Cause: Backtrace message as the stack is unwound by unhandled exceptions.
Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or database administrator.
=================================================================================
ORA-04088 error during execution of trigger 'string.string'
Cause: A runtime error occurred during execution of a trigger.
Action: Check the triggers which were involved in the operation.
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.
================================================================================
ORA-06512 at stringline string
Cause: Backtrace message as the stack is unwound by unhandled exceptions.
Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or database administrator.
=================================================================================
ORA-04088 error during execution of trigger 'string.string'
Cause: A runtime error occurred during execution of a trigger.
Action: Check the triggers which were involved in the operation.
bzszp 2003-10-20
- 打赏
- 举报
行级触发器中对出发的表进行操作就有这样的问题
通过包来处理
通过包来处理
tolywang 2003-10-20
- 打赏
- 举报
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.
================================================================================
ORA-06512 at stringline string
Cause: Backtrace message as the stack is unwound by unhandled exceptions.
Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or database administrator.
=================================================================================
ORA-04088 error during execution of trigger 'string.string'
Cause: A runtime error occurred during execution of a trigger.
Action: Check the triggers which were involved in the operation.
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.
================================================================================
ORA-06512 at stringline string
Cause: Backtrace message as the stack is unwound by unhandled exceptions.
Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or database administrator.
=================================================================================
ORA-04088 error during execution of trigger 'string.string'
Cause: A runtime error occurred during execution of a trigger.
Action: Check the triggers which were involved in the operation.
sbigwolf 2003-10-19
- 打赏
- 举报
WRNS 看文档，这是一个读写纯层。WRNS
