java.sql.SQLException: Incorrectly set or registered parameters.

来源:互联网 发布:mac ai解除锁定快捷键 编辑:程序博客网 时间:2024/06/16 02:28
before:

OracleCallableStatement oracall = (OracleCallableStatement) con.prepareCall("? = call mytest1(?); end;");
oracall.setString("test1", "Test");
oracall.registerOutParameter(1,Types.INTEGER);
oracall.execute();


after:

CallableStatement.cStmt = conn.prepareCall("BEGIN ? := mytest1(test1=>?); END;");
cStmt.registerOutParameter(1, Types.INTEGER);
cStmt.setInt(2, 23);

原创粉丝点击