Tuesday, February 2, 2021

[java][Resolved] java.SQL.Exception: Invalid column index

 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