Copyright © 1992, 2010 Oracle Corporation.
All Rights Reserved.
| Pro*C/C++ Release Notes Release 11.2.0.2.0 E XXXXX-01 |
|
May 2010
E XXXXX-01
This file contains important information about Pro*C/C++ Version 11.2.0.2.0, which is the precompiler release corresponding to the 11.2.0.2.0 Oracle database. It contains the following topics:
This section describes compatibility issues when migrating from earlier releases of Pro*C/C++.
On platforms which support both 32 bit and 64 bit implementations, you must re-precompile your applications which include sqlca via an EXEC SQL INCLUDE statement before linking with the 64 bit binaries. For applications which include sqlca.h via the #include preprocessor statement, you must recompile to include the 64 bit sqlca.h before relinking with the 64 bit binaries.
In the future, to support generated code compatibility across implementations, only one version, the 64 bit version, of sqlca.h may be supplied on ports which support both 32 bit and 64 bit binaries.
Pro*C/C++ configuration file, viz., precomp/admin/pcscfg.cfg, may contain default options; but it is expected that the user verifies and updates "pcscfg.cfg" file before using it. From release 11g R2, even OS environment variables can be used in the configuration file; e.g., ORACLE_HOME can be referred to as $ORACLE_HOME on Unix platforms and as %ORACLE_HOME% on Windows platforms. For an illustration, on RHEL 4 with gcc version 4.1.2, the environment variable ORACLE_HOME can be used as follows in the configuration file:
sys_include=($ORACLE_HOME/precomp/public,/usr/include,/usr/lib/gcc/i386-redhat-linux/4.1.2/include)
include=($ORACLE_HOME/precomp/public,$ORACLE_HOME/precomp/hdrs)
Setting the LTYPE=SHORT option causes .lis files to be
generated using the verbose form rather than the expository form in
which the entire program is listed.
This section briefly describes new features introduced in Pro*C/C++ Release 11.2
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.
The new WITH HOLD clause in the DECLARE CURSOR statement specifies a held cursor that remains open after COMMIT.
This section lists new features introduced to Pro*C/C++ in previous releases.
SQL99 syntax support: Pro*C/C++ now supports SQL99 syntax for SELECT, INSERT, DELETE, and UPDATE statements and the body of the cursor in a DECLARE CURSOR statement.
Additional array INSERT and array SELECT syntax support: Pro*C/C++ now supports the array INSERT and array SELECT syntax of the DB2 precompiler.
Implicit buffered insert: Pro*C/C++ now supports the implicit buffering of a single INSERT statement executed in a loop.
Dynamic SQL statement cache: Statement caching improves the performance of dynamic SQL statements.
Fix execution plan: To ensure better performance of a Pro*C/C++ application during deployment, the 'outline' feature of the database is used to fix the execution plan.
The following section lists known bugs in Pro*C/C++. Numbers in parentheses following the description refer to bug numbers in the Oracle Bug Database.
Hints in EXPLAIN PLAN disappear after precompile (1466269)
Backslashes in split statements are not escaped properly (1323304)
SQLCHECK=FULL doesn't detect invalid columns in an UPDATE WHERE CURRENT OF statement (658837)
The following section lists bugs fixed in Pro*C/C++. Numbers in parentheses following the description refer to bug numbers in the Oracle Bug Database.
Pro*C/C++ now supports client result cache with static EXEC SQL statements (8766161)
Pro*C/C++ now accepts suffix 'D' and 'd' for numeric double constants (8551402)
Pro*C/C++ now correctly parses the backslash ('\') character in macro definitions (#defines) (8539668)
Pro*C/C++ now supports header files with absolute file-paths up to the maximum length of a file-path supported by the OS on which Pro*C/C++ is running (8308077)
Pro*C/C++ no longer generates a corrupted output file name when output file path is greater that 128. Pro*C/C++ now supports output file paths up to the the length supported by the OS on which Pro*C/C++ is running (8263988)
Pro*C/C++ no longer flags a syntax error for the use of “CREATE SCHEMA … “ in EXEC SQL … statement (7644340)
Pro*C/C++ no longer flags a syntax error for the use of “CREATE TABLE … “ in EXEC SQL … statement (7644376)
Pro*C/C++ no longer flags a syntax error for the use of “CREATE VIEW … “ in EXEC SQL … statement (7644400)
Pro*C/C++ no longer flags a syntax error for the use of “CREATE VIWE … WITH CHECK OPTION” in EXEC SQL … statement (7644435)
In a Pro*C/C++ application, a CHARZ variable now retains blank padding after an earlier dynamic fetch of CLOB (7462575)
Pro*C/C++ now correctly binds character strings when you bind a char buffer with a null value in a SQL statement and then use the same buffer to bind a non-null char string. Pro*C/C++ no longer fails to update the length of the buffer bound again, and no longer assumes a null string being bound – correct rows are now retrieved from the table (7395839)
After upgrading from earlier releases to 11.1, Pro*C/C++ applications no longer crash because the bind list is freed while there is an attempt to reuse it (7308054)
Pro*C no longer throws error PCC-2014 on some platforms when it encounters diagnostic directive #WARNING during precompilation (7252878, 6669407, 6154596)
Pro*C/C++ no longer searches for header files in include directories when the absolute path is provided if Pro*C/C++ fails to open the file directly, and no longer reports error PCC-S-02016 - include file pathname is too long (7231977)
On Linux x86-64, Pro*C/C++ no longer hangs when the host variable in SELECT INTO was od type pid_t (7018967)
Semantic analysis no longer fails at precompile time when connected to TimesTen (6964328)
Pro*C/C++ no longer appends an extra ‘+’ sign to a SQL hint in the generated C code (6432583)
Pro*C/C++ configuration file, pcscfg.cfg, now has a valid path for the sys_include entry. Environment variables in command-line options are now supported (5690971)
Pro*C/C++ applications can be executed in the Instant Client
(IC) environment by downloading basic.zip from the Oracle Technology
Network. To develop Pro*C/C++ applications in IC mode, you need to
install the required files using the Instant Client install option from
the media using the Oracle Universal Installer (OUI) (5248663)
For Pro*C/C++ support, please contact your local Oracle Support Services Center.
Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Copyright © 1992, 2010 Oracle Corporation.
All Rights Reserved.
|
|
Copyright © 1992, 2010 Oracle Corporation. All Rights Reserved. |
|