Backward-scrolling cursor in Oracle

Hi,

It's quite easy to save fetched data into fixed length record file. You should open such a file for each opened for select cursor. You can scroll backward using this file. I have made this some years ago in OCI C program. The only problem is that you should use select for update statement to lock fetched data or refresh them before update.

                          Best wishes, Andrew Protasov

>
> Kingsley Idehen wrote:
>
> No, in fact you do the very right thing. It is just the Oracle 7
> doesn't
> support backward-scrolling cursor.
>
> However, I am interesting in how you implement the backward-scrolling
> without
> the database support it.
>
> You store some records in a buffer ? If so, what is your record limit ?
>
> Or you simply reopen the cursor and refetch from the begining ?
> If so, would that be slow ?
>
> Cheers,
> Michael
>
> > We support Scrollable Cursors across Oracle 7, have we done something wrong
> > <g>.
> >
> > > However, the Oracle RDBMS itself doesn't support backward-scrolling
> > > cursor.
> > > Probably the Oracle 8 will.
>
Received on Fri Apr 11 1997 - 00:00:00 CDT