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 220.127.116.11 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!