A
Provider-Specific Information

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.

• Datatype Mappings in Rowsets and Parameters

• Properties Supported

• Interfaces Supported

• MetaData Columns Supported

Datatype Mappings in Rowsets and Parameters

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:

Oracle datatype	OLE DB datatype
BFILE	DBTYPE_BYTES
BLOB	DBTYPE_BYTES
CHAR	DBTYPE_STR
CLOB	DBTYPE_STR
DATE	DBTYPE_DBTIMESTAMP
FLOAT	DBTYPE_R8
LONG	DBTYPE_STR
LONG RAW	BTYPE_BYTES
NCHAR	DBTYPE_STR
NCLOB	DBTYPE_STR
NUMBER	DBTYPE_VARNUMERIC
NUMBER(p,s)	DBTYPE_NUMERIC
NVARCHAR2	DBTYPE_STR
RAW	DBTYPE_BYTES
ROWID	DBTYPE_STR
VARCHAR	DBTYPE_STR

Properties Supported

This section lists the properties supported by Oracle Provider for OLE DB. The read/write status and initial values are noted.

• Data Source Properties

• Data Source Info Properties

• Initialization and Authorization Properties

• Session Properties

• Rowset Properties

Data Source Properties

Table A-1 DBPROPSET_DATASOURCE Properties

Property	Status	Initial Value
DBPROP_CURRENTCATALOG	READ-ONLY	null

Data Source Info Properties

Table A-2 DBPROPSET_DATASOURCEINFO Properties

Property	Status	Initial Value
DBPROP_ACTIVESESSIONS	READ-ONLY	0, Unlimited sessions
DBPROP_ASYNCTXNABORT	READ-ONLY	VARIANT_FALSE
DBPROP_ASYNCTXNCOMMIT	READ-ONLY	VARIANT_FALSE
DBPROP_BYREFACCESSORS	READ-ONLY	VARIANT_TRUE
DBPROP_CATALOGLOCATION	READ-ONLY	DBPROPVAL_CL_END
DBPROP_CATALOGTERM	READ-ONLY	"Database link"
DBPROP_CATALOGUSAGE	READ-ONLY	DBPROPVAL_CU_DML_STATEMENTS
DBPROP_COLUMNDEFINITION	READ-ONLY	DBPROPVAL_CD_NOTNULL
DBPROP_CONCATNULLBEHAVIOR	READ-ONLY	DBPROPVAL_CB_NON_NULL
DBPROP_CONNECTIONSTATUS	READ-ONLY	DBPROPVAL_CS_INITIALIZED
DBPROP_DATASOURCENAME	READ-ONLY	" ", set at runtime
DBPROP_DATASOURCEREADONLY	READ-ONLY	VARIANT_FALSE
DBPROP_DBMSNAME	READ-ONLY	" ", set at runtime
DBPROP_DBMSVER	READ-ONLY	set at runtime
DBPROP_DSOTHREADMODEL	READ/WRITE	DBPROPVAL_RT_FREETHREAD
DBPROP_GROUPBY	READ-ONLY	DBPROPVAL_GB_CONTAINS_SELECT
DBPROP_HETEROGENEOUSTABLES	READ-ONLY	DBPROPVAL_HT_DIFFERENT_CATALOGS
DBPROP_IDENTIFIERCASE	READ-ONLY	DBPROPVAL_IC_UPPER
DBPROP_MAXINDEXSIZE	READ-ONLY	0, limit unknown - depends on blocksize
DBPROP_MAXOPENCHAPTERS	READ-ONLY	0, not supported
DBPROP_MAXORSINFILTER	READ-ONLY	0, not supported
DBPROP_MAXROWSIZE	READ-ONLY	0, No limit
DBPROP_MAXROWSIZEINCLUDESBLOB	READ-ONLY	VARIANT_FALSE
DBPROP_MAXSORTCOLUMNS	READ-ONLY	0, not supported
DBPROP_MAXTABLESINSELECT	READ-ONLY	0, no limit
DBPROP_MULTIPLEPARAMSETS	READ-ONLY	VARIANT_TRUE
DBPROP_MULTIPLERESULTS	READ-ONLY	DBPROP_MR_NOTSUPPORTED
DBPROP_MULTIPLESTORAGEOBJECTS	READ-ONLY	VARIANT_FALSE
DBPROP_MULTITABLEUPDATE	READ-ONLY	VARIANT_FALSE
DBPROP_NULLCOLLATION	READ-ONLY	DBPROPVAL_NC_HIGH
DBPROP_OLEOBJECTS	READ-ONLY	DBPROPVAL_OO_BLOB
DBPROP_ORDERBYCOLUMNSINSELECT	READ-ONLY	VARIANT_FALSE
DBPROP_OUTPUTPARAMETERAVAILABILITY	READ-ONLY	DBPROPVAL_OA_ATEXECUTE
DBPROP_PERSISTENTIDTYPE	READ-ONLY	DBPROPVAL_PT_NAME
DBPROP_PREPAREABORTBEHAVIOR	READ-ONLY	DBPROPVAL_CB_PRESERVE
DBPROP_PREPARECOMMITBEHAVIOR	READ-ONLY	DBPROPVAL_CB_PRESERVE
DBPROP_PROCEDURETERM	READ-ONLY	"PL/SQL Stored Procedure"
DBPROP_PROVIDERFRIENDLYNAME	READ-ONLY	"Oracle Provider for OLE DB"
DBPROP_PROVIDERNAME	READ-ONLY	OraOLEDB.dll
DBPROP_PROVIDEROLEDBVER	READ-ONLY	"02.01"
DBPROP_PROVIDERVER	READ-ONLY	"08.01.05.00.00"
DBPROP_QUOTEDIDENTIFIERCASE	READ-ONLY	DBPROPVAL_IC_SENSITIVE
DBPROP_ROWSETCONVERSIONSONCOMMAND	READ-ONLY	VARIANT_TRUE
DBPROP_SCHEMATERM	READ-ONLY	"Owner"
DBPROP_SCHEMAUSAGE	READ-ONLY	DBPROPVAL_SU_DML_STATEMENTS | DBPROPVAL_SU_TABLE_DEFINITION | DBPROPVAL_SU_INDEX_DEFINITION | DBPROPVAL_SU_PRIVILEGE_DEFINITION
DBPROP_SERVERNAME	READ-ONLY	" ", set at runtime
DBPROP_SORTONINDEX	READ-ONLY	VARIANT_FALSE
DBPROP_SQLSUPPORT	READ-ONLY	DBPROPVAL_SQL_ODBC_MINIMUM | DBPROPVAL_SQL_ANSI92_ENTRY | DBPROPVAL_SQL_ESCAPECLAUSES
DBPROP_STRUCTUREDSTORAGE	READ-ONLY	DBPROPVAL_SS_ISEQUENTIAL_STREAM
DBPROP_SUBQUERIES	READ-ONLY	DBPROPVAL_SQ_CORRELATEDSUBQUERIES
DBPROP_SUPPORTEDTXNDDL	READ-ONLY	DBPROPVAL_TC_DDL_COMMIT
DBPROP_SUPPORTEDTXNISOLEVELS	READ-ONLY	DBPROPVAL_TI_CURSORSTABILITY | DBPROPVAL_TI_READCOMMITTED
DBPROP_SUPPORTEDTXNISORETAIN	READ-ONLY	DBPROPVAL_TR_DONTCARE
DBPROP_TABLETERM	READ-ONLY	"Table"
DBPROP_USERNAME	READ-ONLY	" ", set at runtime

Initialization and Authorization Properties

Table A-3 DBPROPSET_DBINIT Properties

Property	Status	Initial Value
DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO	READ-ONLY	VARIANT_FALSE
DBPROP_AUTH_USERID	READ/WRITE	User ID
DBPROP_INIT_DATASOURCE	READ/WRITE	Connect string
DBPROP_INIT_HWND	READ/WRITE	Window handle for prompt
DBPROP_INIT_LCID	READ/WRITE	LCID of system
DBPROP_INIT_OLEDBSERVICES	READ/WRITE	DBPROPVAL_OS_ENABLEALL
DBPROP_INIT_PROMPT	READ/WRITE	DBPROMPT_NOPROMPT

Session Properties

Table A-4 DBPROPSET_SESSION Properties

Property	Status	Initial Value
DBPROP_SESS_AUTOCOMMITISOLEVELS	READ-ONLY	DBPROPVAL_TI_CURSORSTABILITY | DBPROPVAL_TI_READCOMMITTED

Rowset Properties

Table A-5 DBPROPSET_ROWSET Properties

Property	Status	Initial Value
DBPROP_ABORTPRESERVE	READ/WRITE	VARIANT_TRUE
DBPROP_ACCESSORORDER	READ-ONLY	DBPROP_AO_RANDOM
DBPROP_APPENDONLY	READ-ONLY	VARIANT_FALSE
DBPROP_BLOCKINGSTORAGEOBJECTS	READ-ONLY	VARIANT_FALSE
DBPROP_BOOKMARKINFO	READ-ONLY	0
DBPROP_BOOKMARKS	READ/WRITE	VARIANT_FALSE
DBPROP_BOOKMARKSKIPPED	READ/WRITE	VARIANT_TRUE
DBPROP_BOOKMARKTYPE	READ-ONLY	DBPROP_BMK_NUMERIC
DBPROP_CACHEDEFERRED	READ-ONLY	VARIANT_FALSE
DBPROP_CANFETCHBACKWARDS	READ/WRITE	VARIANT_FALSE
DBPROP_CANHOLDROWS	READ/WRITE	VARIANT_TRUE
DBPROP_CANSCROLLBACKWARDS	READ/WRITE	VARIANT_FALSE
DBPROP_CHANGEINSERTEDROWS	READ-ONLY	VARIANT_TRUE
DBPROP_CLIENTCURSOR	READ/WRITE	VARIANT_TRUE
DBPROP_COLUMNRESTRICT	READ-ONLY	VARIANT_FALSE
DBPROP_COMMANDTIMEOUT	READ/WRITE	0, currently not operational
DBPROP_COMMITPRESERVE	READ/WRITE	VARIANT_TRUE
DBPROP_DEFERRED	READ-ONLY	VARIANT_FALSE
DBPROP_DELAYSTORAGEOBJECTS	READ-ONLY	VARIANT_FALSE, no delayed update
DBPROP_FINDCOMPAREOPS	READ-ONLY	DBPROPVAL_CO_EQUALITY | DBPROPVAL_CO_STRING | DBPROPVAL_CO_CASESENSITIVE | DBPROPVAL_CO_CASEINSENSITIVE | DBPROPVAL_CO_CONTAINS | DBPROPVAL_CO_BEGINSWITH
DBPROP_HIDDENCOLUMNS	READ-ONLY	0
DBPROP_IACCESSOR	READ-ONLY	VARIANT_TRUE
DBPROP_ICOLUMNSINFO	READ-ONLY	VARIANT_TRUE
DBPROP_ICOLUMNSROWSET	READ/WRITE	VARIANT_TRUE
DBPROP_ICONNECTIONPOINTCONTAINER	READ-ONLY	VARIANT_TRUE
DBPROP_ICONVERTTYPE	READ-ONLY	VARIANT_TRUE
DBPROP_IMMOBILEROWS	READ-ONLY	VARIANT_TRUE
DBPROP_IROWSET	READ-ONLY	VARIANT_TRUE
DBPROP_IROWSETCHANGE	READ/WRITE	VARIANT_FALSE
DBPROP_IROWSETFIND	READ/WRITE	VARIANT_FALSE
DBPROP_IROWSETIDENTITY	READ-ONLY	VARIANT_TRUE
DBPROP_IROWSETINFO	READ-ONLY	VARIANT_TRUE
DBPROP_IROWSETLOCATE	READ/WRITE	VARIANT_FALSE
DBPROP_IROWSETREFRESH	READ/WRITE	VARIANT_FALSE
DBPROP_IROWSETSCROLL	READ/WRITE	VARIANT_FALSE
DBPROP_IROWSETUPDATE	READ/WRITE	VARIANT_FALSE
DBPROP_ISEQUENTIALSTREAM	READ/WRITE	VARIANT_TRUE
DBPROP_ISUPPORTERRORINFO	READ/WRITE	VARIANT_TRUE
DBPROP_LITERALBOOKMARKS	READ-ONLY	VARIANT_FALSE
DBPROP_LITERALIDENTITY	READ-ONLY	VARIANT_TRUE
DBPROP_LOCKMODE	READ-ONLY	DBPROPVAL_LM_NONE
DBPROP_MAXOPENROWS	READ/WRITE	0, No limit
DBPROP_MAXPENDINGROWS	READ-ONLY	0, No limit
DBPROP_MAXROWS	READ/WRITE	0
DBPROP_MAXROWSIZE	READ-ONLY	0
DBPROP_MAXROWSIZEINCLUDESBLOB	READ-ONLY	VARIANT_FALSE
DBPROP_NOTIFICATIONGRANULARITY	READ/WRITE	DBPROPVAL_NT_MULTIPLEROWS
DBPROP_NOTIFICATIONPHASES	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_DIDEVENT
DBPROP_NOTIFYCOLUMNSET	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_DIDEVENT
DBPROP_NOTIFYROWDELETE	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_DIDEVENT
DBPROP_NOTIFYROWFIRSTCHANGE	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO
DBPROP_NOTIFYROWINSERT	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_DIDEVENT
DBPROP_NOTIFYROWRESYNCH	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER
DBPROP_NOTIFYROWSETRELEASE	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER
DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER
DBPROP_NOTIFYROWUNDOCHANGE	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_DIDEVENT
DBPROP_NOTIFYROWUNDODELETE	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_DIDEVENT
DBPROP_NOTIFYROWUNDOINSERT	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_DIDEVENT
DBPROP_NOTIFYROWUNDOUPDATE	READ/WRITE	DBPROPVAL_NP_OKTODO | DBPROPVAL_NP_ABOUTTODO | DBPROPVAL_NP_SYNCHAFTER | DBPROPVAL_NP_FAILEDTODO | DBPROPVAL_NP_DIDEVENT
DBPROP_ORDEREDBOOKMARKS	READ-ONLY	VARIANT_TRUE
DBPROP_OTHERINSERT	READ-ONLY	VARIANT_FALSE
DBPROP_OTHERUPDATEDELETE	READ-ONLY	VARIANT_FALSE
DBPROP_OWNINSERT	READ-ONLY	VARIANT_TRUE
DBPROP_OWNUPDATEDELETE	READ-ONLY	VARIANT_TRUE
DBPROP_QUICKRESTART	READ/WRITE	VARIANT_FALSE
DBPROP_REENTRANTEVENTS	READ-ONLY	VARIANT_FALSE
DBPROP_REMOVEDELETED	READ-ONLY	VARIANT_TRUE
DBPROP_REPORTMULTIPLECHANGES	READ-ONLY	VARIANT_FALSE
DBPROP_RETURNPENDINGINSERTS	READ/WRITE	VARIANT_TRUE
DBPROP_ROWRESTRICT	READ/WRITE	VARIANT_FALSE
DBPROP_ROWTHREADMODEL	READ-ONLY	DBPROPVAL_RT_FREETHREAD
DBPROP_SERVERCURSOR	READ/WRITE	VARIANT_FALSE
DBPROP_SERVERDATAONINSERT	READ/WRITE	VARIANT_TRUE
DBPROP_STRONGIDENTITY	READ/WRITE	VARIANT_TRUE
DBPROP_TRANSACTEDOBJECT	READ-ONLY	VARIANT_TRUE
DBPROP_UNIQUEROWS	READ/WRITE	VARIANT_FALSE
DBPROP_UPDATABILITY	READ/WRITE	DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_DELETE | DBPROPVAL_UP_INSET

Rowset Property Implications

Oracle Provider for OLE DB sets other necessary properties if a particular property is set to VARIANT_TRUE.

• If DBPROP_IROWSETLOCATE is set to VARIANT_TRUE, the following properties are also set to VARIANT_TRUE:
  • DBPROP_IROWSETIDENTITY

  • DBPROP_CANHOLDROWS

  • DBPROP_BOOKMARKS

  • DBPROP_CANFETCHBACKWARDS

  • DBPROP_CANSCROLLBACKWARDS

• If DBPROP_IROWSETSCROLL is set to VARIANT_TRUE, the following properties are also set to VARIANT_TRUE:
  • DBPROP_IROWSETIDENTITY

  • DBPROP_IROWSETLOCATE

  • DBPROP_CANHOLDROWS

  • DBPROP_BOOKMARKS

  • DBPROP_CANFETCHBACKWARDS

  • DBPROP_CANSCROLLBACKWARDS

• If DBPROP_IROWSETUPDATE is to VARIANT_TRUE, the following properties are also set to VARIANT_TRUE:
  • DBPROP_IROWSETCHANGE

Interfaces Supported

This section identifies the OLE DB interfaces that are supported by Oracle Provider for OLE DB.

• Data Source Objects

• Sessions

• Commands

• Rowsets

• Transaction Options

• Custom Error Objects

Data Source Objects

   CoType TDataSource {
      interface IDBCreateSession;
      interface IDBInitialize;
      interface IDBProperties;
      interface IPersist;
      interface IDBInfo;
      interface ISupportErrorInfo;
   }

Sessions

   CoType TSession {
      interface IGetDataSource;
      interface IOpenRowset;
      interface ISessionProperties;
      interface IDBCreateCommand;
      interface IDBSchemaRowset;
      interface ISupportErrorInfo;
      interface ITransactionJoin;
      interface ITransactionLocal;
      interface ITransaction;
   }

Commands

   CoType TCommand {
      interface IAccessor;
      interface IColumnsInfo;
      interface ICommand;
      interface ICommandProperties;
      interface ICommandText;
      interface IConvertType;
      interface IColumnsRowset;
      interface ICommandPrepare;
      interface ICommandWithParameters;
      interface ISupportErrorInfo;
   }

Rowsets

   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;
   }

Transaction Options

   CoType TTransactionOptions {
      interface ITransactionOptions;
      interface ISupportErrorInfo;
   }

Custom Error Objects

   CoType TCustomErrorObject {
      interface IErrorLookup;
   }

MetaData Columns Supported

The following metadata columns are supported by OraOLEDB's column rowset:

• DBCOLUMN_IDNAME

• DBCOLUMN_GUID

• DBCOLUMN_PROPID

• DBCOLUMN_NAME

• DBCOLUMN_NUMBER

• DBCOLUMN_TYPE

• DBCOLUMN_TYPEINFO

• DBCOLUMN_COLUMNSIZE

• DBCOLUMN_PRECISION

• DBCOLUMN_SCALE

• DBCOLUMN_FLAGS

• DBCOLUMN_BASECATALOGNAME

• DBCOLUMN_BASECOLUMNNAME

• DBCOLUMN_BASESCHEMANAME

• DBCOLUMN_BASETABLENAME

• DBCOLUMN_COMPUTEMODE

• DBCOLUMN_ISAUTOINCREMENT

• DBCOLUMN_ISCASESENSITIVE

• DBCOLUMN_ISSEARCHABLE

• DBCOLUMN_OCTETLENGTH

• DBCOLUMN_KEYCOLUMN