Pro*FORTRAN Supplement to the Oracle Precompilers Guide Release 1.8 Part Number A42523-1 |
|
|
View PDF |
This companion book to the Programmer's Guide to the Oracle Precompilers shows you how to write FORTRAN programs that use the powerful database language SQL to access and manipulate Oracle data. It provides easy-to-follow examples, instructions, and programming tips, as well as several full-length programs to better your understanding and demonstrate the usefulness of embedded SQL.
This manual shows you how the Oracle Pro*FORTRAN Precompiler and embedded SQL can benefit your entire applications development process. It gives you the know-how to design and develop applications that harness the power of Oracle, and, as quickly as possible, it helps you become proficient in writing embedded SQL programs.
An important feature of this manual is its emphasis on getting the most out of Pro*FORTRAN and embedded SQL. To help you master these tools, this manual, accompanied by the Programmer's Guide to the Oracle Precompilers, shows you all the "tricks of the trade" including ways to improve program performance.
Note: You will not find installation instructions or system-specific information in this guide. For that kind of information, you should refer to your Oracle system-specific documentation.
Anyone developing new FORTRAN applications or converting existing FORTRAN applications to run in the Oracle environment will benefit from reading this manual. Written especially for programmers, it will also be of value to systems analysts, project managers, and others interested in embedded SQL applications.
To use this manual effectively, you need a working knowledge of the following subjects:
Release 1.8 of the Pro*FORTRAN Precompiler introduces a new command-line option, UNSAFE_NULL. With UNSAFE_NULL=YES, you can disable ORA-01405 messages when precompiling applications that fetch data into host variables that do not have associated indicator variables.
For more information, see Appendix A of the Programmer's Guide to the Oracle Precompilers.
This manual contains four chapters and one appendix. A brief summary of what you will find in each chapter and appendix follows:
Important terms being defined for the first time are italicized. In discussions, UPPERCASE is used for FORTRAN code, database objects, SQL keywords, and the names of variables, constants, and arguments.
The following notational conventions are used in some code examples:
Symbol | Meaning |
---|---|
< > | Angle brackets enclose the name of a syntactic element. |
[ ] | Square brackets enclose optional items. |
{ } | Braces enclose items only one of which is required. |
| | A vertical bar separates options within brackets or braces. |
... | An ellipsis shows that the preceding argument or parameter can be repeated, or that statements or clauses irrelevant to the discussion were left out. |
# | This character is used in text to represent blank spaces when referring to the content of a database column. |
The Oracle Corporation technical staff values your comments. As we write and revise, your opinions are the most important input we receive. Please use the Reader's Comment Form at the back of this manual to tell us what you like and dislike about this Oracle publication. If the form has been used or you want to contact us, please use the following address or FAX number:
Languages Documentation Manager
Oracle Corporation
500 Oracle Parkway
Redwood Shores, CA 94065
Fax: (415) 506-7200