Embedded SQL Syntax
File Length
File Naming
Restrictions
FORTRAN Versions
Host Variable Names
1 – 4 Pro*FORTRAN Supplement to the Oracle Precompilers Guide
To use a SQL statement in your host program, precede the SQL
statement with the EXEC SQL clause. Embedded SQL syntax is
described in the Oracle7 Server SQL Reference. The precompiler
translates all EXEC SQL statements into calls to the runtime library
SQLLIB.
The Pro*FORTRAN Precompiler cannot process arbitrarily long source
files. Some of the variables used internally limit the size of the
generated file. There is no absolute limit to the number of lines
allowed, but the following aspects of the source file are contributing
factors to the file–size constraint:
• complexity of the embedded SQL statements (for example, the
number of bind and define variables)
• whether a database name is used (for example, connecting to a
database with an AT clause)
• number of embedded SQL statements
To prevent problems related to this limitation, use multiple program
units to sufficiently reduce the size of the source files.
Avoid using filenames starting with “sql,” because errors might occur.
For example, if you name a file SQLERROR.PFO, name conflicts are
returned by some linkers because there will be an array named
SQLERD and a common block named SQLERD.
The Pro*FORTRAN Precompiler supports the standard implementation
of FORTRAN for your operating system (usually FORTRAN 77). For
more information, see your Oracle system–specific documentation.
Host variable names must consist only of letters and digits, and must
begin with a letter. They can be any length, but only the first 31
characters are significant. Some compilers prohibit variable names
longer than six characters, or ignore characters after the sixth. Check
your FORTRAN compiler user’s guide.
剩余166页未读，继续阅读
