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
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.
This 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
Oracle 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.
OraOLEDB 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
This 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.
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 valuess returned by a stored procedure.
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.