Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Fetching previous records in OCI
Thanks Mark! I had started implementing it with the ROWIDs but just
wanted to make sure I wasn't missing anything obvious here. The one
problem is that I may have a recordset of 100,000 rows that I will
have to scroll back and forth through. This of course will require
some kind of a virtual cache.
BTW in Oracle 8.x you can use the extended rowid to get a unique &
valid value rather than the restricted rowid that was used in 7.x.
On Tue, 28 Apr 1998 11:59:36 GMT, marktoml_at_gdi.net (mark tomlinson) wrote:
>On Sat, 25 Apr 1998 23:49:44 GMT, jagdish_at_worldnet.att.net (Jagdish
>Rajan) wrote:
>
>>Since OCI's OCIStmtFetch() function only supports OCI_FETCH_NEXT for
>>its orientation paramater how does one retrieve a previous record
>>within a statement handle?
>>
>>Jagdish
>>(jagdish_at_worldnet.att.net)
>
>Well, with 7.3 OCI a common trick was to cache the rowids locally and
>then you could effectively scroll back. With 8m and no guarantee of
>always being able to obtain a valid rowid, this may or may not work
>for you still.
>
>
Thank you.
Jagdish (jagdish_at_worldnet.att.net)
Received on Tue Apr 28 1998 - 10:50:26 CDT