PRO*C : fetching n rows without getting their content

I am developping a Motif application showing Oracle 7 tables content. Tables may be very large, so I don't want to load all the table content at the beginning. My idea was to load datas only when it is needed. To do that I have implemented a function that has to load n rows, starting at row i. But I don't know how to fetch the i first rows, and then get the rows between i and i+n. Is it possible in Pro*C or PL/SQL, or does I have to study another solution ?

Thanks in advance

Herve

-- 
Herve Lemaitre
mail perso : buserror_at_club-internet.fr


- Quel est votre but dans la vie ?


- Prendrrre du boon temps, touut le tempzzz....