File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Not All Varialbes Bound Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Not All Varialbes Bound Error" Watch "Not All Varialbes Bound Error" New topic

Not All Varialbes Bound Error

JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
My code worked OK until I changed this statement:


I got the runtime error:

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

at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.ttc7.TTIoer.processError(
at oracle.jdbc.ttc7.Oall7.receive(
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
at org.dhsinfo.message.dao.OracleRecipientDAO.findRecipients(
... 32 more

My looks like:
JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
never mind. I have found the mistake.
I agree. Here's the link:
subject: Not All Varialbes Bound Error
It's not a secret anymore!