DECLARE
CURSOR tmp$table_cur
SELECT * FROM tmp;
TYPE t_table IS TABLE OF tmp$table%ROWTYPE
INDEX BY PLS_INTEGER;
l_table t_table;
BEGIN
OPEN tmp$table_cur;
LOOP
FETCH tmp$table_cur
BULK COLLECT INTO t_table
LIMIT 100;
EXIT WHEN tmp$table_cur%NOTFOUND;
FOR indx IN 1 .. l_table.COUNT
LOOP
some_magick (l_table (indx));
END LOOP;
END LOOP;
CLOSE tmp$table_cur;
END process_all_rows;