Keyset cursor returns no rows with 11.2.0.2 Oracle ODBC Driver against UTF8 database (Doc ID 1552515.1)

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Generic Windows

Symptoms

Using Oracle's 11.2.0.2 ODBC driver with a keyset cursor against a UTF8 database, an ADO Recordset may return no rows (rs.eof is true).

This behavior can also be observed using 11.2.0.1 Patch 7 or higher, but less than 11.2.0.1 Patch 11, Oracle ODBC Driver as well.

Changes

Behavior may be discovered as a result of an Oracle client upgrade.

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