MDAC 2.5 SDK - OLE DB Providers
OLE DB Provider for Oracle
The OLE DB Provider for Oracle implements the supported rowset properties as follows. For the full description, see Appendix C of the OLE DB Programmer's Reference, "OLE DB Properties."
| Property ID | Short description |
| DBPROP_ABORTPRESERVE | R/W: 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 can 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 reentrant and can return DB_E_NOTREENTRANT if a consumer attempts to access a non–reentrant rowset method from a notification callback. |
| DBPROP_REMOVEDELETED | R/W: Read-only Default: False 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 guide. |
Note This provider does not directly support scrolling, nor does it support updating through the rowset using IRowsetChange. If the provider is instantiated using IDataInitialize or invoked through ADO, Service Components will provide updating and scrolling functionality if requested by the application. In addition, the provider does support executing SQL update commands.