Oracle Provider for OLE DB User's Guide Release 8.1.6 A75235-01 |
|
This appendix discusses OLE DB information that is specific to Oracle Provider for OLE DB. For generic OLE DB information that includes a detailed listing of all OLE DB properties and interfaces, see OLE DB Programmer's Reference Guide.
This section lists the datatype mappings between Oracle datatypes and OLE DB-defined types. Oracle Provider for OLE DB represents Oracle datatypes by using certain OLE DB-defined datatypes in the rowset as well as in parameters. OLE DB-defined types are also mapped to an Oracle datatype when creating tables.
Each Oracle datatype is mapped to a particular OLE DB datatype. This correspondence is used when datatype information is retrieved from an Oracle database. Oracle types are mapped to OLE DB types as follows:
This section lists the properties supported by Oracle Provider for OLE DB. The read/write status and initial values are noted.
Property | Status | Initial Value |
---|---|---|
DBPROP_CURRENTCATALOG |
READ-ONLY |
null |
Property | Status | Initial Value |
---|---|---|
DBPROP_SESS_AUTOCOMMITISOLEVELS |
READ-ONLY |
DBPROPVAL_TI_CURSORSTABILITY | |
Oracle Provider for OLE DB sets other necessary properties if a particular property is set to VARIANT_TRUE.
This section identifies the OLE DB interfaces that are supported by Oracle Provider for OLE DB.
CoType TDataSource { interface IDBCreateSession; interface IDBInitialize; interface IDBProperties; interface IPersist; interface IDBInfo; interface ISupportErrorInfo; }
CoType TSession { interface IGetDataSource; interface IOpenRowset; interface ISessionProperties; interface IDBCreateCommand; interface IDBSchemaRowset; interface ISupportErrorInfo; interface ITransactionJoin; interface ITransactionLocal; interface ITransaction; }
CoType TCommand { interface IAccessor; interface IColumnsInfo; interface ICommand; interface ICommandProperties; interface ICommandText; interface IConvertType; interface IColumnsRowset; interface ICommandPrepare; interface ICommandWithParameters; interface ISupportErrorInfo; }
CoType TRowset { interface IAccessor; interface IColumnsInfo; interface IConvertType; interface IRowset; interface IRowsetInfo; interface IColumnsRowset; interface IConnectionPointContainer; interface IRowsetChange; interface IRowsetFind; interface IRowsetIdentity; interface IRowsetLocate; interface IRowsetRefresh; interface IRowsetScroll; interface IRowsetUpdate; interface ISupportErrorInfo; }
CoType TTransactionOptions { interface ITransactionOptions; interface ISupportErrorInfo; }
CoType TCustomErrorObject { interface IErrorLookup; }
The following metadata columns are supported by OraOLEDB's column rowset:
|
![]() Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|