select … ,Technician,DesignerDateRcvd,TechDateRcvd FROM tablename WHERE State != ? ORDER BY xyz
Exception in thread "main" java.sql.SQLException: ORA-01008: not all variables bound
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1362)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:369)
at com.att.DB.DBConnectTest.CountT1s(DBConnectTest.java:203)
at com.att.DB.DBConnectTest.main(DBConnectTest.java:290)
Caused by: Error : 1008, Position : 0, Sql = select Technician,DesignerDateRcvd,TechDateRcvd FROM tablename WHERE State != :1 ORDER BY ProjectId, OriginalSql = select echnician,DesignerDateRcvd,TechDateRcvd FROM tablename WHERE State != ? ORDER BY ProjectId, Error Msg = ORA-01008: not all variables bound
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
... 14 more
when i am binding one value am getting the above error.
Could you please help me to resolve the issues.