At least once a day I get this error:
DBD::Oracle::db prepare failed: ORA-00604: error occurred at recursive SQL level 1
This error is followed by:
ORA-00932: inconsistent datatypes (DBD ERROR: OCIStmtExecute/Describe) at /Sites/ugas.com/cams/admin/adminbody line 1395.It is never in the same table twice. It happens on selects as well as inserts. Once the condtion occurs on a table, you can reproduce it by running the query in a script. But as soon as you run the same query in SQL*Plus, the problem goes away.
Unfortunately, the above errors do not give you any indication as to the exact SQL statement that is causing the error. In a previous question, I discussed how to use Oracle tracing to determine exactly which recursive SQL statement is causing your problem. You can find that answer here:https://searchoracle.techtarget.com/answer/ORA-00604-error-with-recursive-SQL