Limitations of using keyset-driven cursors
Important
This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use the ODBC driver provided by Oracle.
You must be able to retrieve a single ROWID column for the table queried. A keyset-driven cursor can't be used on joins, queries, or statements that contain DISTINCT, GROUP BY, UNION, INTERSECT, or MINUS clauses.
Also, if your application uses table aliases, keyset-driven cursors don't work; forward-only or static cursor types are required. Using the keyset cursor type with table aliases cause the following error: [Microsoft][ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with union, intersect or minus or on read only result set.
Note
Because of the way the driver handles the SQL statement that is sent to the Oracle server, Oracle internally returns the following error message: ORA-00964: table name not in FROM list.