Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-1002: FETCH OUT OF SEQUENCE

Re: ORA-1002: FETCH OUT OF SEQUENCE

From: Christopher Boyle <cboyle_at_hargray.dot.com>
Date: Tue, 26 Nov 2002 07:59:02 -0500
Message-ID: <arvr6c$8p32$1@news3.infoave.net>


Does your interface perform a commit after every statement? That would blow your transaction to bits.
"Andrei Romazanov" <romazanov.andrei_at_gfos.de> wrote in message news:artj99$li8pn$1_at_ID-70985.news.dfncis.de...
> Hi,
>
> I have a problem with a C-program,
> which communicates with dynamic SQL with ORACLE data base.
> I link the program with 8i-Libraries (oraSQL8.LIB) and
> try to connect with ORACLE 8.05-database.
> Connect is OK, but with the first FETCH I get the error
> ORA-1002: FETCH OUT OF SEQUENCE
> The same program works with oracle 8i normally.
> Same code linked with Sqllib80.lib - functions also.
> Who could explain that?
>
> Thank you in advance
> Andrei
>
>
Received on Tue Nov 26 2002 - 06:59:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US