I got “ORA-00604: error occurred at recursive SQL level string ” error in Oracle database.
ORA-00604: error occurred at recursive SQL level string
Details of error are as follows.
ORA-00604: error occurred at recursive SQL level string Cause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables). Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support.
error occurred at recursive SQL level string
This ORA-00604 error is related with the error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).
If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support.
If the error is related with the trigger, you can disable the trigger as follows.
alter trigger <trigger_name> disable;
You can disable to run all triggers executing the following parameters as follows.
alter system set "_system_trig_enabled"=FALSE;
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )