Re: using "pages" with oo4o

From: Mark Wagoner <mwagoner_at_no.spam.iac.net>
Date: Tue, 22 Sep 1998 12:49:50 GMT
Message-ID: <36079ca8.314169271@news.iac.net>

On Tue, 22 Sep 1998 11:20:26 GMT, srmonte_at_arrakis.es wrote:

>Hi all
>
>Is it possible to use "pages" with Oracle Objects for Ole?
>What I want to do is access a large query fetching no more than 25-50 rows at
>a time. I can do this with ADO using the PageSize and AbsolutePage properties
>of the Recordset object.
>
>Does anybody know how?
>
>thanks a lot
>

You could create a stored procedure that acutally opens the cursor and places the values in PL/SQL tables. These tables are then returned to the client.

I have used this method for both fetching and inserting data. It is very fast.

--
Mark Wagoner
To reply, remove no.spam from my e-mail address Received on Tue Sep 22 1998 - 07:49:50 CDT