DECLARE
CURSOR big_cur IS
SELECT
object_id
FROM
scott.big_tab;
TYPE big_tab_type IS
TABLE OF scott.big_tab.object_id%TYPE;
mybig_tab big_tab_type;
summe NUMBER := 0;
teil_summe NUMBER := 0;
BEGIN
OPEN big_cur;
LOOP
FETCH big_cur
BULK COLLECT INTO mybig_tab LIMIT 100;
FOR i IN 1..mybig_tab.count LOOP
summe := summe + mybig_tab(i);
END LOOP;
EXIT WHEN big_cur%notfound;
END LOOP;
CLOSE big_cur;
END;
/