| Oracle® Provider for OLE DB Developer's Guide 11g Release 1 (11.1) Part Number B28431-01 |
|
|
View PDF |
| Oracle® Provider for OLE DB Developer's Guide 11g Release 1 (11.1) Part Number B28431-01 |
|
|
View PDF |
The following sections describe the new features in Oracle Provider for OLE DB (OraOLEDB):
New Features in Oracle Provider for OLE DB for Release 9.2.0.4
New Features in Oracle Provider for OLE DB for Release 9.0.1
New Features in Oracle Provider for OLE DB for Release 8.1.7
Oracle Provider for OLE DB release 11.1 includes the following:.
Improved Statement and Metadata Caching
This release enhances the existing caching infrastructure to cache OraOLEDB data buffers and metadata information. This enhancement is independent of Database version and is available for all supported Database versions. This feature provides significant performance improvement for the applications that execute the same statement repeatedly.
See Also:
Enhanced Failover Capability
Oracle Provider for OLE DB introduced new connection string attributes and registry entries to enhance failover capability.
See Also:
"Enhanced Failover Capability"Support of ADO Disconnected Recordsets
Oracle Provider for OLE DB introduced a new connection string attribute and registry entry to support ADO disconnected recordsets.
Support for Statement Caching has been added as a new feature for Oracle Provider for OLE DB for release 10.2.
This feature provides and manages a cache of statements for each session. The developer can control what statements are cached and how many. This improves performance and scalability of the database.
See Also:
Statement CachingThis section contains these topics:
OraOLEDB is grid-enabled, allowing developers to take advantage of Oracle Database grid support without having to make changes to their application code.
Support for the following data types introduced with Oracle Database 10g:
BINARY_DOUBLE
BINARY_FLOAT
See Also:
"Data Types" for descriptions of the new data typesOracle Provider for OLE DB can be installed in multiple Oracle homes, starting with release 10.1. However, Oracle Provider for OLE DB being a COM component, only one instance can be active on the computer. This means that the current (latest) installation renders the previous one inactive.
To make multiple homes available, some of the OraOLEDB files now include a version number, and the use of a KEY_HOMENAME is required.
See Also:
Oracle Provider for OLE DB FilesOraOLEDB release 9.2.0.4, which was released on Oracle Technology Network (OTN) included the following:
OraOLEDB-Specific Connection String Attribute UseSessionFormat:
UseSessionFormat specifies whether to use the default NLS session formats or let OraOLEDB override some of these formats for the duration of the session.
Support for the following data types introduced with Oracle9i:
TIMESTAMP
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
See Also:
"Data Types" for descriptions of the new data typesThis section contains these topics:
Support for using OraOLEDB with OLEDB.NET Data Provider
ADO.NET application developers can use OraOLEDB through the OLEDB.NET Data Provider. A connection attribute, OLEDB.NET, can be set at connection time for OraOLEDB to be compatible with OLEDB.NET Data Provider.
See Also:
"OLEDB.NET Data Provider Compatibility"This section contains these topics:
Using Oracle9i on Windows 2000
There are some differences between using Oracle9i on Windows 2000 than earlier versions of Windows.
Oracle8i release 8.1.7 included the following:
Support for returning multiple rowsets
Consumers can use this feature to access all the REF CURSOR values returned by a stored procedure.
See Also:
"Multiple Rowsets"Support for the Unicode character set
Using this feature, consumers can use OraOLEDB to access data in multiple languages on the same client computer. It can be especially useful in creating global Internet applications supporting as many languages as the Unicode standard entails. For example, one can write a single Active Server Page (ASP) application that accesses an Oracle8i database to dynamically generate content in Japanese, Arabic, English, and Thai.
