Intermittent Occurrences of Repeating ORA-01006 and/or ORA-01008 Errors after ORA-01013 from Query Timeout (Doc ID 1073459.1)

Symptoms

An application runs in a version 1.5 JVM on a WebLogic application server and connects to a version 10.2.0.4 database via JDBC/Thin 11.1.0.7 ojdbc5.jar. The application uses connection pooling, WebLogic statement caching, and setQueryTimeout.

Intermittently, a prepared statement fails with
either
     java.sql.SQLException: ORA-01006: bind variable does not exist
or
     java.sql.SQLException: ORA-01008: not all variables bounded

Once an error occurs it repeats, continuing to occur on future logical connections that use the same physical connection and run the same query as the logical connection on which the error first occurred.

Sometimes only ORA-01006 errors occur.
Sometimes only ORA-01008 errors occur.
Sometimes ORA-01006 and ORA-01008 errors alternate. In this case, two prepared statements are involved.

The ORA-01006 and/or ORA-01008 errors are always preceded by one or more "ORA-01013: user requested cancel of current operation" errors due, either primarily or exclusively, to queries timing out (the expected behavior of setQueryTimeout).

The ORA-01006 and ORA-01008 errors do not occur when WebLogic statement caching is not used.

Changes

Cause