Cursor Type and Concurrency Combinations
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.
Cursor types control the functionality of the cursor provided to the user. Concurrency options control the updatability and locking behavior of a result set.
| Cursor type | Concurrency (allowed values) |
|---|---|
| SQL_CURSOR_FORWARD_ONLY | SQL_CONCUR_READ_ONLY |
| SQL_CURSOR_STATIC | SQL_CONCUR_READ_ONLY |
| SQL_CURSOR_KEYSET_DRIVEN[1] | SQL_CONCUR_READ_ONLY SQL_CONCUR_LOCK[2] SQL_CONCUR_VALUES |
[1] See Limitations of Using Keyset-Driven Cursors.
[2] SQL_CONCUR_LOCK is supported only when the SQL_AUTOCOMMIT connection option is set to SQL_AUTOCOMMIT_OFF.