Programmer's Guide to the Oracle7 Server Call Interface | ![]() Library |
![]() Product |
![]() Contents |
![]() Index |
This Guide will give you a sound basis for developing applications using the OCI. It includes the following information:
To use this Guide effectively, you need a working knowledge of applications programming in either C, COBOL, or FORTRAN, and knowledge of the SQL relational database language. This Guide describes all concepts and terminology specific to the Oracle Call Interface.
For information about SQL, refer to the Oracle7 Server SQL Reference and the Oracle7 Server Administrator's Guide. For information about basic Oracle concepts, see Oracle7 Server Concepts. For information about the Oracle Precompilers, which enable you to embed SQL commands in a 3GL application, refer to the appropriate Precompiler manual.
Chapter 1: Introduction This chapter introduces you to the Oracle Call Interfaces and describes special terms and typographical conventions that are used in describing the interfaces. It also lists new OCI routines, as well as routines that are now obsolete or obsolescent.
Chapter 2: Writing an OCI Program This chapter gives you the basic concepts that are used in developing an OCI program.
Chapter 3: Datatypes Understanding how data is converted between Oracle tables and variables in your host program is essential for using the OCI interfaces. All the information you need is in Chapter 3.
Chapter 4: The OCI Functions for C The OCI routines (functions) for C are documented in this chapter. Included are examples in C that show how they are used.
Chapter 5: The OCI Routines for COBOL The OCI routines for COBOL are documented in this chapter. Included are examples in COBOL that show how they are used.
Chapter 6: The OCI Routines for FORTRAN The OCI routines for FORTRAN are documented in this chapter. Included are examples in FORTRAN that show how they are used.
Appendix A: Sample Programs in C This appendix contains five demonstration programs that show how to use the OCI routines in C programs.
Appendix B: Sample Programs in COBOL This appendix contains three demonstration programs that show how to use the OCI routines in COBOL programs.
Appendix C: Sample Programs in FORTRAN This appendix contains three demonstration programs that show how to use the OCI routines in FORTRAN programs.
Appendix D: Additional OCI Functions (C) This appendix documents older OCI functions that are still available, but have been superseded by new routines that offer increased functionality or performance. These routines might become obsolete in future versions, so they should not be used in new OCI programs.
Appendix E: Additional OCI Functions (COBOL) This appendix documents older OCI routines that are still available, but have been superseded by new routines that offer increased functionality or performance. These routines might become obsolete in future versions, so they should not be used in new OCI programs.
Appendix F: Additional OCI Functions (FORTRAN) This appendix documents older OCI routines that are still available, but have been superseded by new routines that offer increased functionality or performance. These routines might become obsolete in future versions, so they should not be used in new OCI programs.
Appendix G: Operating System Dependencies This appendix contains a convenient list of the aspects of OCI programming that depend on the system you are using. In these cases, your Oracle system-specific documentation spells out the appropriate values or options.
Appendix H: Oracle Reserved Words, Keywords and Namespaces This appendix lists words that have a special meaning to Oracle, and namespaces reserved by Oracle products.
[ ]
Square brackets indicate that the enclosed item is optional. Do not type the brackets.
< >
Angle brackets indicate that the enclosed item is an unused parameter. Do not type the brackets.
{ }
Braces enclose items of which only one is required.
|
A vertical bar separates items within braces.
...
In code fragments, an ellipsis means that code not relevant to the discussion has been omitted.
font change
Code examples are shown in monospaced font.
italics
Italics are used for lowercase OCI parameters, C OCI routines, filenames, and data fields.
UPPERCASE
Uppercase is used for SQL keywords. OCI routine names and parameter names are also in uppercase, except in C, where lowercase italic is used.
bold
Bold face type is used to identify datatype names in descriptions of C language calls.
![]() ![]() Prev Next |
![]() Copyright © 1996 Oracle Corporation. All Rights Reserved. |
![]() Library |
![]() Product |
![]() Contents |
![]() Index |