The OLE DB Provider for Oracle implements the supported rowset properties as follows. For the full description, see Appendix C, "Properties," in the OLE DB Programmer's Reference.
| Property ID | Short Description |
| DBPROP_ABORTPRESERVE | R/O: Read-only Default: VARIANT_FALSE Description: The OLE DB Provider for Oracle does not invalidate rowsets after an abort. |
| DBPROP_ BLOCKINGSTORAGEOBJECTS |
R/W: Read-only Default: VARIANT_FALSE Description: This provider's storage objects do not block the use of other rowset methods. |
| DBPROP_BOOKMARKS | R/W: Read-only Default: VARIANT_FALSE Description: The OLE DB Provider for Oracle does not support bookmarks for rowset row identification. |
| DBPROP_CACHEDEFERRED | R/W: Read-only Default: VARIANT_FALSE Description: Cannot defer column fetching. |
| DBPROP_CANFETCHBACKWARDS |
R/W: Read-only Default: VARIANT_FALSE Description: The OLE DB Provider for Oracle does not support fetching backward. |
| DBPROP_CANHOLDROWS | R/W: Read-only Default: VARIANT_TRUE Description: The OLE DB Provider for Oracle rowsets are read-only. Rowsets may hold rows across the fetcher, as long as RestartPosition is not called. |
| DBPROP_CANSCROLLBACKWARDS | R/W: Read-only Default: VARIANT_FALSE Description: The OLE DB Provider for Oracle does not support backward scrolling. |
| DBPROP_COMMITPRESERVE | R/W: Read-only Default: VARIANT_TRUE Description: The OLE DB Provider for Oracle maintains a valid rowset if the property is VARIANT_TRUE. |
| DBPROP_DEFERRED | R/W: Read-only Default: VARIANT_FALSE Description: The OLE DB Provider for Oracle fetches data in the column when the row containing the data is fetched. |
| DBPROP_IACCESSOR DBPROP_ICOLUMNSINFO DBPROP_ICONVERTTYPE DBPROP_IROWSET DBPROP_IROWSETINFO |
R/W: Read-only Default: VARIANT_TRUE Description: The OLE DB Provider for Oracle supports these interfaces on all rowsets. |
| DBPROP_ICONNECTIONPOINTCONTAINER | R/W: Read-only Default: VARIANT_TRUE |
| DBPROP_IROWSETIDENTITY | R/W: Read-only Default: VARIANT_TRUE Description: The OLE DB Provider for Oracle exposes IRowsetIdentity on rowsets. |
| DBPROP_ISUPPORTERRORINFO | R/W: Read-only Default: VARIANT_TRUE Description: The OLE DB Provider for Oracle exposes the ISupportErrorInfo interface on rowsets. |
| DBPROP_ISEQUENTIALSTREAM | R/W: Read-only Default: VARIANT_TRUE Description: The OLE DB Provider for Oracle exposes the ISequentialStream interface to support long, variable-length data stored in Oracle. |
| DBPROP_LITERALIDENTITY | R/W: Read-only Default: VARIANT_TRUE Description: See the description in the OLE DB Programmer's Reference. |
| DBPROP_MAXOPENROWS | R/W: Read-only Default: 0 Description: The OLE DB Provider for Oracle does not limit the number of rows that can be active in rowsets. |
| DBPROP_MAXROWS | R/W: Read/Write Default: 0 Description: No limit. |
| DBPROP_NOTIFICATIONGRANULARITY | R/W: Read-only Default: NT_MULTIPLE_ROWS Description: See the description in the OLE DB Programmer's Reference. |
| DBPROP_NOTIFICATIONPHASES | R/W: Read-only Default: DBPROPVAL_NP_OKTODO DBPROPVAL_NP_ABOUTTODO DBPROPVAL_NP_SYNCHAFTER DBPROPVAL_NP_FAILEDTODO BPROPVAL_NP_DIDEVENT Description: The OLE DB Provider for Oracle supports all notification phases. |
| DBPROP_NOTIFYROWSETRELEASE DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE |
R/W: Read-only Default: DBPROPVAL_NP_OKTODO DBPROPVAL_NP_ABOUTTODO Description: The OLE DB Provider for Oracle notification phases are cancelable prior to an attempt to perform the rowset modification indicated. This provider does not support phase cancellation after the attempt has completed. |
| DBPROP_OTHERINSERT DBPROP_OTHERUPDATEDELETE DBPROP_OWNINSERT DBPROP_OWNUPDATEDELETE |
R/W: Read/only Default: VARIANT_FALSE Description: See the description in the OLE DB Programmer's Reference. |
| DBPROP_QUICKRESTART | R/W: Read/only Default: VARIANT_FALSE Description: See the description in the OLE DB Programmer's Reference. |
| DBPROP_REENTRANTEVENTS | R/W: Read-only Default: VARIANT_FALSE Description: The OLE DB Provider for Oracle rowsets are re-entrant and can return DB_E_NOTREENTRANT if a consumer attempts to access a non–re-entrant rowset method from a notification callback. |
| DBPROP_REMOVEDELETED | R/W: Read/only Default: Description: See the description in the OLE DB Programmer's Reference. |
| DBPROP_ROWTHREADMODEL | R/W: Read-only Default: DBPROPVAL_RT_FREETHREAD Description: The OLE DB Provider for Oracle supports access to its objects from multiple execution threads of a single consumer. |
| DBPROP_SERVERCURSOR | R/W: Read/only Default: VARIANT_FALSE Description: The OLE DB Provider for Oracle does not support client-side cursors. |
| DBPROP_STRONGIDENTITY | R/W: Read-only Default: VARIANT_TRUE Description: See the description in the OLE DB Programmer's Reference. |
| DBPROP_TRANSACTEDOBJECT | R/W: Read-only Default: VARIANT_FALSE Description: The OLE DB Provider for Oracle supports only transacted objects. For more information, see “Transactions,” later in this file. |