java调用 procedure返回 cursor

public List<String> getReportRow(String begindate, String enddate, String begindatef, String enddatel, List<ReportRow> rows, List<ReportHead> heads) {
        Connection conn = null;
        CallableStatement cstmt = null;
        ResultSet rs1 = null;
        ResultSet rs2 = null;
        List<String> dates = new ArrayList<String>();

        conn = getConnection();

        try {
            cstmt = conn.prepareCall("{CALL EMS_AE_REPORT(?,?,?,?,?,?,?,?,?,?,?,?)}");

            cstmt.setString(1, begindate);
            cstmt.setString(2, enddate);
            cstmt.setString(3, begindatef);
            cstmt.setString(4, enddatel);

            cstmt.registerOutParameter(5, OracleTypes.CURSOR);
            cstmt.registerOutParameter(6, OracleTypes.CURSOR);

            cstmt.registerOutParameter(7, OracleTypes.VARCHAR);
            cstmt.registerOutParameter(8, OracleTypes.VARCHAR);
            cstmt.registerOutParameter(9, OracleTypes.VARCHAR);
            cstmt.registerOutParameter(10, OracleTypes.VARCHAR);
            cstmt.registerOutParameter(11, OracleTypes.VARCHAR);
            cstmt.registerOutParameter(12, OracleTypes.VARCHAR);

            cstmt.execute();

            // Get the two cursor

            rs1 = (ResultSet) cstmt.getObject(5);
            rs2 = (ResultSet) cstmt.getObject(6);

            //Get the last 1, 2, 3 month

            dates.add(cstmt.getString(7));
            dates.add(cstmt.getString(8));
            dates.add(cstmt.getString(9));
            dates.add(cstmt.getString(10));
            dates.add(cstmt.getString(11));
            dates.add(cstmt.getString(12));

            while(rs1.next()){
                ReportHead rh = new ReportHead();

                rh.setAm(rs1.getString(1));
                rh.setPm(rs1.getString(2));

                heads.add(rh);
            }

            while(rs2.next()){
                ReportRow rr = new ReportRow();

                rr.setTname(rs2.getString(1));
                rr.setEmpid(rs2.getInt(2));
                rr.setEmpname(rs2.getString(3));
                rr.setCount(rs2.getInt(4));

                rows.add(rr);
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }finally{
            closeResultSet(rs1);
            closeResultSet(rs2);
            closeStatement(cstmt);
            returnConnection(conn);
        }

        return dates;

    }

 

CREATE OR REPLACE PROCEDURE EMS_AE_REPORT(I_BEGIN_DATE IN VARCHAR2,
                                          I_END_DATE IN VARCHAR2,
                                          I_BEGIN_DATEF IN VARCHAR2,
                                          I_END_DATEL IN VARCHAR2,
                                          OUT_CURSOR_AMPM OUT SYS_REFCURSOR,
                                          OUT_CURSOR_PMCOUNT OUT SYS_REFCURSOR,
                                          O_BEGIN_DATE1 OUT VARCHAR2,
                                          O_END_DATE1 OUT VARCHAR2,
                                          O_BEGIN_DATE2 OUT VARCHAR2,
                                          O_END_DATE2 OUT VARCHAR2,
                                          O_BEGIN_DATE3 OUT VARCHAR2,
                                          O_END_DATE3 OUT VARCHAR2) AS