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

Home