Programmer's Guide to the Oracle7 Server Call Interface Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

Info


The Oracle Call Interface (OCI) Release 7.3 is an application programming interface (API) that allows applications written in a third generation programming language, such as C, COBOL, or FORTRAN, to issue SQL statements to one or more Oracle Servers. The OCI gives your program the capability to perform the full range of operations that are possible with Oracle Server, Release 7.3.

This Guide will give you a sound basis for developing applications using the OCI. It includes the following information:


Audience

The Programmer's Guide to the Oracle Call Interface is intended for those developing new applications or converting existing applications to run in the Oracle environment. Written especially for programmers, this comprehensive treatment of the OCI will also be valuable to systems analysts, project managers, and others interested in the development of database applications.

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.


How The Programmer's Guide to the Oracle Call Interface Is Organized

This Guide contains six chapters and eight appendices. A brief summary of what you will find in each chapter and appendix follows:

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.


Conventions Used in this Guide

The following notational and text formatting conventions are used in this Guide:

[ ]

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.


Your Comments are Welcome

Your opinions are the most important feedback we receive. Please use the reader's comment form at the back of this book to tell us what you like and dislike about this Guide. If you prefer, send us a FAX at 415-506-7200, or write to us at:




Go to previous file in sequence Go to next file in sequence
Prev Next
Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index