Re: ORA-01002 on AIX/7.3.4

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 22 Sep 2000 21:23:28 +0200
Message-ID: <969654966.12513.0.pluto.d4ee154e@news.demon.nl>

Obviously your data is not identical, and your code is making tacit assumptions.
This error usually arises when you commit inside a loop (which you also shouldn't do because of ora-1555 'snapshot too old') So without looking at your code you probably won't get any to the point solution back.

Regards,

Sybrand Bakker, Oracle DBA
"Ullrich Bartels" <ullrich.bartels_at_t-online.de> wrote in message news:39CBAD1D.CDCB4034_at_t-online.de...
> Hi,
>
> I'm writing a PL/SQL application for a target system based upon AIX
> with Oracle 7.3.4 whereas the development system is on Linux with
> Oracle 8.0.5.
>
> When performing the same job on both systems (identical user images)
> on AIX I get the message:
> ORA-01002 fetch out of sequence
> whereas there is no problem on the Linux side.
>
> Has anyone an idea?
>
> Thx in advance
>
> Ullrich Bartels
Received on Fri Sep 22 2000 - 14:23:28 CDT