FETCH cursor bulk collect INTO，游标批量获取

 

TYPE type_cur IS REF CURSOR RETURN bms_cdr%ROWTYPE;
 bill_cursor      type_cur;
       
 TYPE  cdrtab is table of bms_cdr%ROWTYPE index by pls_integer;
 v_onerow       cdrtab;
 v_onerow2     bms_cdr%ROWTYPE;

 

OPEN bill_cursor FOR SELECT * FROM bms_cdr ;
          LOOP
              FETCH bill_cursor bulk collect  INTO v_onerow limit 10000;

              for i IN v_onerow.first..v_onerow.last
              loop
                  v_onerow2:=v_onerow(i);
                  dbms_output.put_line('333'||v_onerow2.id);
              end loop;

            
          EXIT WHEN bill_cursor%NOTFOUND;
          END LOOP;

  CLOSE bill_cursor;