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!

BatchUpdate with PreparedStatement giving Missing IN or OUT parameter at i

843854Jun 24 2002 — edited Dec 26 2002

Hi,
when i am using BatchUpdates with PreparedStatement,after some trnsactions i am getting an error

java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.driver.OracleStatement.checkBindsInAndOut(OracleStatement.java:1183)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:3095
)
at weblogic.jdbc.jts.Statement.executeBatch(Statement.java:146).
First Transaction with this works fine but in the second transaction it gives this exception.can any one solve this problem.

Thanks in Advance,
Vamsi.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 23 2003

Added on Jun 24 2002

#java-database-connectivity-jdbc

8 comments

387 views