Oracle® Provider for OLE DB Developer's Guide 10g Release 2 (10.2) Part Number B14311-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
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
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.