B Provider-Specific OLE DB Information

Topics:

Datatype Mappings

This section lists the datatype mappings between Oracle datatypes and OLE DB datatypes. Oracle OLAP Provider for OLE DB represents Oracle datatypes by using certain OLE DB datatypes. Each Oracle datatype is mapped to a specific OLE DB datatype. This correspondence is used when data is retrieved from Oracle Databases.

Table B-1 Datatype Mappings

Mapping Oracle Datatype OLE DB Datatype

1

BINARY_DOUBLE

DBTYPE_R8

2

BINARY_FLOAT

DBTYPE_R4

3

CHAR

DBTYPE_WSTR

4

DATE

DBTYPE_DBTIMESTAMP

5

FLOAT

DBTYPE_R8

6

NCHAR

DBTYPE_WSTR

7

NUMBER

DBTYPE_VARNUMERIC

8

NUMBER (p, s)

DBTYPE_NUMERIC

9

NVARCHAR2

DBTYPE_WSTR

10

VARCHAR

DBTYPE_WSTR

Objects

The provider exposes OLAP-specific as well as OLE DB core interfaces. This section identifies the objects that the Oracle OLAP Provider for OLE DB exposes:

  • Data Source

  • Session

  • Command

  • Rowset

  • Dataset

  • Errors

  • Error Records

Interfaces

The provider exposes the following OLE DB and OLE DB for OLAP interfaces.

Data Source Object Interfaces

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

Session Object Interfaces

    CoType TSession {
       interface IGetDataSource;
       interface IDBCreateCommand;
       interface ISessionProperties;
       interface IDBSchemaRowset;
       interface ISupportErrorInfo;
    }

Command Object Interface

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

Rowset Object interfaces

  CoType TRowset {
       interface IAccessor;
       interface IColumnsInfo;
       interface IConvertType;
       interface IRowset;
       interface IRowsetInfo;
       interface IConnectionPointContainer;
       interface IRowsetLocate;
       interface IRowsetScroll;
       interface ISupportErrorInfo;
    }
 

DataSet Object Interface

   CoType TDataset {
       interface IAccessor;
       interface IConvertType;
       interface IColumnsInfo;
       interface IMDDataset;
       interface ISupportErrorInfo;
    }

Error Object Interfaces

    CoType TErrorObject {
       interface IErrorRecords;
    }

Error Records Interfaces

CoType TErrorRecord {
       interface IErrorInfo;
    }

Properties

This section lists the properties supported by the provider. R/W indicates read, or write or both.

For details on the definition (including the type, and equivalent ADO MD property name) of the listed properties in this section, read the Microsoft OLE DB and OLE DB for OLAP documentation .

Data Source Properties

Table B-2 lists the data source properties that the provider supports, with their default values.

Table B-2 DBPROPSET_DATASOURCE

Property R/W Default Value

DBPROP_CURRENTCATALOG

R

""

DBPROP_MULTIPLECONNECTIONS

R

VARIANT_FALSE

Data Source Info Properties

Table B-3 lists the data source info properties that the provider supports, with their default values.

Table B-3 DBPROPSET_DATASOURCEINFO

Property R/W Default Value

DBPROP_ACTIVESESSIONS

R

0 (unlimited)

DBPROP_BYREFACCESSORS

R

VARIANT_FALSE

DBPROP_CATALOGLOCATION

R

0 (not supported)

DBPROP_CATALOGTERM

R

""

DBPROP_CATALOGUSAGE

R

0 (not supported)

DBPROP_COLUMNDEFINITION

R

0 (not supported)

DBPROP_CONCATNULLBEHAVIOR

R

DBPROPVAL_CB_NON_NULL

DBPROP_CONNECTIONSTATUS

R

Dynamically set to status of connection

DBPROP_DATASOURCENAME

R

Dynamically set to tns alias string

DBPROP_DATASOURCEREADONLY

R

VARIANT_FALSE

DBPROP_DATASOURCE_TYPE

R

DBPROPVAL_DST_MDP

DBPROP_DBMSNAME

R

"Oracle"

DBPROP_DBMSVER

R

Dynamically set to version # string

DBPROP_DSOTHREADMODEL

R

DBPROPVAL_RT_FREETHREAD

DBPROP_GROUPBY

R

DBPROPVAL_GB_CONTAINS_SELECT

DBPROP_HETEROGENEOUSTABLES

R

0 (not supported)

DBPROP_IDENTIFIERCASE

R

0 (not supported)

DBPROP_MAXINDEXSIZE

R

0 (unlimited)

DBPROP_MAXOPENCHAPTERS

R

0 (not supported)

DBPROP_MAXROWSIZE

R

0 (unlimited)

DBPROP_MAXROWSIZEINCLUDESBLOB

R

VARIANT_FALSE

DBPROP_MAXTABLESINSELECT

R

0 (unlimited, unknown, or not applicable)

DBPROP_MULTIPLEPARAMSETS

R

VARIANT_FALSE

DBPROP_MULTIPLERESULTS

R

DBPROPVAL_MR_NOTSUPPORTED

DBPROP_MULTITABLEUPDATE

R

VARIANT_FALSE

DBPROP_NULLCOLLATION

R

DBPROPVAL_NC_HIGH

DBPROP_OLEOBJECTS

R

0 (not supported)

DBPROP_ORDERBYCOLUMNSINSELECT

R

VARIANT_FALSE

DBPROP_OUTPUTPARAMETERAVAILABILITY

R

DBPROPVAL_OA_NOTSUPPRTED

DBPROP_PERSISTENTIDTYPE

R

DBPROPVAL_PT_NAME

DBPROP_PREPAREABORTBEHAVIOR

R

0 (not supported)

DBPROP_PREPARECOMMITBEHAVIOR

R

0 (not supported)

DBPROP_PROCEDURETERM

R

"Calculated member"

DBPROP_PROVIDERFRIENDLYNAME

R

"Oracle OLAP Provider for OLE DB"

DBPROP_PROVIDERMEMORY

R

VARIANT_FALSE

DBPROP_PROVIDERFILENAME

R

"OraOLEDBOLAP10.dll"

DBPROP_PROVIDEROLEDBVER

R

"2.7"

DBPROP_PROVIDERVER

R

"10.1.0.2.0"

DBPROP_QUOTEDIDENTIFIERCASE

R

0 (not supported)

DBPROP_ROWSETCONVERSIONSONCOMMAND

R

VARIANT_TRUE

DBPROP_SCHEMATERM

R

"Schema"

DBPROP_SCHEMAUSAGE

R

0 (not supported)

DBPROP_SERVERNAME

R

"Oracle"

DBPROP_SQLSUPPORT

R

DBPROPVAL_SQL_NONE

DBPROP_STRUCTUREDSTORAGE

R

0 (not supported)

DBPROP_SUBQUERIES

R

0 (not supported)

DBPROP_SUPPORTEDTXNDDL

R

0 (not supported)

DBPROP_SUPPORTEDTXNISOLEVELS

R

0 (not supported)

DBPROP_SUPPORTEDTXNISORETAIN

R

0 (not supported)

DBPROP_TABLETERM

R

"Cube"

DBPROP_USERNAME

R

Dynamically set to user id string

MDPROP_AGGREGATECELL_UPDATE

R

MDPROPVAL_AU_UNSUPPORTED

MDPROP_AXES

R

0 (no limit)

MDPROP_FLATTENING_SUPPORT

R

MDPROPVAL_FS_NO_SUPPORT

MDPROP_MDX_CASESUPPORT

R

0 (not supported)

MDPROP_MDX_DESCFLAGS

R

MDPROPVAL_MD_BEFORE |

MDPROPVAL_MD_AFTER |

MDPROPVAL_MD_SELF

MDPROP_MDX_FORMULAS

R

MDPROPVAL_MF_WITH_NAMEDSETS |

MDPROPVAL_MF_CREATE_CALCMEMBERS |

MDPROPVAL_MF_CREATE_NAMEDSETS |

MDPROPVAL_MF_SCOPE_SESSION

MDPROP_MDX_JOINCUBES

R

MDPROPVAL_MJC_SINGLECUBE

MDPROP_MDX_MEMBER_FUNCTIONS

R

MDPROPVAL_MMF_COUSIN |

MDPROPVAL_MMF_PARALLELPERIOD |

MDPROPVAL_MMF_OPENINGPERIOD |

MDPROPVAL_MMF_CLOSINGPERIOD

MDPROP_MDX_NONMEASURE_EXPRESSIONS

R

MDPROPVAL_NME_ALLDIMENSIONS

MDPROP_MDX_NUMERIC_FUNCTIONS

R

MDPROPVAL_MNF_MEDIAN |

MDPROPVAL_MNF_VAR |

MDPROPVAL_MNF_STDDEV

MDPROP_MDX_OBJQUALIFICATION

R

MDPROPVAL_MOQ_CUBE_DIM |

MDPROPVAL_MOQ_DIM_HIER |

MDPROPVAL_MOQ_DIMHIER_LEVEL |

MDPROPVAL_MOQ_DIMHIER_MEMBER |

MDPROPVAL_MOQ_LEVEL_MEMBER

MDPROP_MDX_QUERYBYPROPERTY

R

VARIANT TRUE

MDPROP_MDX_SET_FUNCTIONS

R

MDPROPVAL_MSF_TOPPERCENT |

MDPROPVAL_MSF_BOTTOMPERCENT |

MDPROPVAL_MSF_TOPSUM |

MDPROPVAL_MSF_BOTTOMSUM |

MDPROPVAL_MSF_DRILLDOWNMEMBER |

MDPROPVAL_MSF_DRILLDOWNMEMBERTOP|

MDPROPVAL_MSF_DRILLDOWNMEMBERBOTTOM |

MDPROPVAL_MSF_DRILLDOWNLEVELTOP |

MDPROPVAL_MSF_DRILLDOWNLEVELBOTTOM |

MDPROPVAL_MSF_DRILLUPMEMBER |

MDPROPVAL_MSF_DRILLUPLEVEL |

MDPROPVAL_MSF_DRILLDOWNLEVEL |

MDPROPVAL_MSF_PERIODSTODATE |

MDPROPVAL_MSF_LASTPERIODS |

MDPROPVAL_MSF_YTD |

MDPROPVAL_MSF_QTD |

MDPROPVAL_MSF_MTD |

MDPROPVAL_MSF_WTD

MDPROP_MDX_SLICER

R

MDPROPVAL_MS_SINGLETUPLE

MDPROP_MDX_STRING_COMPOP

R

MDPROPVAL_MSC_LESSTHAN |

MDPROPVAL_MSC_GREATERTHAN |

MDPROPVAL_MSC_LESSTHANEQUAL |

MDPROPVAL_MSC_GREATERTHANEQUAL

MDPROP_NAMED_LEVELS

R

MDPROPVAL_NL_NAMEDLEVELS |

MDPROPVAL_NL_NUMBEREDLEVELS

MDPROP_RANGEROWSET

R

MDPROPVAL_RR_NORANGEROWSET

MDPROP_VISUALMODE

R

MDPROPVAL_VISUAL_MODE_VISUALOFF

Initialization and Authorization Properties

Table B-4 lists the initialization and authorization properties that the provider supports, with their default values.

Table B-4 DBPROPSET_DBINIT

Property R/W Default Value

DBPROP_AUTH_PASSWORD

R/W

Dynamically set to password string

DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO

R

VARIANT_FALSE

DBPROP_AUTH_USERID

R/W

Dynamically set to user id string

DBPROP_INIT_DATASOURCE

R/W

Dynamically set to tns alias string

DBPROP_INIT_HWND

R/W

0

DBPROP_INIT_LCID

R/W

Dynamically set to System LCID

DBPROP_INIT_OLEDBSERVICES

R/W

DBPROPVAL_OS_ENABLEALL

DBPROP_INIT_PROMPT

R/W

DBPROMPT_NOPROMPT

DBPROP_INIT_PROVIDERSTRING

R/W

Dynamically set to provider-specific string attribute settings

Rowset Properties

Table B-5 lists the rowset properties that this release supports, with their default values.

Table B-5 DBPROP_ROWSET

Property R/W Default Value

DBPROP_ACCESSORDER

R

DBPROP_AO_RANDOM

DBPROP_APPENDONLY

R

VARIANT_FALSE

DBPROP_BOOKMARKINFO

R

0

DBPROP_BOOKMARKS

R/W

VARIANT_TRUE

DBPROP_BOOKMARKSKIPPED

R/W

VARIANT_TRUE

DBPROP_BOOKMARKTYPE

R

DBPROP_BMK_NUMERIC

DBPROP_CACHEDEFERRED

R

VARIANT_FALSE

DBPROP_CANFETCHBACKWARDS

R/W

VARIANT_TRUE

DBPROP_CANHOLDROWS

R/W

VARIANT_FALSE

DBPROP_CANSCROLLBACKWARDS

R/W

VARIANT_TRUE

DBPROP_CHANGEINSERTEDROWS

R

VARIANT_FALSE

DBPROP_CLIENTCURSOR

R/W

VARIANT_TRUE

DBPROP_COLUMNRESTRICT

R

VARIANT_TRUE

DBPROP_COMMANDTIMEOUT

R

0 (unlimited)

DBPROP_DEFERRED

R

VARIANT_FALSE

DBPROP_FINDCOMPAREOPS

R

DBPROPVAL_CO_EQUALITY |

DBPROPVAL_CO_STRING |

DBPROPVAL_CO_CASESENSITIVE |

DBPROPVAL_CO_CASEINSENSITIVE |

DBPROPVAL_CO_CONTAINS |

DBPROPVAL_CO_BEGINSWITH

DBPROP_HIDDENCOLUMNS

R

0

DBPROP_IAccessor

R

VARIANT_TRUE

DBPROP_IColumnsInfo

R

VARIANT_TRUE

DBPROP_IColumnsRowset

R/W

VARIANT_TRUE

DBPROP_IConnectionPointContainer

R

VARIANT_TRUE

DBPROP_IConvertType

R

VARIANT_TRUE

DBPROP_IMMOBILEROWS

R

VARIANT_TRUE

DBPROP_IMultipleResults

R

VARIANT_FALSE

DBPROP_IRowset

R

VARIANT_TRUE

DBPROP_IRowsetChange

R

VARIANT_FALSE

DBPROP_IRowsetFind

R

VARIANT_FALSE

DBPROP_IRowsetIdentity

R

VARIANT_FALSE

DBPROP_IRowsetInfo

R

VARIANT_TRUE

DBPROP_IRowsetLocate

R/W

VARIANT_TRUE

DBPROP_IRowsetRefresh

R

VARIANT_FALSE

DBPROP_IRowsetScroll

R/W

VARIANT_TRUE

DBPROP_IRowsetUpdate

R

VARIANT_FALSE

DBPROP_ISupportErrorInfo

R

VARIANT_TRUE

DBPROP_LITERALBOOKMARKS

R

VARIANT_FALSE

DBPROP_LITERALIDENTITY

R

VARIANT_FALSE

DBPROP_LOCKMODE

R

DBPROPVAL_LM_NONE

DBPROP_MAXOPENROWS

R/W

0 (unlimited)

DBPROP_MAXPENDINGROWS

R

0 (unlimited)

DBPROP_MAXROWS

R/W

0 (unlimited)

DBPROP_MAXROWSIZE

R

0 (unlimited)

DBPROP_MAXROWSIZEXINCLUDESBLOB

R

VARIANT_FALSE

DBPROP_NOTIFICATIONGRANULARITY

R

DBPROPVAL_NT_MULTIPLEROWS

DBPROP_NOTIFICATIONPHASES

R

DBPROPVAL_NP_OKTODO |

DBPROPVAL_NP_ABOUTTODO |

DBPROPVAL_NP_SYNCHAFTER |

DBPROPVAL_NP_DIDEVENT |

DBPROPVAL_NP_FAILEDTODO

DBPROP_NOTIFYCOLUMNSET

R

0 (unlimited)

DBPROP_NOTIFYROWDELETE

R

0 (unlimited)

DBPROP_NOTIFYROWFIRSTCHANGE

R

0 (unlimited)

DBPROP_NOTIFYROWINSERT

R

0 (unlimited)

DBPROP_NOTIFYROWRESYNCH

R/W

DBPROPVAL_NP_OKTODO |

DBPROPVAL_NP_ABOUTTODO |

DBPROPVAL_NP_SYNCHAFTER

DBPROP_NOTIFYROWSETCHANGED

R

0 (not supported)

DBPROP_NOTIFYROWSETFETCHPOSITIONCHANGE

R/W

DBPROPVAL_NP_OKTODO |

DBPROPVAL_NP_ABOUTTODO |

DBPROPVAL_NP_SYNCHAFTER

DBPROP_NOTIFYROWSETRELEASE

R/W

DBPROPVAL_NP_OKTODO |

DBPROPVAL_NP_ABOUTTODO |

DBPROPVAL_NP_SYNCHAFTER

DBPROP_NOTIFYROWUNDOCHANGE

R

0 (not supported)

DBPROP_NOTIFYROWUNDODELETE

R

0 (not supported)

DBPROP_NOTIFYROWUNDOINSERT

R

0 (not supported)

DBPROP_NOTIFYROWUPDATE

R

0 (not supported)

DBPROP_ORDEREDBOOKMARKS

R

VARIANT_TRUE

DBPROP_OTHERINSERT

R

VARIANT_FALSE

DBPROP_OTHERUPDATEDELETE

R

VARIANT_FALSE

DBPROP_OWNINSERT

R

VARIANT_FALSE

DBPROP_OWNUPDATEDELETE

R

VARIANT_FALSE

DBPROP_QUICKRESTART

R/W

VARIANT_FALSE

DBPROP_REENTRANTEVENTS

R

VARIANT_FALSE

DBPROP_REMOVEDELETED

R

VARIANT_FALSE

DBPROP_REPORTMULTIPLECHANGES

R

VARIANT_FALSE

DBPROP_RETURNPENDINGINSERTS

R

VARIANT_FALSE

DBPROP_ROWRESTRICT

R

VARIANT_FALSE

DBPROP_ROWTHREADMODEL

R

DBPROPVAL_RT_FREETHREAD

DBPROP_SERVERCURSOR

R/W

VARIANT_FALSE

DBPROP_STRONGIDENTITY

R/W

VARIANT_TRUE

DBPROP_UNIQUEROWS

R/W

VARIANT_FALSE

DBPROP_UPDATABILITY

R

0 (not supported)

Rowset Property Implications

OraOLEDB OLAP 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_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_IROWSETLOCATE

  • DBPROP_CANHOLDROWS

  • DBPROP_BOOKMARKS

  • DBPROP_CANFETCHBACKWARDS

  • DBPROP_CANSCROLLBACKWARDS

Session Properties

Table B-6 lists the data source info properties that this release supports, with their default values.

Table B-6 DBPROPSET_SESSION

Property R/W Default Value

DBPROP_SESS_AUTOCOMMITISOLEVELS

R

0 (not supported)

Provider-Specific Properties

Oracle OLAP Provider for OLE DB provides the following provider-specific properties:

Rowset-Related Property

Table B-7 lists the rowset-related provider-specific OLE DB property.

Table B-7 Rowset Fetch Size

Property Name Type R/W Default Value

DBPROP_ORAOLEDBOLAP_ROWSETFETCHSIZE

VT_I4

R/W

262144

Provider-Specific Command Properties

Table B-8 lists the provider-specific OLE DB Properties, which are related to cube caching and enabling maximum precision of NUMBER and FLOAT column values.

Table B-8 Caching-Related Properties

Property Name Type R/W Default Value

MDPROP_ORAOLEDBOLAP_CELLDATACACHE

VT_BOOL

R/W

VARIANT_TRUE

MDPROP_ORAOLEDBOLAP_CACHEBLOCKSIZE

VT_ARRAY |

VT_I4

R/W

NULL

MDPROP_ORAOLEDBOLAP_PRESERVEMAXPRECISION

VT_BOOL

R/W

VARIANT_FALSE