I am getting the following error while the application is doing insert/update operations:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
ORA-00604: error occurred at recursive SQL level 1 ORA-00942: table or view does not exist
However, the application is working fine while doing select operations.
This is a Java application, and it is using the JDBC to connect to the Oracle 8.1.7 server. I have done the update operation through the SQL*Plus prompt, and it is working fine.
In order to fix this problem, you'll have to know which recursive SQL statement is causing the ORA-00942 error message. I just covered this topic last week in the following question:http://searchoracle.techtarget.com/ateQuestionNResponse/0,289625,sid41_cid608827_tax294550,00.html
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.