ORA-04092 是一个在 Oracle 数据库中常见的错误,通常与触发器(Trigger)中的事务控制语句相关。以下是对该错误的详细解释: 1. 什么是ORA-04092错误 ORA-04092 错误信息为 "cannot COMMIT in a trigger",意味着在触发器的执行过程中尝试执行了 COMMIT 操作,这是不被允许的。触发器是数据库中的一
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...
> I have got an error : Ora 04092 Cannot commit in a trigger..., in my database.., > Does any body know what caused the problem...? > > I have already checked my trigger..and rewrite its, but i dont find a "commit " syntax in my PL/SQL blocks(trigger scripts). >...