ORA-04091: table name is mutating, trigger/function may not see it.
来源:互联网 发布:仿生活家家居网站源码 编辑:程序博客网 时间:2024/05/17 15:04
trigger中dll部分是不能对包含该trigger的基表进行操作的,不然就会出现该错误
引申:所以,通过trigger和select for update来锁定行数据是不可行的;比较简单的方法是,对需要行锁定的数据加外键
- ORA-04091: table name is mutating, trigger/function may not see it.
- trigger抛出异常ORA-04091:table ...... is mutating, trigger/function may not see it
- ORA-04091: table XXXX is mutating, trigger/function may not see it
- 错误"ORA-04091: table is mutating, trigger/function may not see it"的原因以及解决办法
- ORA-04091: table is mutating, trigger/function may not see it
- 关于错误:"ORA-04091: table is mutating, trigger/function may not see it"的分析(触发器操作自身表)
- 关于错误:"ORA-04091: table is mutating, trigger/function may not see it"的分析(触发器操作自身表)
- 关于错误:"table is mutating, trigger/function may not see it
- Oracle触发器报错table xxxx is mutating,trigger/function may not see it
- ora-04091 mutating table
- ORA-01765 specifying table's owner name is not allowed
- 關於觸發器(Trigger)對於變異表(Mutating table)的操作
- mysql 触发器的问题 Can't update table 'tbl' in stored function/trigger because it is already used by state
- Can't update table 'psxt_user' in stored function/trigger because it is already used by statement wh
- Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/t
- ORA-30553: The function is not deterministic
- [datapump] ORA-39034: Table TABLE_DATA:<table Name> does not exist.
- MySQL触发器更新本表数据异常:Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this
- 利用Openrowset和Opendatasource 入侵的技巧
- Android没有输入焦点类控件的输入法调用
- VBA FileSystemObject 用户定义类型未定义
- SQL INJECTION的终极利器opendatasource和openrowset
- Eclipse不能正常启动,提示错误“JVM terminated. Exit code=-1”
- ORA-04091: table name is mutating, trigger/function may not see it.
- WaitForXXX函数的等待对象~
- 扩展KMP--求母串各后缀和模串的最长公共前缀
- Delphi使用VB开发的ActiveX控件
- Iphone 开发学习笔记(1)--Iphone SDK简介
- 给div添加滚动条
- javascript 替换字符(全部替换) 将/ 替换为//
- javascript 替换字符(全部替换) 将/ 替换为//
- C语言的类型提升