- 论坛徽章:
- 0
|
原代码如下:
cstmt = con.prepareCall("{call spName(?,?,?,?,?,?,?,?,?,?)}");
cstmt.setInt(1, Integer.valueOf("99031").intValue());
cstmt.setString(2, ffmcenterid);
cstmt.registerOutParameter(3,Types.VARCHAR);
cstmt.registerOutParameter(4, Types.VARCHAR);
cstmt.registerOutParameter(5, Types.VARCHAR);
cstmt.registerOutParameter(6, Types.VARCHAR);
cstmt.registerOutParameter(7, Types.INTEGER);
cstmt.registerOutParameter(8, Types.VARCHAR);
cstmt.setInt(9, 100);
cstmt.setString(10, "");
cstmt.execute();
错误如下:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0420N Invalid character found in a character string argument of the function "INTEGER". SQLSTATE=22018 |
|