What's New in Oracle Objects for OLE?

This section describes new features of Oracle Database 11g Release 2 (11.2) and provides pointers to additional information. New features information from previous releases is also retained to help those users migrating to the current release.

The following sections describe the new features in Oracle Oracle Objects for OLE:

Oracle Database 10g Release 2 (10.2) New Features

There are no new features for this release.

Documentation for Oracle Objects for OLE was improved and reorganized, although there is no additional content. The documentation was reformatted to a printable, PDF format. PDF and HTML are provided in the Documentation Library. Online Help in WinHelp format is no longer provided.

Oracle Database 10g Release 1 (10.1) New Features

Support for Oracle Grid Computing

Oracle Objects for OLE is grid-enabled, allowing developers to take advantage of Oracle database grid support without having to make changes to their application code.

Support for New Data Types

Oracle Objects for OLE provides support for the BINARY_DOUBLE and BINARY_FLOAT data types introduced in Oracle Database 10g. Instances of these types can be fetched from the database or passed as input or output variables to SQL statements and PL/SQL locks, including stored procedures and functions.

The following constants were added in the oraconst.txt to bind the BINARY_DOUBLE and BINARY_FLOAT data types.

ORATYPE_BDOUBLE, Oracle data type BINARY_DOUBLE, value 101

ORATYPE_BFLOAT, Oracle data type BINARY_FLOAT, value 100

Support for Multiple Oracle Homes

Oracle Objects for OLE can be installed in multiple Oracle homes, starting with release 10.1. However, being a Component Object Model (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 Oracle homes available, the use of a KEY_HOMENAME is required. Also, some of the Oracle Objects for OLE files include a version number.