Error in fetching from cursor using Oracle Pro*C

Question

I'm converting an ingres C program to Oracle Pro*C.

I create and open a cursor to do a SELECT (not a SELECT FOR UPDATE).

The existing program does (roughly)

EXEC SQL DECLARE N CURSOR for SELECT...
EXEC SQL OPEN N
EXEC SQL FETCH N INTO :new
while (sqlca.sqlcode != 100) {
  // process the contents of :new
  EXEC SQL FETCH N INTO :new
}
EXEC SQL CLOSE N;

When I reach the last line returned by the select statement, I get an error, ORA-01002: fetch out of sequence.

I don't want to put my cleanup code in my error handler; I would rather that the loop exit cleanly.

Solved it myself -- see below -- just wanted to capture it here in case this happens to anybody else. — Jim Kiley
– Jim Kiley, Commented Aug 3, 2011 at 19:37

Jim Kiley · Accepted Answer · 2011-08-03 19:37:05Z

3

In fact, careful analysis (by which I mean "tons of printf()s") indicates that sqlca.sqlcode is never anything other than null until the loop is complete.

So I just changed the condition on the loop to be

while (sqlca.sqlcode =='\0')

rather than

while (sqlca.sqlcode != 100)

And all is well.

answered Aug 3, 2011 at 19:37

Jim Kiley

3,6523 gold badges29 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error in fetching from cursor using Oracle Pro*C

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related