ORA-04092:cannotCOMMITinatrigger它是一种自治事务at的标识at是由主事务mt调用但是独立于mt的事务在at被调用执行时mt被挂起在at内部一系列的dml可以被执行并且commit或rollback注意由于at的独立性它的commit和rollback并不影响mt的执行效果 ORA-04092:cannotCOMMITinatrigger...
其中DDL触发器它们会影响多种数据定义语言语句而激发，这些语句有create、alter、drop语句。
ORA-12012: error on auto execute of job 43 ORA-04092: cannot COMMIT in a trigger ORA-06512: at "SYS.USER_LOG_INFO", line 67 ORA-06512: at line 3 --- Error: ORA-04092: cannot COMMIT or ROLLBACK in a trigger Cause: You tried to perform a COMMIT or ROLLBACK in a trigger. This...
Sent: Monday, June 27, 2005 4:11 PM Subject: [indo-oracle] Ora 04092 Cannot commit in a trigger > Hi.., All... > > Please Help me.., > > I have got an error : Ora 04092 Cannot commit in a trigger..., in my database.., > Does any body know what caused the problem......