Re: Fetching previous records in OCI

From: mark tomlinson <marktoml_at_gdi.net>
Date: Tue, 28 Apr 1998 11:59:36 GMT
Message-ID: <3545c45e.313972468@newshost.us.oracle.com>

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 - 06:59:36 CDT