LOOP
FETCH CURSOR
BULK COLLECT INTO resultset limit 50;
EXIT WHEN cursor%notfound; --!
--<обработка>
END LOOP;

LOOP
FETCH CURSOR
BULK COLLECT INTO resultset limit 50;
--<обработка>
EXIT WHEN cursor%notfound; --!
END LOOP;