My Oracle Support Banner

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

Last updated on OCTOBER 05, 2022

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.