Caused by: java.sql.SQLException: 索引中丢失 IN 或 OUT 参数:: 2

来源:互联网 发布:h5免费制作软件 编辑:程序博客网 时间:2024/06/10 23:56

Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 2
        at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1821)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3579)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1205)
        at com.huawei.imp.db.DB.query(DB.java:236)
        ... 30 more

 

我出现这个错误的原因是:传入的参数个数与查询语句的条件个数不一致!