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:

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

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