Master Note for Precompilers, OCI and OCCI

Master Note for Precompilers, OCI & OCCI - Note:1129588.1

 

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.2 - Release: 9.2 to 11.2
Information in this document applies to any platform.

Purpose

This is the Master Note for Precompilers, OCI and OCCI.

Scope and Application

This document is informational and intended for any user.

Master Note for Precompilers, OCI and OCCI

FAQ (Precompilers)

Note 271406.1 OCI/OCCI/Precompilers Testcase FAQ
Note 47782.1 Precompilers - Frequently Asked Questions
Note 283146.1 Precompilers and the Unified SQL Parser
Note 338686.1 Precompiler FAQ's in 10gR1 (10.1.0.x) and 10gR2 (10.2.0.x)
Note 365463.1 How To Install the precompilers on Oracle 10.2?
Note 377161.1 Precompiler FAQ's About Migration / Upgrade
Note 467931.1 Precompiler FAQ's in 11gR1 (11.1.0.x)
Note 602936.1 Howto Customize Pro*C and Pro*Cobol Makefiles demo_proc.mk And demo_procob.mk On Linux/Unix
Note 759702.1 FAQ: Cause and Avoidance of ORA-1013 with ODBC, OLEDB, ODP.NET, JDBC, OCI and OCCI - including 3rd Party Products
Note 1072106.1 Precompiler FAQ's in 11gR2 (11.2.0.1)
Note 1074852.1 Does a Pro*C Application Need to be Rebuilt When Migrating From 10g to 11g?

FAQ (OCI)

Note 271406.1 OCI/OCCI/Precompilers Testcase FAQ
Note 301983.1 Which OCI Functions Where Introduced In What Release Starting With ORACLE RDBMS 8.0
Note 739169.1 Oracle Client API's that can be used to access an Oracle database.
Note 185738.1 Things to consider when trying to calculate prefetch count.
Note 370091.1 How To Use OCIAttrGet To Identify OCI_ATTR_CHARSET_ID And OCI_ATTR_CHARSET_FORM

How To (Pro*Cobol)

Note 70245.1 How to Handle COBOL 114 Errors
Note 119543.1 How to Call Pro*COBOL Routines From Pro*C
Note 69235.1 Pro*COBOL Example: Using Array Processing

How To (Pro*C)

Note 415245.1 How To Make A PRO*C Application TAF/RAC Aware
Note 33564.1 Ext/Pub  Example Pro*C Program: Inserting Long Raws
Note 33565.1 Ext/Pub  Example Pro*C Program: Fetching Long Raws

How To (OCI)

Note 726768.1 How To Set The UTF8 Characterset Via OCIEnvNlsCreate ?
Note 112676.1 How to Describe a Strongly Typed Ref CURSOR
Note 124709.1 How to use OCI8 to Insert/Update/Fetch a BLOB
Note 124732.1 How to Insert into a Table using OCI8
Note 139627.1 How to check the status of a server handle in OCI8
Note 139721.1 How to SELECT from a table which has a VARRAY as a field
Note 204310.1 How To Use Indicator Variable In An OCI Program
Note 273604.1 How to Return a Weakly Typed CURSOR as an OUT Parameter Using OCI
Note 560957.1 How To Call A Stored Procedure From OCI That Returns More Than One Ref Cursor

How To (OCCI)

Note 566643.1 Using OCIBreak() Inside OCCI To Terminate Long-running Statements
Note 602377.1 How to Insert and Select Data with OCCI That is Binary (Long Raw or Blob) Using Streams
Note 787752.1 How can we increase performance for OCCI DML operations by reducing server round trips
Note 308592.1 OCCI Sample With Nested Table Of OBJECTs As OUT Parameter
Note 602544.1 How to Insert and Select Timestamp Data in an OCCI Application?

Debugging and Tracing

Note 216912.1 How to Perform Client-Side Tracing of Programmatic Interfaces on Windows Platforms

Installation, Certification and Configuration

Note 43208.1 Certified Compilers
Note 207303.1 Client / Server / Interoperability Support Between Different Oracle Versions
Note 549826.1 How To Determine The C/C++ And COBOL Compiler Version on Unix/Linux
Note 565000.1 What API's, Drivers, Providers and Services Are Supported To Be Used With Instant Client ?
Note 1120505.1 Where To Obtain The Demo Files And Make Files For 11.2?

Known Problems

Note 400831.1 Bugs, Fixed Versions and Workarounds in OCI 9.X
Note 556831.1 Bugs, Fixed Versions and Workarounds in OCI 10.X
Note 270224.1 Bugs, Fixed Versions and Workarounds in OCCI 9.X
Note 557407.1 Bugs, Fixed Versions and Workarounds in OCCI 10.X
Note 283146.1 Precompilers and the Unified SQL parser
Note 451413.1 Pro*C Build Fails With Error PCC-02014 on File /usr/include/standards.h
Note 1007395.6 Common Causes of ORA-01001
Note 780553.1 Existing OCI And Precompiler Applications Failing in Oracle 11g
Note 604109.1 PCC-S-02201 When Trying To Compile Pro*C Program
Note 1061399.1 Pro*COBOL Application Inserts Null Into Table Instead of Valid Variable Values
Note 400973.1 Connecting Using a Pro*C Client Without ORACLE_HOME set Fails With a Segmentation Fault (SIGSEGV)
Note 1012030.6 What Needs to be Done in Pro*C Program After Issuing a FORK 

New Features

Note 864736.1 11gR2 NEW FEATURE OCI Client Result Cache - Table annotations support
Note 942367.1 What v$ table tracks usage of the new Result Cache feature In 11g
Note 363381.1 How to Retrieve Oracle OCI Client Version Using OCIClientVersion
Note 465826.1 11g OCI: Client Session NLS Character Set Status Information
Note 864112.1 11gR2 NEW FEATURE : OCI Support for 8-Byte Integer
Note 465838.1 11g Precompilers: Implicit Buffered Insert In Pro*C/C++
Note 465852.1 11g Precompilers: Implicit Buffered Insert In Pro*COBOL
Note 864721.1 11gR2 NEW FEATURE : PRO*COBOL Support for 8-Byte Integer
Note 433436.1 11g Precompilers: SQL99 Syntax Support By Pro*COBOL
Note 246784.1 Native Floats and Doubles With Dynamic Methods 1,2 and 3

Upgrade

Note 455832.1 Core dump - Access Violation in Client Applications After Upgrade to 9.2.0.8, 10.1.0.5 , 10.2.0.x 11.1 and the client or server is still a prior version
Note 445296.1 How to Relink 32bit Pro*COBOL Precompiler Executables in 10g and Later
Note 432770.1 "ld: Mismatched ABI (not an ELF file) for .o"
Note 298293.1 Could not Find the Precompiler After Installation
Note 553578.1 0711-736 Error: Input File /lib/crt0_64.o, XCOFF64 object files are not allowed in 32-bit mode

Miscellaneous articles

Note 242993.1 opatch FAQ
Note 249212.1 VMWARE & ORACLE
Note 748908.1 Howto Determine Linux Version / Kernel / Banner


Show Related Information Related


Products

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.2 - Release: 9.2 to 11.2
Information in this document applies to any platform.

Purpose

This is the Master Note for Precompilers, OCI and OCCI.

Scope and Application

This document is informational and intended for any user.

Master Note for Precompilers, OCI and OCCI

FAQ (Precompilers)

Note 271406.1 OCI/OCCI/Precompilers Testcase FAQ
Note 47782.1 Precompilers - Frequently Asked Questions
Note 283146.1 Precompilers and the Unified SQL Parser
Note 338686.1 Precompiler FAQ's in 10gR1 (10.1.0.x) and 10gR2 (10.2.0.x)
Note 365463.1 How To Install the precompilers on Oracle 10.2?
Note 377161.1 Precompiler FAQ's About Migration / Upgrade
Note 467931.1 Precompiler FAQ's in 11gR1 (11.1.0.x)
Note 602936.1 Howto Customize Pro*C and Pro*Cobol Makefiles demo_proc.mk And demo_procob.mk On Linux/Unix
Note 759702.1 FAQ: Cause and Avoidance of ORA-1013 with ODBC, OLEDB, ODP.NET, JDBC, OCI and OCCI - including 3rd Party Products
Note 1072106.1 Precompiler FAQ's in 11gR2 (11.2.0.1)
Note 1074852.1 Does a Pro*C Application Need to be Rebuilt When Migrating From 10g to 11g?

FAQ (OCI)

Note 271406.1 OCI/OCCI/Precompilers Testcase FAQ
Note 301983.1 Which OCI Functions Where Introduced In What Release Starting With ORACLE RDBMS 8.0
Note 739169.1 Oracle Client API's that can be used to access an Oracle database.
Note 185738.1 Things to consider when trying to calculate prefetch count.
Note 370091.1 How To Use OCIAttrGet To Identify OCI_ATTR_CHARSET_ID And OCI_ATTR_CHARSET_FORM

How To (Pro*Cobol)

Note 70245.1 How to Handle COBOL 114 Errors
Note 119543.1 How to Call Pro*COBOL Routines From Pro*C
Note 69235.1 Pro*COBOL Example: Using Array Processing

How To (Pro*C)

Note 415245.1 How To Make A PRO*C Application TAF/RAC Aware
Note 33564.1 Ext/Pub  Example Pro*C Program: Inserting Long Raws
Note 33565.1 Ext/Pub  Example Pro*C Program: Fetching Long Raws

How To (OCI)

Note 726768.1 How To Set The UTF8 Characterset Via OCIEnvNlsCreate ?
Note 112676.1 How to Describe a Strongly Typed Ref CURSOR
Note 124709.1 How to use OCI8 to Insert/Update/Fetch a BLOB
Note 124732.1 How to Insert into a Table using OCI8
Note 139627.1 How to check the status of a server handle in OCI8
Note 139721.1 How to SELECT from a table which has a VARRAY as a field
Note 204310.1 How To Use Indicator Variable In An OCI Program
Note 273604.1 How to Return a Weakly Typed CURSOR as an OUT Parameter Using OCI
Note 560957.1 How To Call A Stored Procedure From OCI That Returns More Than One Ref Cursor

How To (OCCI)

Note 566643.1 Using OCIBreak() Inside OCCI To Terminate Long-running Statements
Note 602377.1 How to Insert and Select Data with OCCI That is Binary (Long Raw or Blob) Using Streams
Note 787752.1 How can we increase performance for OCCI DML operations by reducing server round trips
Note 308592.1 OCCI Sample With Nested Table Of OBJECTs As OUT Parameter
Note 602544.1 How to Insert and Select Timestamp Data in an OCCI Application?

Debugging and Tracing

Note 216912.1 How to Perform Client-Side Tracing of Programmatic Interfaces on Windows Platforms

Installation, Certification and Configuration

Note 43208.1 Certified Compilers
Note 207303.1 Client / Server / Interoperability Support Between Different Oracle Versions
Note 549826.1 How To Determine The C/C++ And COBOL Compiler Version on Unix/Linux
Note 565000.1 What API's, Drivers, Providers and Services Are Supported To Be Used With Instant Client ?
Note 1120505.1 Where To Obtain The Demo Files And Make Files For 11.2?

Known Problems

Note 400831.1 Bugs, Fixed Versions and Workarounds in OCI 9.X
Note 556831.1 Bugs, Fixed Versions and Workarounds in OCI 10.X
Note 270224.1 Bugs, Fixed Versions and Workarounds in OCCI 9.X
Note 557407.1 Bugs, Fixed Versions and Workarounds in OCCI 10.X
Note 283146.1 Precompilers and the Unified SQL parser
Note 451413.1 Pro*C Build Fails With Error PCC-02014 on File /usr/include/standards.h
Note 1007395.6 Common Causes of ORA-01001
Note 780553.1 Existing OCI And Precompiler Applications Failing in Oracle 11g
Note 604109.1 PCC-S-02201 When Trying To Compile Pro*C Program
Note 1061399.1 Pro*COBOL Application Inserts Null Into Table Instead of Valid Variable Values
Note 400973.1 Connecting Using a Pro*C Client Without ORACLE_HOME set Fails With a Segmentation Fault (SIGSEGV)
Note 1012030.6 What Needs to be Done in Pro*C Program After Issuing a FORK 

New Features

Note 864736.1 11gR2 NEW FEATURE OCI Client Result Cache - Table annotations support
Note 942367.1 What v$ table tracks usage of the new Result Cache feature In 11g
Note 363381.1 How to Retrieve Oracle OCI Client Version Using OCIClientVersion
Note 465826.1 11g OCI: Client Session NLS Character Set Status Information
Note 864112.1 11gR2 NEW FEATURE : OCI Support for 8-Byte Integer
Note 465838.1 11g Precompilers: Implicit Buffered Insert In Pro*C/C++
Note 465852.1 11g Precompilers: Implicit Buffered Insert In Pro*COBOL
Note 864721.1 11gR2 NEW FEATURE : PRO*COBOL Support for 8-Byte Integer
Note 433436.1 11g Precompilers: SQL99 Syntax Support By Pro*COBOL
Note 246784.1 Native Floats and Doubles With Dynamic Methods 1,2 and 3

Upgrade

Note 455832.1 Core dump - Access Violation in Client Applications After Upgrade to 9.2.0.8, 10.1.0.5 , 10.2.0.x 11.1 and the client or server is still a prior version
Note 445296.1 How to Relink 32bit Pro*COBOL Precompiler Executables in 10g and Later
Note 432770.1 "ld: Mismatched ABI (not an ELF file) for .o"
Note 298293.1 Could not Find the Precompiler After Installation
Note 553578.1 0711-736 Error: Input File /lib/crt0_64.o, XCOFF64 object files are not allowed in 32-bit mode

Miscellaneous articles

Note 242993.1 opatch FAQ
Note 249212.1 VMWARE & ORACLE
Note 748908.1 Howto Determine Linux Version / Kernel / Banner


Show Related Information Related


Products
  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
Errors
ORA-1001; ORA-1013; 114 ERROR; 736 ERROR

  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
Errors
ORA-1001; ORA-1013; 114 ERROR; 736 ERROR

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

News and Troubleshooting tips for Oracle Database and Enterprise Manager

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today