Oracle Provider for OLE DB User's Guide
Release 8.1.6

A75235-01

Library

Product

Contents

Index

Prev Next

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

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

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 

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 

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 

DBPROP_MAXROWSIZE 

READ-ONLY 

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.

Interfaces Supported

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

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:


Prev Next
Oracle
Copyright © 2000 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index