Re: PRO*C : fetching n rows without getting their content
From: Richard Armstrong <StateOArt_at_worldnet.att.net>
Date: Mon, 17 May 1999 13:52:34 -0600
Message-ID: <7hprta$33$1_at_bgtnsc03.worldnet.att.net>
Date: Mon, 17 May 1999 13:52:34 -0600
Message-ID: <7hprta$33$1_at_bgtnsc03.worldnet.att.net>
You can easily do this in Pro*C. There are several alternatives.
Look into array fetches of a cursor. You can declare an array to fetch your rows into. If you want to skip the first array fetch, just fetch them, and then fetch the next set for displaying.
-- **************************************** Richard Armstrong State Of The Art Consulting, Inc. http://www.stateoart.com **************************************** Herve lemaitre <buserror_at_club-internet.fr> wrote in message news:37404D0C.E8253503_at_club-internet.fr...Received on Mon May 17 1999 - 21:52:34 CEST
> Hi all
>
> 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....