The code:

ArrayList roeModelList = new ArrayList();
           Connection conn=null;
        CallableStatement cstmt=null;
        ResultSet rs=null;
        GenericDAO dao = new GenericDAO();
        try
        {
                 conn=dao.getConnection();
                  String[] pipelineRunNumArr = new String[0]; // since approver list doen't depends on pipeline run number
                    cstmt = conn.prepareCall(ROESql.getROEApproverRejectListSP );
                    cstmt.registerOutParameter(1,Types.INTEGER);
                 cstmt.registerOutParameter(9,OracleTypes.CURSOR);
                 cstmt.registerOutParameter(10,Types.VARCHAR);
                 cstmt.setString(2,null); // version num
                 cstmt.setArray(3,null); // process status array
            }catch(Exception e)
          {
            System.out.println(e.getMessage());
            e.printStackTrace();
          }finally
           {
               if (cstmt != null)
               {
                 cstmt.close();
                 cstmt = null;

               }
               if(conn!=null)
               {
                    dao.releaseConnection(conn);
               }
           }

         }


Throws the following exception:

java.sql.SQLException: Invalid argument(s) in call
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:179)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:269)
        at oracle.jdbc.driver.OraclePreparedStatement.setARRA Y(OraclePreparedSta
tement.java:1707)
        at oracle.jdbc.driver.OraclePreparedStatement.setArra y(OraclePreparedSta
tement.java:1681)
        at JDBCVersion.main(JDBCVersion.java:57)

Check the No. of parameters to be passed to the SQL and make assumption in the same sequence.

CallableStatement cstmt = con.prepareCall(
                          "{call getTestData(?, ?)}");
    cstmt.registerOutParameter(1, java.sql.Types.TINYINT);
    cstmt.registerOutParameter(2, java.sql.Types.DECIMAL, 3);
    cstmt.executeQuery();
    byte x = cstmt.getByte(1);
    java.math.BigDecimal n = cstmt.getBigDecimal(2, 3);






Gokulan Ethiraj