ORA-01002 WHEN Using Cursor Types SQL_CURSOR_KEYSET_DRIVEN and SQL_CURSOR_STATIC (Doc ID 1453918.1)

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version 11.1.0.7 and later
Microsoft Windows (32-bit)

Symptoms

Fetching data with the Oracle ODBC driver fails with:

[Oracle][ODBC][Ora]ORA-01002: fetch out of sequence

when the ODBC application executes the same query a second time and fetches a large number of rows but does not re-prepare and re-bind column metadata.

This can be reproduced with cursor types SQL_CURSOR_KEYSET_DRIVEN and SQL_CURSOR_STATIC. This does not reproduce with cursor type SQL_CURSOR_FORWARD_ONLY.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms