Re: absolute fetching

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Wed, 2 Dec 98 14:44:20 +0200
Message-ID: <ABaOJPsK42@protasov.kiev.ua>

Hi,

It is impossible. Oracle cursors are single directional. They can be browsed only from first to last record of the result set. There is no reverse fetch or absolute fetch. You can use flat file on client side to store records and browse them as you want.

Andrew Protasov

> Hi!
> I would like to know how can i fetch cursor like SQL statement:
> <OK>ofetch(cur); FETCH NEXT FROM cur
> ? FETCH PREV FROM cur
> ? FETCH ABSOLUTE n FROM cur
> Thanks,
> David
>
>
>
>
>
Received on Wed Dec 02 1998 - 06:44:20 CST