oracle 通过存储过程返回游标类型集合

1. 存储过程定义

create or replace procedure pro_fetchuser(ret out sys_refcursor)

as
   --cursor userInfo_cursor is select * from t_user;
   --userInfo userInfo_cursor%rowtype;
begin
  open ret for
  select * from t_user;
 

end;

2.java调用遍历

            Connection conn = session.connection();
            CallableStatement pro = conn.prepareCall("{call pro_fetchuser(?)}");
            pro.registerOutParameter(1, -10);
            pro.executeQuery();
            ResultSet rs = (ResultSet) pro.getObject(1);
//            while (rs.next()) {
//                System.out.println(rs.getString("USER_LOGIN"));
//              }
            ResultSetMetaData md = r