java.sql.SQLException: Missing IN or OUT parameter at index::

[Sri Ram]

Hi ranchers,

I have a prepared statement, which is fired in loop for some 15 records. But for some recs it updates properly, and others it fails, giving me this above exception.

  
 
java.sql.SQLException: Missing IN or OUT parameter at index:: 54
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.driver.OracleStatement.checkBindsInAndOut(OracleStatement.java:1951)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2792)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
        at com.pramati.resource.njdbc.xa.PramatiPreparedStatement.executeUpdate(PramatiPreparedStatement.java:56)
        at com.pramati.resource.njdbc.xa.ClientPreparedStatementWrapper.executeUpdate(ClientPreparedStatementWrapper.java:60)
  

but the second time the loop runs, the data base is getting updated properly. I tried in google and in this bar also. But failed to get the proper explanation for this. Please help me guys.

[Sivaraman Lakshmanan]

Hi,

Before executing the query print them out and try them running seperately in database and see if you are missing any of the inputs. Did you check the 54th index on the failing query to find anything missing?

[Sri Ram]

Hi,

If i try with one record, it goes thro properly. I mean no exceptions at all.

This exception is coming only few times, if i update some 20 records, i get this for some 5 or 6 records only. Sometimes no exceptions are coming.

[Abhi Vuyyuru]

Can you post the code for the loop.