What's New in OraOLEDB?

The following sections describe the new features in Oracle Provider for OLE DB (OraOLEDB):

• New Features in Oracle Provider for OLE DB for Release 10.2

• New Features in Oracle Provider for OLE DB for Release 10.1

• 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.2

• 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

New Features in Oracle Provider for OLE DB for Release 10.2

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.

New Features in Oracle Provider for OLE DB for Release 10.1

This section contains these topics:

• Support for Oracle Grids

  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 types

• Support for Multiple Homes

  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.

  See Also:

  Oracle Provider for OLE DB Files

New Features in Oracle Provider for OLE DB for Release 9.2.0.4

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.

  See Also:

  "OraOLEDB-specific Connection String Attributes"

• 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 types

New Features in Oracle Provider for OLE DB for Release 9.2

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.

  See Also:

  "OLEDB.NET Data Provider Compatibility"

New Features in Oracle Provider for OLE DB for Release 9.0.1

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.

  See Also:

  Oracle Database Platform Guide for Windows

New Features in Oracle Provider for OLE DB for Release 8.1.7

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.

  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.

  See Also:

  • "Unicode Support"

  • "Data Type Mappings in Rowsets and Parameters"