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++:

• Oracle11g Release 1(11.1) New Features in Pro*C/C++

• Oracle10g Release 2 (10.2) New Features in Pro*C/C++

Oracle11g 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.

Oracle10g Release 2 (10.2) New Features in Pro*C/C++

A new command line option EVENTS={YES|NO} has been added to support Publish-Subscribe event notification.

There is no new Windows specific feature in Pro*C/C++ for this release.