ORA-04092: cannot COMMIT in a trigger
来源:互联网 发布:怎么查淘宝卖家的地址 编辑:程序博客网 时间:2024/05/18 01:40
触发器不能调用或间接调用COMMIT,ROLLBACK等DCL语句
一: 在触发器中使用DDL语句.触发的时候会报错,ORA-04092: cannot COMMIT in a trigger,因为DDL语句隐含commit.
二: 触发器的主体中使用了commit或rollback等DCL语句.ORA-04092:
cannot COMMIT in a trigger , 因为DML(delete/update/insert)触发器中
不能使用DDL(CREATE,DROP,ALTER)语句,也不能使用事务控制语句(DCL)
(ROLLBACK, COMMIT,SAVEPOINT).特别注意的是,在触发器的主体中引用的
函数(function)/过程(procedure)中也不能有事物控制语句.
三: 注意: 系统级触发器(System Triggers)中可以使用DDL语句.
四: 处理方法: 去掉事务控制语句;如果procedure中必须有commit,那么可以
将commit 拿掉,由外部控制.
- ORA-04092: cannot COMMIT in a trigger
- ORA-04092: cannot COMMIT in a trigger错误的解决
- ORA-20782: Cannot DROP object used in Oracle GoldenGate replication while trigger is enabled
- Git remove a file in a commit
- cannot change NEW values for this column type in trigger
- [Git] Fatal: cannot do a partial commit during a merge
- git Fatal: cannot do a partial commit during a merge
- [Git] Fatal: cannot do a partial commit during a merge
- [Git] Fatal: cannot do a partial commit during a merge
- cannot do a partial commit during a merge
- cannot do a partial commit during a merge.
- Git- Fatal: cannot do a partial commit during a merge
- ORA-14551: cannot perform a DML operation inside a query
- ORA-14551: cannot perform a DML operation inside a query
- ORA-14551: cannot perform a DML operation inside a query
- ora-14551 cannot perform a DML operation inside a query
- mysql触发器报错 1422 Explicit or implicit commit is not allowed in stored function or trigger.
- Change the author of a commit in Git
- JAVA从MQ读取消息的时候报错及解决
- 程序语言性能比拼
- ERwin Data Modeler 建模实践
- 面向对象的三个基本特征
- libevent源码深度剖析八
- ORA-04092: cannot COMMIT in a trigger
- MERGE JOIN CARTESIAN
- 关于gets的问题
- 超强:Unix道德经(英文版)
- 50 words in a passage
- 关于select option自定义标签的说明
- SIFT转来的
- AjaxControltoolkit学习笔记—Rating 使用详解 (asp.net C#)
- 廉颇老矣,就地更衣,名将出品,纵臭也香!