Re: Urgent: Problem with Cursor for UPDATE

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sat, 19 May 2001 11:06:17 GMT
Message-ID: <3b0651ea.1467111@news-server>

On Fri, 18 May 2001 17:18:09 +0200, "Elias Alpuente" <ealpuente_at_isoco.com> wrote:

>But the problem is that we have one database where we can
>use SELECT FOR UPDATE with COMMIT without error
>"Fetch out of secuence" and other one that the same program
>fails with "Fetch out of secuence" and I don't know why.
>

All you need is for the sequence of rows as retrieved to be different in physical sequence on each database. Which it probably is.

>Any one knows anything ????

As I said, I recommend you have a gander at the site below.

>> In Steve's site, www.ixora.com.au, there is plenty of info on this.
>>

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sat May 19 2001 - 06:06:17 CDT