What is the right way to collect a set of records equal to SFLPAGE?
FETCH FIRST XXX ROWS ONLY, will limits the rows in the ODP to just the
first XXX rows.
But you'd probably want to do a block (aka multiple-row) fetch from a
fetch from mycursor
for XXX rows into :myarray;