Programmer's Guide to the Oracle7 Server Call Interface

Library

Product

Contents

Index

@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

@

• Ada
• Ada OCI, not covered in this guide
• address parameters
  • in COBOL
  • in FORTRAN
• application server
  • connection
  • developing using the OCIs
• array, standard, use of skip parameter
• array
  • maximum size
  • query example
  • restrictions when using PL/SQL
• arrays of structures
  • determining skip parameter
  • fetch code example
  • indicator variables
  • insert code example
  • skip parameter
  • using OBINDPS and ODEFINPS
• bind operation
  • for piecewise operations
• bind operations, for arrays of structures
• blank-padded strings
• blocking mode
• C header files, listing of
• C++, sample program
• C/C++
• canceling an OCI call, using OBREAK
• canceling OCI call, using the operating system interrupt
• CDA
• cdemo1.c, listing of
• cdemo2.c, listing of
• cdemo3.c, listing of
• cdemo4.c, listing of
• cdemo5.c, listing of
• cdemo6.cc, listing of
• cdemo6.h, listing of
• CHAR datatype
  • converting to numeric
  • external
  • internal
• character strings
  • as special parameter
  • in COBOL
  • length parameter for
  • null-terminated
  • passed as literal
• CHARZ datatype, external
• COBOL
• coding rules
• compiler optimization, avoiding problems
• compiling [2]
• connections, multiple
• control statements
• conventions used in this guide
• cursor
• cursor data area
  • description
  • fields in
  • flags field
  • internal ROWID field [2]
  • length of fields varies
  • OCI function code field
  • OSD error code field
  • parse error offset field
  • return code field
  • rows processed count
  • size varies
  • SQL function code field
  • system dependencies
  • V2 return code field
• cursor variable
• CURSOR VARIABLE datatype, external
• cursor variables, sample program
• cursors
  • closing
  • opening
• data conversion table
• data definition language, executed when parsed [2] [3] [4] [5] [6] [7]
  • statements [2]
• data manipulation language
  • statements [2]
• data structures
  • defining
  • system dependencies
• datatype codes
  • external
  • internal [2]
• DATE datatype
  • external
  • internal
• DDL
• deferred
  • mode linking
  • parse
  • statement execution [2]
• DEFFLG parameter
  • of OPARSE [2] [3] [4] [5] [6] [7]
• define operation
  • for arrays of structures
  • for piecewise operations
• developing an OCI program
• DISPLAY datatype, external
• distributed transaction processing [2]
• DML
• DTP
• embedded SQL statements, not used in the OCI
• external datatype code
• external datatype
  • CHAR
  • CHARZ
  • CURSOR VARIABLE
  • DATE
  • DISPLAY
  • FLOAT
  • INTEGER
  • LONG
  • LONG RAW
  • LONG VARCHAR
  • LONG VARRAW
  • MLSLABEL
  • NUMBER
  • PACKED DECIMAL
  • RAW
  • ROWID
  • STRING
  • UNSIGNED
  • VARCHAR
  • VARCHAR2
  • VARNUM
  • VARRAW
• flags field, in cursor data area
• FLOAT datatype, external
• FORTRAN
• graphical user interface
• GUI
• HDA [2]
• host data area [2]
  • and OLOG call
  • description
  • initialization
• indicator parameter
• indicator variable
  • assigning value to
  • definition
  • interpreting value of
  • used to insert null into database
  • using to detect null
  • using to detect truncated value
  • with arrays of structures
• input variables
  • binding address
  • placeholders
• INTEGER datatype, external
• integer parameters
  • in C
  • in COBOL
  • in FORTRAN
• integer, use of literal as a placeholder in OBNDRN
• internal datatype code
• internal datatype
  • CHAR
  • DATE
  • LONG
  • LONG RAW
  • MLSLABEL
  • NUMBER
  • RAW
  • ROWID
  • VARCHAR2
• Julian date
• keywords
• LDA
• length parameter
• linking [2]
  • deferred mode
  • non-deferred mode
  • system dependencies
• literal character strings
• literal, as parameter
• logon data area
  • and OLOG call
  • defining
  • description
  • establishing connections with
  • system dependencies
• LONG column, maximum width of
• LONG datatype
  • compared with CHAR
  • external
  • internal
• LONG RAW datatype
  • external
  • internal
• LONG VARCHAR datatype, external
• LONG VARRAW datatype, external
• MLSLABEL datatype
  • external
  • internal
• mode
  • non-blocking
  • of a parameter, in C
  • of a parameter, in COBOL
  • of a parameter, in FORTRAN
• multi-threaded applications
  • multiple connection example
  • must use olog()
  • programming in OCI
  • single connection example
  • three-tier architectures
  • typical uses
• multi-threaded development
  • basic concepts
  • code example [2]
  • managing database access
  • managing multiple threads
  • serial access to connection
  • single versus multiple connections
  • using OLOGOF
  • using OPINIT call
• multibyte character strings, and piecewise operations
• namespaces, reserved by Oracle
• national language support
• NLS
• non-blank-padded strings
• non-blocking mode [2]
• non-deferred mode linking
• non-deferred parsing
• null
  • ANSI requirement
  • detecting
  • inserting into database column
  • using RCODE to detect when fetched
  • when fetched from database
• NUMBER datatype
  • external
  • internal
• OBINDPS
  • C description
  • COBOL description
  • FORTRAN description
  • optimizing compilers
  • supported in deferred mode
• OBNDRA
  • C description
  • COBOL description
  • FORTRAN description
  • optimizing compilers
• OBNDRN
  • C description
  • COBOL description
  • FORTRAN description
  • optimizing compilers
• OBNDRV
  • C description
  • COBOL description
  • FORTRAN description
  • optimizing compilers
• OBREAK
  • C description
  • canceling an OCI call
  • COBOL description
  • FORTRAN description
• OCAN
  • C description
  • COBOL description
  • FORTRAN description
• OCI calls
  • obsolescent
  • obsolete
• OCI data structures
  • defining
• OCI function code
• ociapr.h, listing of
• OCI, definition
• ocidem.h, listing of
• ocidfn.h, listing of
• ocikpr.h, listing of
• OCI, program structure
• OCLOSE
  • C description
  • COBOL description
  • FORTRAN description
• OCOF
  • C description
  • COBOL description
  • FORTRAN description
• OCOM
  • C description
  • COBOL description
  • FORTRAN description
• OCON
  • C description
  • COBOL description
  • FORTRAN description
• ODEFIN
  • C description
  • COBOL description
  • defining select-list items
  • FORTRAN description
  • not used for PL/SQL block
  • optimizing compilers
• ODEFINPS
  • C description
  • COBOL description
  • defining select-list items
  • FORTRAN description
  • not used for PL/SQL block
  • optimizing compilers
  • supported in deferred mode
• ODESCR
  • C description
  • COBOL description
  • defining select-list items
  • FORTRAN description
• ODESSP
  • C description
  • COBOL description
  • FORTRAN description
• ODSC
  • C description
  • COBOL description
  • FORTRAN description
  • replace with ODESCR [2] [3]
• OERHMS
  • C description
  • COBOL description
  • FORTRAN description
• OERMSG
  • C description
  • COBOL description
  • FORTRAN description
  • replace with OERHMS [2] [3]
• OEXEC
  • C description
  • COBOL description
  • fetching a single row
  • FORTRAN description
• OEXFET
  • C description
  • COBOL description
  • fetching rows
  • FORTRAN description
• OEXN
  • C description
  • COBOL description
  • FORTRAN description
• OFEN
  • C description
  • COBOL description
  • fetching a single row
  • FORTRAN description
• OFETCH
  • C description
  • COBOL description
  • fetching a single row
  • FORTRAN description
• OFLNG
  • C description
  • COBOL description
  • FORTRAN description
• OGETPI
  • C description
  • COBOL description
  • FORTRAN description
• OLOG
  • and multi-threaded applications
  • C description
  • COBOL description
  • FORTRAN description
• OLOGOF
  • C description
  • called once per connection
  • COBOL description
  • FORTRAN description
• OLOG
  • system dependencies
  • uses unique LDA and HDA
• OLON
  • C description
  • COBOL description
  • FORTRAN description
  • replace with OLOG [2] [3]
• ONAME
  • C description
  • COBOL description
  • FORTRAN description
  • replace with ODESCR [2] [3]
• ONBCLR
  • C description
  • COBOL description
  • FORTRAN description
• ONBSET
  • C description
  • COBOL description
  • FORTRAN description
• ONBTST
  • C description
  • COBOL description
  • FORTRAN description
• OOPEN
  • C description
  • COBOL description
  • FORTRAN description
• OOPT
  • C description
  • COBOL description
  • FORTRAN description
• OPARSE
  • C description
  • COBOL description
  • cursor data area
  • fetching rows
  • FORTRAN description
  • parse error offset
• operation
  • bind
  • define
• OPINIT
  • backward compatibility
  • C description
  • skipping in multi-threaded application
  • using in OCI programs
• optimizing compiler
• optional parameters
• Oracle Call Interface
  • languages supported
• Oracle Call Interfaces
• Oracle keywords
• Oracle namespaces
• Oracle reserved words
• Oracle Server
  • connecting to
  • disconnecting from
• Oracle system-specific documentation
  • data structure definitions
  • data structure definitions in C
  • data structure definitions in COBOL
  • data structure definitions in FORTRAN
  • length of ROWID
  • linking and compiling OCI applications
  • linking instructions
  • linking SQLLIB [2]
  • location of C files [2]
  • location of COBOL files
  • location of files
  • location of FORTRAN files
  • non-deferred mode linking
  • size of integers
  • SQL*Net [2]
    • in COBOL [2]
    • in FORTRAN [2]
• oratypes.h
  • header file is system specific
  • listing of
  • on-line location
• ORLON
  • C description
  • COBOL description
  • FORTRAN description
  • replace with OLOG [2] [3]
• OROL
  • C description
  • COBOL description
  • FORTRAN description
• OSD error code
• OSETPI
  • C description
  • COBOL description
  • FORTRAN description
• OSQL3
  • C description
  • COBOL description
  • FORTRAN description
  • replace with OPARSE [2] [3]
• PACKED DECIMAL datatype, external
• parameter datatypes, in C
• parameters
  • address
  • binary
  • character string
  • datatype of
  • integers not passed by value
  • optional
    • in C
    • in COBOL
    • in FORTRAN
  • passed by reference in COBOL
  • passed by reference in FORTRAN
  • passed by value in C
  • required
    • in C
    • in COBOL
    • in FORTRAN
  • short binary
  • unused
    • in C
    • in COBOL
    • in FORTRAN
• parse error offset
• parse, deferred
• pending calls
• PGA
• piecewise operations
  • and multibyte character strings
  • fetch [2]
  • fetch code example
  • insert [2]
  • insert code example
  • update
  • using in OCI programs
• PL/I
• PL/I OCI, not covered in this guide
• PL/SQL block, binding placeholders in
• PL/SQL reserved words
• PL/SQL
  • array index in piecewise operations
  • block
  • procedural language
• placeholders
  • definition
  • in PL/SQL block
• precision
• process global area
• program structure
• programming languages
  • non-procedural
  • procedural
  • third generation
• query [2]
• RAW datatype
  • external
  • internal
• RCODE parameter, used to detect null on a fetch
• relinking version 6 OCI applications
• required parameters
• reserved words
  • PL/SQL
• resource managers
• return code field
  • in CDA
  • in cursor data area
  • in LDA [2]
• return code
  • column level
  • row level
  • with arrays of structures
• ROWID [2]
• ROWID datatype
  • external
  • internal [2]
• ROWID
  • determining binary size of
  • determining size of
  • field in CDA, when not valid
  • length of field in cursor data area [2]
  • representation of
  • using in an UPDATE or DELETE
  • when valid
• rows processed count
• rows, fetching
• scale
• select-list item, definition of
• select-list items
  • defining
• session control statements
• SGA
• skip parameter
  • and arrays of structures
  • and compiler padding
  • determining
  • standard array operations
• special terms
• SQL function code
  • when to use
• SQL language
• SQL statement
  • processing
• SQL statements
  • execution of
  • parsing
• SQLLD2
  • C description
  • COBOL description
  • FORTRAN description
• SQLLDA
  • C description
  • COBOL description
  • FORTRAN description
• STRING datatype, external
• string, character string
• strings
  • blank-padded
  • non-blank-padded
• system control statements
• system global area
• thread safety
  • advantages of
  • languages supported
• threads
  • database access by multiple threads
  • definition of
  • sharing of resources by
• three-tier architectures, thread safety and
• transaction control, statements
• transaction manager
• transaction processing
• transaction
  • committing
  • rollback
• truncated value, detecting
• UNSIGNED datatype, external
• unused parameters
• V2 return code
• VARCHAR datatype, external
• VARCHAR2 datatype
  • external
  • internal
• variables, location in program of bound and defined
• VARNUM datatype, external
• VARRAW datatype, external
• version 6 OCI applications, relinking
• warning flags
• X/Open DTP applications

Copyright © 1996 Oracle Corporation. All Rights Reserved.

Library

Product

Contents

Index