Oracle7 Administrator's Reference for UNIX
Overview of Oracle Precompilers
The Oracle precompilers are tools for application designers to combine SQL statements from an Oracle database with programs written in a high-level language. Oracle precompilers are compatible with ANSI SQL and are used to develop open, customized applications that run with the Oracle7 Server, or any other ANSI SQL DBMS.
To determine which Oracle precompilers can be used with a given Oracle7 release, use the following table:
| Oracle Server
| Precompiler Release
|
| Release 6.0.36 and later
| Release 1.4
|
| Release 7.0.12 and later
| Release 1.5
|
| Release 7.1 and later
| Release 1.6
|
| Release 7.2.2 and later
| Release 1.7
|
| Release 7.1.3 and later
| Release 2.0 (Pro*C only)
|
| Release 7.2.2 and later
| Release 2.1 (Pro*C only)
|
| Release 7.3.2
| Release 2.2 (Pro*C only)
|
Table 8 - 1. Oracle Precompiler Release Compatibility
Attention: Not all languages are supported on UNIX platforms. For precompiler information see the Oracle7 Installation Guide for your platform.
Issues Common to All Precompilers
The following information applies to precompilers.
Linking Problems and SQL*Net Driver Libraries
If a sample program does not link properly because of unresolved symbols in osnttt, osndnt, or osnasy, either the SQL*Net drivers have not been installed or the SQL*Net libraries are missing from the makefile. To correct the problem, install the missing drivers or libraries, or put references to the SQL*Net driver libraries in the prolanguage.mk file. The references must go in the link line after the libsqlnet.a entry.
Uppercase to Lowercase Conversion
In languages other than C, your compiler converts an uppercase function or subprogram name to lowercase. This can cause "No such user exit" errors. In this case, verify that the function or subprogram name in your option file matches the case in the iapxtb table.
Vendor Debugger Programs
Precompilers and vendor-supplied debuggers may be incompatible. Oracle Corporation does not guarantee that a program run under a debugger will run the same way under an operating system.
Selection of Nulls
If you precompile with the default values of dbms=V7 and mode=oracle, the SELECT or FETCH of a null value into a host variable without an indicator variable, generates an ORA-01405 error message.
Value of ireclen and oreclen
The ireclen and oreclen parameters do not have maximum values.
Building Demonstration Programs
All Oracle precompilers come with demonstration programs. To build these programs in the $ORACLE_HOME/precompiler/lib/demo directory, use the make command and the precompiler.mk file.
Supplemental Documentation
See Also: The following documents for more information on precompiler and interface features:
- Programmer's Guide to the Pro*Ada Precompiler
- Programmer's Guide to the Pro*C/C++ Precompiler
- Pro*COBOL Supplement to the Oracle Precompilers
- Pro*FORTRAN Supplement to the Oracle Precompilers
- Programmer's Guide to the Oracle7 Server Call Interface
- Programmer's Guide to the Oracle Precompilers
- SQL*Module User's Guide and Reference