ERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-04092: cannot COMMIT in a trigger ORA-06512: at line 3 Warning: You are no longer connected to ORACLE. ERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "SYS.UTL_FILE", line 120 ORA-06512: at "SYS.UTL_FILE", line 204 ORA-06512: at "SCOTT.LOG_TXT", line 8 ORA-06512: at line 2Thanks in advance for your assistance.
SELECT owner,name FROM dba_source WHERE type='TRIGGER' AND UPPER(text) LIKE '%COMMIT%';Recode the trigger to remove the COMMIT statement and your operation should not hit the ORA-4092 error.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.