Live ORACLE

DECLARE
 TYPE numtab IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
 CURSOR c1 IS
   SELECT employee_id
   FROM   employees
   WHERE  department_id = 80;
 empids  NUMTAB;
 ROWS    PLS_INTEGER := 10;
BEGIN
 OPEN c1;
 LOOP -- the following statement fetches 10 rows or less in each iteration
   FETCH c1 BULK COLLECT INTO empids LIMIT ROWS;
   EXIT WHEN empids.COUNT = 0;
   -- EXIT WHEN c1%NOTFOUND; -- incorrect, can omit some data
   dbms_output.Put_line('------- Results from Each Bulk Fetch --------');
   FOR i IN 1.. empids.COUNT LOOP
     dbms_output.Put_line('Employee Id: '
                          ||Empids(i));
   END LOOP;
 END LOOP;
 CLOSE c1;
END;
/  

------- Results from Each Bulk Fetch --------
Employee Id: 145
Employee Id: 146
Employee Id: 147
Employee Id: 148
Employee Id: 149
Employee Id: 150
Employee Id: 151
Employee Id: 152
Employee Id: 153
Employee Id: 154
------- Results from Each Bulk Fetch --------
Employee Id: 155
Employee Id: 156
Employee Id: 157
Employee Id: 158
Employee Id: 159
Employee Id: 160
Employee Id: 161
Employee Id: 162
Employee Id: 163
Employee Id: 164
------- Results from Each Bulk Fetch --------
Employee Id: 165
Employee Id: 166
Employee Id: 167
Employee Id: 168
Employee Id: 169
Employee Id: 170
Employee Id: 171
Employee Id: 172
Employee Id: 173
Employee Id: 174
------- Results from Each Bulk Fetch --------
Employee Id: 175
Employee Id: 176
Employee Id: 177
Employee Id: 179

PL/SQL procedure successfully completed.

Using LIMIT to Control the Number of Rows In a BULK COLLECT