Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: ORA-01008: not all variables bound

ksunilJan 28 2016 — edited Feb 23 2016

completely out of the blue, we have a client that reports the above error. It is on AIX, oracle 12.1.0.2. Code has been around for a long time. Only 1 variable is bound in this particular SQL. Is there anything that I can suggest? This has to be local database issue. I just don't want to change the code from a PreparedStatement to a simple Statement just to accommodate 1 client issue (out of 500+ clients running code over number of years)

I have searched in the bug database and no matches! Is flushing shared_pool a good idea here?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 22 2016

Added on Jan 28 2016

#java-database-connectivity-jdbc

20 comments

6,566 views