Erorr message:
java.SQL.Exception: Invalid column index
source code:
cstmt = (OracleCallableStatment) con.prepareCall('BEGIN SP_TEST(?,?,?,?,?,?,?)');
cstmt.setInt(1,40030485);
cstmt.setString(2,"filepath");
cstmt.setString(3,"%/temp/%");
cstmt.setString(4,"Y");
cstmt.registerOutParameter(5,OrcaleTypes.NUMBER);
cstmt.registerOutParameter(6,OrcaleTypes.DECIMAL);
cstmt.registerOutParameter(7,OrcaleTypes.VARCHAR);
cstmt.registerOutParameter(8,OrcaleTypes.CURSOR);
For my case, it looks the I called store procedure with incorrect parameters, and the error not related to column :
cstmt = (OracleCallableStatment) con.prepareCall('BEGIN SP_TEST(?,?,?,?,?,?,?,?)');
cstmt.setInt(1,40030485);
cstmt.setString(2,"filepath");
cstmt.setString(3,"%/temp/%");
cstmt.setString(4,"Y");
cstmt.registerOutParameter(5,OrcaleTypes.NUMBER);
cstmt.registerOutParameter(6,OrcaleTypes.DECIMAL);
cstmt.registerOutParameter(7,OrcaleTypes.VARCHAR);
cstmt.registerOutParameter(8,OrcaleTypes.CURSOR);
No comments :
Post a Comment