What's New in Pro*C/C++?

This section describes new features of Pro*C/C++ releases 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 Pro*C/C++:

• Oracle 11g Release 2 (11.2) New Features in Pro*C/C++

• Oracle 11g Release 1 (11.1) New Features in Pro*C/C++

Oracle 11g Release 2 (11.2) New Features in Pro*C/C++

The following are the new features in the Pro*C/C++ application in Oracle11g Release 2:

• Support for 8-Byte Integer

  Pro*C/C++ now supports the native C long long int datatype. Integers of up to 18 digits can be used on 32 bit and 64 bit platforms.

  See Also:

  INTEGER

• Optional WITH HOLD clause in DECLARE CURSOR statement

  The new WITH HOLD clause in the DECLARE CURSOR statement specifies a held cursor that remains open after COMMIT.

  See Also:

  DECLARE CURSOR (Embedded SQL Directive)

Oracle 11g Release 1 (11.1) New Features in Pro*C/C++

The following are the new features in the Pro*C/C++ application in Oracle11g Release 1:

• SQL99 Syntax Support

  With this enhancement, the SQL99 syntax for SELECT, INSERT, DELETE, and UPDATE statements and the body of the cursor in a DECLARE CURSOR statement will be supported.

• Fix Execution Plan

  By using the outline feature, you can ensure that the performance of the database is not affected when modules are integrated and deployed into different environments.

• Using Additional Array Insert/Select Syntax

  The array INSERT and array SELECT syntax of DB2 precompiler is now supported by Pro*C/C++.

• Using Implicit Buffered Insert

  Pro*C/C++ supports implicit buffering of a single INSERT statement executed in a loop.

• Dynamic SQL Statement Caching

  Statement caching can be used to improve the performance of dynamic SQL statements.