Helene
Member³
A while ago we changed the property setting session.statementCache to True. After that some strange errors started to appear in one of our applications. This application creates a temporary table, and drops the table after use. It works fine the first time, but if this process is repeated, Oracle reports an ORA-00942 error: Table does not exist. Using Oracle Monitor you can actually see that the table is created just before this error message appears. If the statementcache is disabled, the error does not occur.
I suppose the easiest way to fix the error in this case would be to move the table dropping statement to the destructor, and replace it with a table truncate statement - or just leave the statementCache setting to false.
With regards
Helene
I suppose the easiest way to fix the error in this case would be to move the table dropping statement to the destructor, and replace it with a table truncate statement - or just leave the statementCache setting to false.
With regards
Helene
