DECLARE
CURSOR CUR_SOR IS
SELECT * FROM person WHERE ROWNUM < 5 ORDER BY BGDH;
TYPE RESULTSET IS TABLE OF person%ROWTYPE;
r RESULTSET;
BEGIN
OPEN CUR_SOR;
LOOP
FETCH CUR_SOR BULK COLLECT
INTO R LIMIT 1000;
FOR I IN 1 .. R.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(r(i).uuid);
END LOOP;
EXIT WHEN CUR_SOR%NOTFOUND;
END LOOP;
CLOSE CUR_SOR;
END;