bulk collect limit和 forall 用法

CURSOR cur_tbl_n_txn_wk IS
      SELECT ...... ;
TYPE type_array_tnt IS TABLE OF cur_tbl_n_txn_wk%ROWTYPE INDEX BY BINARY_INTEGER;
v_tbl_n_txn_wk type_array_tnt;
--批量每次fetch数量
v_rows NUMBER := 100;


begin


OPEN cur_tbl_n_txn_wk;
    LOOP
      FETCH cur_tbl_n_txn_wk BULK COLLECT
        INTO v_tbl_n_txn_wk LIMIT v_rows;
      FORALL i IN 1 .. v_tbl_n_txn_wk.count
        INSERT INTO tbl_dc_trade_water(......)
        VALUES
          (v_tbl_n_txn_wk(i).tdtw_id......);
    COMMIT;
    EXIT WHEN cur_tbl_n_txn_wk%NOTFOUND;
    END LOOP;
    CLOSE cur_tbl_n_txn_wk;
    COMMIT;
end;