Already a member?
Sign in
Embedded SQL Precompilers
An Embedded SQL Precompiler is a development tool which enables developers to embed SQL statements within the source code of a high-level host program written in C, C++, COBOL, FORTRAN, or PL/1. When the source code is passed through the precompiler, all embedded SQL statements are translated into Oracle runtime library calls which can then be compiled using a standard compiler.
Oracle supports precompilers for embedding SQL in the following languages:
In addition the the precompilers, Oracle provides SQL*Module for Ada; a library for Ada developers which builds parameterized procedures that encapsulate SQL statements.
On several mailing lists and forums, many people think that the Oracle Precompilers generate code for OCI; an inaccurate statement. Instead, the Oracle Precompilers translate embedded SQL into calls to the SQL Library (SQLLIB).
Precompiler Host Language Support
Oracle supports precompilers for embedding SQL in the following languages:
| Language | Precompiler Name |
| C/C++ | Pro*C |
| COBOL | Pro*COBOL |
| FORTRAN | Pro*FORTRAN |
| PL/I | Pro*PL/1 |
In addition the the precompilers, Oracle provides SQL*Module for Ada; a library for Ada developers which builds parameterized procedures that encapsulate SQL statements.
Precompiler Misconceptions
On several mailing lists and forums, many people think that the Oracle Precompilers generate code for OCI; an inaccurate statement. Instead, the Oracle Precompilers translate embedded SQL into calls to the SQL Library (SQLLIB).
Latest page update: made by jonah.harris
, Nov 27 2007, 7:33 AM EST
(about this update
About This Update
Added borders to the table.
- jonah.harris
view changes
- complete history)
view changes
- complete history)
Keyword tags:
c
cobol
embedded sql
precompiler
pro*c
pro*cobol
pro*fortran
pro*pl/1
sql
More Info: links to this page

