ORA-01002 WHEN Using Cursor Types SQL_CURSOR_KEYSET_DRIVEN and SQL_CURSOR_STATIC
Last updated on JULY 05, 2017
Applies to:Oracle ODBC Driver - Version 22.214.171.124 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.
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