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