Re: Fetching previous records in OCI

From: mark tomlinson <marktoml_at_gdi.net>
Date: 1998/04/28
Message-ID: <3545c45e.313972468_at_newshost.us.oracle.com>#1/1

[Quoted] 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. Received on Tue Apr 28 1998 - 00:00:00 CEST

This message: [ Message body ]
Next message: Jagdish Rajan: "Re: Fetching previous records in OCI"
Previous message: Robert Miller: "Re: Do you have Oracle Questions? Post them in our new forum!"
In reply to: Jagdish Rajan: "Fetching previous records in OCI"
In reply to Jagdish Rajan: "Fetching previous records in OCI"
Next in thread: Jagdish Rajan: "Re: Fetching previous records in OCI"
Reply: Jagdish Rajan: "Re: Fetching previous records in OCI"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message