Skip to Main Content

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2016
Added on Jan 28 2016
20 comments
6,564 views