Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error at recursive SQL level

I am getting these errors: "ERROR: ORA-00604: error occurred at recursive SQL level 1"; "ORA-04092: cannot COMMIT in a trigger"; "ORA-06512: at line 3."

I am getting these errors:
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 2
Thanks in advance for your assistance.
Some action you are performing causes a trigger to fire. That trigger has a COMMIT clause in the code, which is an illegal operation. You can determine which trigger has the COMMIT clause in it by the following query:
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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close