DECLARE
    CURSOR nuovi
    IS
        SELECT di
        FROM tab_new;

    TYPE nuovi_aat IS TABLE OF tab_new%ROWTYPE
        INDEX BY PLS_INTEGER;

    l_nuovi nuovi_aat;
BEGIN
    OPEN nuovi;
    LOOP
        FETCH nuovi
            BULK COLLECT INTO l_nuovi LIMIT 10000;
  EXIT WHEN nuovi%notfound;

        FORALL i IN 1 .. l_nuovi.count
       -- FOR indx IN nuovi.first .. nuovi.last


             INSERT INTO tab /*+ APPEND */
                  (
                     ...
                  )
         SELECT col1,col2....
           FROM user.tables
          WHERE col_id IN (l_nuovi(i).id);


        COMMIT;

   END LOOP;

   CLOSE nuovi;
 END;

insert into tab ...
select col1, col2, ...
from user_tables
where col_id in (select di from tab_new)

EXIT WHEN l_nuovi.COUNT = 0;

EXIT WHEN nuovi%notfound;

EXIT WHEN l_nuovi.count = 0;