There is a procedure procedure test it works. But when I call it in Java, I get this exception:

aa ERROR kz.test.app.session.MaketSession: error java.sql.SQLException: ORA-06550: Строка 1, столбец 7: PLS-00306: wrong number or types of arguments in call to 'ED_DATA' ORA-06550: Строка 1, столбец 7: PL/SQL: Statement ignored Connection conn = em.unwrap(java.sql.Connection.class); CallableStatement callableStatement = conn.prepareCall("{call x_h_p.ed_data(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )}"); callableStatement.setBigDecimal(1, id); callableStatement.setString(2, gson.getDep()); callableStatement.setString(3, gson.getPayName()); callableStatement.setDate(4, stringToSqlDate(gson.getDateAppoint())); callableStatement.setDate(5, stringToSqlDate(gson.getDateEnd())); callableStatement.setString(6, gson.getSurchargeId()); callableStatement.setInt(7, gson.getExcludingSmd()); callableStatement.setDate(8, stringToSqlDate(gson.getBeginSalary())); callableStatement.setDate(9, stringToSqlDate(gson.getEndSalary())); callableStatement.setInt(10, gson.getBestSmz()); callableStatement.setFloat(11, gson.getDisability()); callableStatement.setFloat(12, gson.getBaikonur()); callableStatement.registerOutParameter(13, OracleTypes.FLOAT); callableStatement.registerOutParameter(14, OracleTypes.VARCHAR); callableStatement.execute();

14 parameters has a procedure, but I pass everything correctly, but I get an error on the arguments

  • one
    Can the numbering of the parameters should go from 0 to 13? - nick_n_a
  • no numbering starts with 1 - Aslan Kussein
  • one
    can be messed up with types, then you stick a float for example, but an int is required ... and the system cannot cast float to an int. - ermak0ff
  • oh if so, but not all types are the same - Aslan Kussein
  • Tell me, is this a function by any chance? Should not return anything? For example, on Oracle, I struggled like this with a function: {call ? := doMe(?, ?, ?, ?, ?)} {call ? := doMe(?, ?, ?, ?, ?)} . There was another option select doMe(?, ?, ?, ?, ?) from dual - Chubatiy

0