Re: ORA-01002 Fetch out of sequence

From: <tsibulnyak_at_my-dejanews.com>
Date: Thu, 06 May 1999 12:17:45 GMT
Message-ID: <7gs196$mqt$1@nnrp1.deja.com>

Hi Colin,
> Oh yes
>
> By the way it is Personal Oracle 8 for NT. Obviously i am going to be
> porting it into a CS environment
>
> TIA
> Colin B
>
> Colin Basterfield <colinb_at_areagem.demon.co.uk> wrote in message
> news:925922139.15688.0.nnrp-12.c1ed1510_at_news.demon.co.uk...
> > Hello all,
> >
> > I am doing a simple
> >
> > 'select * from client'
> > 'where client_reference=:ClientRef'
> > 'for update nowait'
> >
> > This is using Delphi 4. It gives me the message
> >
> > 'ORA-01002 Fetch out of Sequence'
> >
> > Anyone got any ideas on this one please?
> >
> > TIA
> > Colin Basterfield
> > colinb_at_areagem.demon.co.uk
> >
> >
>
>

This error arises at attempt to commit changes in a loop SELECT ... FOR UPDATE. Check up your source code.

Oleg Tsibulnyak

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu May 06 1999 - 07:17:45 CDT