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

• @

• aggregate name, definition
• ALLOCATE statement
• allocating cursor variables
• arrays
• automatic logons
• BEGLABEL, obsolete in 1.6 and later releases
• bind descriptor
• bind SQLDA
• C array in SQLDA
  • purpose
  • setting values
• case-sensitivity
• character host variables
  • as output variables
  • handling
  • server handling
  • types
• CLOSE statement
  • cursor variable
  • in dynamic SQL Method 4
• coding area [2]
  • for statement labels
• coding conventions
• comments
  • ANSI SQL-style
  • C-style
  • embedded SQL statements
• COMMON blocks
  • defining
  • restrictions
• COMMON statement
• COMPLEX datatype
• composite type
• concurrent logons
• CONNECT statement
  • logging on to Oracle
  • placement
  • requirements
• connecting to Oracle
  • automatically
  • concurrently
  • example
  • via SQL*Net
• constants, defining
• continuation lines, syntax [2]
• CONTINUE action (WHENEVER statement)
• Conventions, description of
• cursor cache, purpose
• cursor variables
  • advantages
  • allocating
  • closing
  • declaring
  • error conditions
  • fetching from
  • heap memory usage
  • opening
    • stored procedure
  • restrictions
  • scope
• DATA statement, initializing host variables
• datatype equivalencing, example
• datatypes
  • coercing NUMBER to VARCHAR2
  • conversions
  • dealing with Oracle internal
  • equivalencing
  • external
  • FORTRAN
  • internal
  • need to coerce
  • PL/SQL equivalents
  • used in descriptors
  • when to reset
• DECLARE CURSOR statement, in dynamic SQL Method 4
• declare section
  • allowable statements
  • defining usernames and passwords
  • FORTRAN datatypes supported
  • multiple declare sections
  • purpose
  • rules
• declaring
  • cursor variables
  • host arrays
  • host variables
  • implicit INTEGERs and REALs
  • indicator variables
  • ORACA
  • SQLCA
  • SQLDA
  • VARCHAR variables
• default
  • error handling
  • lower bound of host array
  • setting of ORACA option
• DESCRIBE BIND VARIABLES statement, in dynamic SQL Method 4
• DESCRIBE SELECT LIST statement, in dynamic SQL Method 4
• descriptors
  • bind descriptor
  • purpose
  • select descriptor
  • SQLADR subroutine
• DIMENSION statement, invalid usage
• dimensioning host arrays
• directory path, INCLUDE files
• DO action (WHENEVER statement)
• dynamic SQL Method 4
  • CLOSE statement
  • DECLARE CURSOR statement
  • DESCRIBE statement [2]
  • FETCH statement
  • FOR clause
  • host arrays
  • OPEN statement
  • PREPARE statement
  • prerequisites
  • purpose of descriptors
  • requirements
  • sample program
  • sequence of statements used with
  • SQLDA
  • steps
• embedded PL/SQL
  • host variables
  • indicator variables
  • requirements
  • VARCHAR variables
  • where allowed
• embedded SQL statements
  • associating statement labels with
  • comments
  • continuing from one line to the next [2]
  • referencing host arrays in
  • referencing host variables
  • referencing indicator variables
  • requirements
  • syntax
  • terminator
• ENDLABEL, obsolete in 1.6 and later releases
• equivalencing datatypes, description
• error conditions, cursor variable
• error handling
  • alternatives
  • default
  • using status variables
    • SQLCA [2]
    • SQLCOD [2]
    • SQLSTA [2]
• error message text, SQLGLM function
• error messages, maximum length
• error reporting
  • error message text
  • key components of
  • parse error offset
  • rows-processed count
  • status codes
  • warning flags
• EXEC SQL clause
• explicit logons, multiple
• external datatypes
  • general
  • in dynamic SQL Method 4
• F variable in SQLDA
  • purpose
  • setting value
• FETCH statement
  • cursor variable
  • in dynamic SQL Method 4
• filenames
  • extension for INCLUDE files
  • restrictions
• flags
• FOR clause, in dynamic SQL Method 4
• FORTRAN datatypes, supported by Oracle
• GOTO action (WHENEVER statement)
• heap memory, allocating cursor variables
• host arrays
  • declaring
  • dimensioning
  • in dynamic SQL Method 4
  • lower bound default
  • multidimensional
  • referencing
  • restrictions
  • restrictions on
  • support
• host variables
  • declaring
  • definition
  • initializing
  • naming [2]
  • passed to a subroutine
  • referencing
  • repeating definitions of
  • restrictions
  • scope
  • where to declare
  • with PL/SQL
• I array in SQLDA
  • purpose
  • setting values
• implicit declaration
• INCLUDE statement
  • declaring the ORACA
  • declaring the SQLCA
  • declaring the SQLDA
  • effect
  • purpose
• INCLUDEd files, with case-sensitive operating systems
• indicator arrays
  • example
  • uses for
• indicator variables
  • association with host variables
  • declaring
  • nulls
  • purpose
  • referencing
  • required size
  • truncated values
  • with PL/SQL
• internal datatypes
  • general
  • in dynamic SQL Method 4
• IS NULL operator, for testing null values
• L array in SQLDA
  • purpose
  • setting values
• LEN intrinsic function
• loggin on, automatically
• logging on, connecting to Oracle
• logical operators
• M array in SQLDA
  • purpose
  • setting values
• MAXLITERAL option [2]
• message text
• MODE option
  • effects of
  • status variables
• multidimensional arrays, invalid use of
• N variable in SQLDA
  • purpose
  • setting value
• naming
  • host variables
  • select-list items
• NOT FOUND condition (WHENEVER statement)
• Notation, rules for
• nulls
  • handling in Dynamic SQL Method 4
  • handling
  • meaning in SQL (NVL function)
  • SQLNUL subroutine
• NUMBER datatype, SQLPRC subroutine
• NVL function, for retrieving null values
• obsolete precompiler features
  • BEGLABEL statement label
  • ENDLABEL statement label
• OPEN statement, in dynamic SQL Method 4
• opening a cursor variable
• operators, logical and relational
• ORACA
  • declaring
  • enabling
  • precompiler option
  • purpose [2]
  • restrictions on
• Oracle Communications Area, ORACA
• PARAMETER statement, defining constants
• parse error offset
• password
  • defining
  • hardcoding
• PL/SQL
  • datatype equivalents
  • embedded
  • opening a cursor variable
    • stored procedure
• precision
  • definition
  • extracting with SQLPRC
  • when not specified
• precompiler options, ASSUME_SQLCODE [2]
  • MAXLITERAL [2]
  • MODE [2]
  • ORACA
  • SQLCHECK
• PREPARE statement, in dynamic SQL Method 4
• program unit
• programming guidelines
• reference cursor
• referencing
  • host variables
  • indicator variables
  • of host arrays
  • VARCHAR variables
• relational operators
• restrictions
  • cursor variables
  • host variables
    • declaring
    • naming
  • names of source files
  • VARCHAR variables
• rows-processed count
• S array in SQLDA
  • purpose
  • setting values
• sample programs
  • calling a stored procedure
  • cursor operations
  • cursor variables
    • Pro*FORTRAN source
  • datatype equivalencing
  • dynamic SQL Method 1
  • dynamic SQL Method 2
  • dynamic SQL Method 3
  • fetching in batches
  • list
  • Oracle Forms user exit
  • simple query
• scalar type
• scale
  • definition
  • extracting with SQLPRC
  • when negative
• scope
  • cursor variables
  • host variables
  • WHENEVER statement
• select descriptor
• select SQLDA, purpose of
• select-list items, naming
• SQL Descriptor Area
• SQL*Net, for concurrent logons
• SQLADR subroutine
  • example
  • parameters
  • storing buffer addresses
  • syntax
• SQLCA status variable
  • data structure
  • declaring
  • effect of MODE option
  • explicit versus implicit checking
  • purpose
  • restrictions
• SQLCHECK option
• SQLCOD status variable
  • ASSUME_SQLCODE option
  • declaring
  • description
  • effect of MODE option
  • SQL92 deprecated feature
  • usage
• SQLDA
  • C array
  • declaring
  • example
  • F variable
  • I array
  • L array
  • M array
  • N variable
  • purpose
  • S array
  • SQLADR subroutine
  • structure
  • T array
  • V array
  • X array
  • Y array
  • Z array
• SQLEMC variable
• SQLERD(3) variable
• SQLERROR condition (WHENEVER statement)
• SQLGLM function
  • example
  • parameters
  • purpose
  • syntax
• SQLNUL subroutine
  • arguments
  • example
  • purpose
  • syntax
  • with T variable
• SQLPR2 subroutine
• SQLPRC subroutine
  • arguments
  • purpose
  • syntax
  • usage example
• SQLSTA status variable
  • declaring
  • effect of MODE option
  • usage
• SQLWARNING condition (WHENEVER statement)
• statement labels
  • associating with SQL statements
  • BEGLABEL and ENDLABEL osolete
  • coding area for
• status codes for error reporting
• STOP action (WHENEVER statement)
• stored procedure, opening a cursor [2]
  • sample programs [2]
• string literals
  • continuing from one line to the next
  • continuing to the next line
• subroutines, declare section in
• syntax
  • continuation lines
  • embedded SQL statements
  • SQLADR subroutine
  • SQLGLM function
  • SQLNUL subroutine
  • SQLPRC subroutine
• T array in SQLDA
  • purpose
  • setting values
• terminal format [2]
• terminator for embedded SQL statements
• truncated values, indicator variables
• Trusted Oracle7
• username
  • defining
  • hardcoding
• V array in SQLDA
  • purpose
  • setting values
• VAR statement, syntax
• VARCHAR variables
  • advantages
  • as input variables
  • as output variables
  • declaring
  • length variable
  • maximum length
  • referencing
  • restrictions
  • server handling [2]
  • string variable
  • structure
  • versus fixed-length strings
  • with PL/SQL
• warning flags for error reporting
• WHENEVER statement
  • CONTINUE action
  • DO action
  • example
  • GOTO action
  • maintaining addressability for
  • NOT FOUND condition
  • purpose
  • scope
  • SQLERROR condition
  • SQLWARNING condition
  • STOP action
  • syntax
• X array in SQLDA
  • purpose
  • setting values
• Y array in SQLDA
  • purpose
  • setting values
• Z array in SQLDA
  • purpose
  • setting values