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

Unexplained daily errors

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
This was last published in November 2004

Dig Deeper on Oracle database design and architecture

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