What's New in Oracle C++ Call lnterface?

This section describes new features in Oracle C++ Call Interface Programmer's Guide and supplies pointers to additional information.

New Features for Oracle Database 10g Release 2 (10.2)

The following OCCI features are new to the Oracle Database 10g Release 2:

OCCI Libraries for Microsoft Visual C++

Information about these libraries is in section "Using OCCI with Microsoft Visual C++" in Chapter 2, " Installation and Upgrading".

Recompilation during Upgrades

Upgrading Considerations are discussed in Chapter 2, " Installation and Upgrading".

Reading and Writing Multiple LOBs

The description and usage notes for this feature are in Chapter 11, "Optimizing Performance of OCCI Applications", section Reading and Writing Multiple LOBs.

New APIs for this features are described in Chapter 12, "OCCI Application Programming Interface", section on Connection Class:

• readVectorOfBfiles()

• readVectorOfBlobs()

• readVectorOfClobs(); this method is overloaded to support general charactersets, and the UTF16 characterset in particular

• writeVectorOfBlobs()

• writeVectorOfClobs(); this method is overloaded to support general charactersets, and the UTF16 characterset in particular

Transparant Application Failover

The description and usage notes for this feature are in Chapter 11, "Optimizing Performance of OCCI Applications", section "Transparent Application Failover".

The callback registration method is described in Chapter 12, "OCCI Application Programming Interface", section on Connection Class:

• setTAFNotify()

Instant Client Light (English)

Instant Client Light (English) further reduces the disk space and configuration requirements of Instant Client, saving another 63 MB of disk space at installation. The description and usage notes for this feature are in Chapter 2, " Installation and Upgrading", section "Instant Client Light (English)" .

Modifying Rows Iteratively

This release added batch handling for errors generated during multiple row inserts or updates. The description and usage notes for this feature are documented in Chapter 11, "Optimizing Performance of OCCI Applications", section "Modifying Rows Iteratively".

New APIs for this features are described in Chapter 12, "OCCI Application Programming Interface", section on Statement Class:

• getBatchErrorMode()

• setBatchErrorMode()

This feature also introduces a new BatchSQLException Class, which extends the SQLException Class. It is described in Chapter 12, "OCCI Application Programming Interface", and has the following methods in addition to the ones it naturally inherits:

• getFailedRowCount()

• getRowNum()

• getException()

Determining the Version of the Client Library and the Oracle Server

This release added support for determining the version of the client library used at run time and at compile time, and for determining the version of the Oracle server. The description and usage notes for this feature are documented in Chapter 2, " Installation and Upgrading", section "Determining Client and Server Versions".

New APIs for this feature are described in Chapter 12, "OCCI Application Programming Interface", section on Environment Class:

• getClientVersion()

• getServerVersion()

• getServerVersionUString()

New Features for Oracle Database 10g Release 1 (10.1)

The following OCCI features are new to the Oracle Database 10g Release 1:

• OCCI Support for Windows NT for accessing collections of Refs in ResultSet Class and Statement Class, in Chapter 12, "OCCI Application Programming Interface"

• This release provides OCCI libraries for Microsoft CRT debugging and for developing applications with Microsoft Visual C++ 7.0 (.NET). Please see the Windows platform Readme for details on supported compiler versions.

• NATIVE DOUBLE Datatype in Chapter 5, "Datatypes" supports IEEE754Double

• NATIVE FLOAT Datatype in Chapter 5, "Datatypes" supports IEEE754Float

• Instant Client in Chapter 2, " Installation and Upgrading"

• Enhancements in the base PObject Class and in Chapter 7, "Object Type Translator Utility"; OTT C++ classes must be re-generated after migrating to this release

• Stateless Connection Pooling and StatelessConnectionPool Class

• Globalization and Unicode support in the new Chapter 8, "Globalization and Unicode Support"

• Oracle Streams Advanced Queuing in the new Chapter 9, "Oracle Streams Advanced Queuing"

• XA Compliance support in the new Chapter 10, "Oracle XA Library"

• "Caching Statements" in Chapter 3, " Relational Programming"

• Array Pinning for Objects: Section "Transient Objects" in Chapter 4, " Object Programming".

• Section in "Migrating C++ Applications Using OCCI" in Chapter 4, " Object Programming"

• Timestamp Class in Chapter 12, "OCCI Application Programming Interface"behavior is enhanced:

  • Users no longer need to convert to GMT when using Timestamp() constructor, or in methods setDate() and setTime()

  • New constructors that support timezone information as string or UString(Unicode) enable users to pass a region name, such as "US/Eastern", as a timezone. These provide daylight savings(DST) support. Using an empty string, "", constructs a timestamp in the local timezone.

  • New support for all three TIMESTAMP types in the database, for both relational and objects access: TIMESTAMP, TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE.