Skip Headers
Pro*PL/1® Supplement to the Oracle Precompilers Guide
11g Release 1(11.1)

Part Number B31230-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

A  B  C  D  E  F  G  H  I  L  M  N  O  P  Q  R  S  U  V  W 

A

ADDR built-in function
use in SQLADR procedure, 5.2.1
automatic logins, 1.13.1

B

bind descriptor, 5.2.1
descriptor areas, 5.2.1
bind descriptor area, 5.2.1
bind SQLDA
purpose of, 5.1.3

C

CHAR
Oracle external datatype, 5.2.5.4
CLOSE statement
use in Dynamic SQL Method 4, 5.4.17
colon
use of with host variables, 1.3.2
comments
ANSI-style, 1.1.1
PL/I-style, 1.1.1
compiling, 3.5
conditional precompilation
benefits of, 3.3
purpose of, 3.3
connecting to Oracle
automatically, 1.13.1
CONTINUE action
in the WHENEVER statement, 2.4
Conventions
description of, Preface
Notation, Preface
cursor
closing, 5.4.17
declaration of, 5.4.8
opening, 5.4.12
restricted scope of, 3.4.1
cursor cache
purpose of, 2.5

D

Data Definition Language
creating CHAR objects with DBMS=V6, 3.2.5
datatype codes, 5.2.5
defined, 5.2.5.1
list of, 5.2.5.4
datatype conversions, 1.10
datatype equivalencing, 1.11
example of, 1.11.1
datatypes, 5.2.5
coercing, 5.2.5.2
coercing NUMBER to VARCHAR2, 5.2.5.3
external, 5.2.5.1
internal, 5.2.5.1
DATE
Oracle external datatype, 5.2.5.4
DECIMAL
Oracle external datatype, 5.2.5.4
declaration
of host arrays, 1.5.1
of host variables, 1.3.1
of indicator variables, 1.4.1
of ORACA, 2.5.1
of SQLCA, 2.2.1
of SQLDA, 5.2.2
DECLARE CURSOR statement
use in Dynamic SQL Method 4, 5.4.8
declare section
PL/I datatypes allowed in, 1.3.1
purpose of, 1.2.1
rules for defining, 1.2.1
statements allowed in, 1.2.1
default
error handling, 2.4
setting of ORACA option, 2.5.2
DESCRIBE BIND VARIABLES statement
use in Dynamic SQL Method 4, 5.4.9
DESCRIBE SELECT LIST statement
use in Dynamic SQL Method 4, 5.4.13
descriptor areas, 5.2.1
select descriptor, 5.2.1
descriptors
reserved elements in, 5.2.4.16
directory
current, 1.2.2
directory path
for INCLUDE files, 1.2.2
DISPLAY
Oracle external datatype, 5.2.5.4
DO action
in the WHENEVER statement, 2.4
Dynamic SQL Method 1
program example, 4.7
Dynamic SQL Method 2
program example, 4.8
Dynamic SQL Method 3
program example, 4.9
Dynamic SQL Method 4
requirements of, 5.1.1
sequence of statements used with, 5.4
steps for, 5.3
use of CLOSE statement in, 5.4.17
use of DECLARE CURSOR statement in, 5.4.8
use of DESCRIBE statement in, 5.4.9, 5.4.13
use of FETCH statement in, 5.4.15
use of OPEN statement in, 5.4.12
use of PREPARE statement in, 5.4.7

E

embedded PL/SQL
requirements for, 1.12
using host variables with, 1.12.1
using indicator variables with, 1.12.2
where allowed, 1.12
embedded SQL
requirements for, 1.1.3
syntax for, 1.1.3
embedded SQL statements
comments in, 1.1.1
labels for, 1.1.14
referencing host variables in, 1.3.2
referencing indicator variables in, 1.4.2
terminator for, 1.1.13
use of, 1.1.11
use of apostrophes in, 1.1.11
equivalencing of datatypes, 1.11
error message text
use in error reporting, 2.2.3.5
using the SQLGLM function to get, 2.3
error messages
maximum length of, 2.3
error reporting
key components of, 2.2.3
use of error message text in, 2.2.3.5
use of parse error offset in, 2.2.3.4
use of rows-processed count in, 2.2.3.3
use of status codes in, 2.2.3.1
use of warning flags in, 2.2.3.2
EXEC ORACLE statement
syntax for, 3.2.7
using to enter options inline, 3.2.7
EXEC SQL clause
using to embed SQL statements, 1.1.3
EXECUTE statement
use in Dynamic SQL Method 4, 5.5
use with host arrays, 5.5
external datatype
defined, 5.2.5.1
external datatypes, 5.2.5.1
list of, 1.9.2

F

FETCH statement
use in Dynamic SQL Method 4, 5.4.15
file extension
for INCLUDE files, 1.2.2
flags
warning flags, 2.2.3.2
FLOAT
Oracle external datatype, 5.2.5.4
functions
precompiling, 3.4

G

GOTO action
in the WHENEVER statement, 2.4

H

host arrays
declaring, 1.5.1
multidimensional, 1.5.1
restrictions on, 1.5.1, 1.5.2
host variables
attribute factoring in declaration of, 1.3.1.2
compatibility with database objects, 1.3.1
declaring, 1.3.1
definition of, 1.1.4
naming, 1.3.2
passed to a subroutine, 1.3.1.3
referencing, 1.3.2
restrictions on, 1.6
rules for naming, 1.1.4
scope of, 1.1.12
using with PL/SQL, 1.12.1
where to declare, 1.2.1, 1.3.1.3

I

INAME option
when a file extension is required, 3.1
INCLUDE statement
effect of, 1.2.2
not like PL/I %INCLUDE directive, 1.2.2
using to declare the ORACA, 2.5.1
using to declare the SQLCA, 2.2.1
using to declare the SQLDA, 5.2.2
indicator variables, 1.4
association with host variables, 1.4
declaring, 1.4.1
function of, 1.4
referencing, 1.4.2
required size of, 1.4.1
using with PL/SQL, 1.12.2
insert of no rows
cause of, 2.1.4
internal datatype, 5.2.5.1
defined, 5.2.5.1
internal datatypes
list of, 1.9.1
IS NULL operator
for testing nulls, 1.1.6

L

LIKE attribute
cannot be used for host variables, 1.3.1.1
linking, 3.5
LMARGIN, 3.2.8
logical operators, 1.1.7
LONG
Oracle external datatype, 5.2.5.4
LONG RAW
Oracle external datatype, 5.2.5.4
LONG VARRAW
Oracle external datatype, 5.2.5.4, 5.2.5.4

M

MAXLITERAL
default value, 1.1.5
message text
error message text, 2.2.3.5
MLSLABEL
Oracle external datatype, 5.2.5.4
MODE option
default value for, 3.2.6
effects of, 1.8.1
purpose of, 3.2.6
syntax for, 3.2.6
usage notes for, 3.2.6
multidimensional arrays
cannot be declared as host variables, 1.5.1
invalid use of, 1.5.1

N

naming
of host variables, 1.1.4
NOT FOUND condition
in the WHENEVER statement, 2.4
Notation
rules for, Preface
Conventions, Preface
NULL
meaning of in SQL, 1.1.6
PL/I built-in function, 1.1.6
null values
handling in Dynamic SQL Method 4, 5.2.6
using the SQLNUL procedure to test for, 5.2.6
NUMBER datatype
using the SQLPRC procedure with, 5.2.5.3
NVL function
for retrieving nulls, 1.1.6

O

OPEN statement
use in Dynamic SQL Method 4, 5.4.12
operators
relational, 1.1.8
options
precompiler, 3.2
ORACA
declaring, 2.5.1
enabling, 2.5.2
fields in, 2.5.3
purpose of, 2.5
ORACLE Communications Area
ORACA, 2.5
Oracle Precompilers
use of PL/SQL with, 1.12

P

parse error offset
how to interpret, 2.2.3.4
use in error reporting, 2.2.3.4
PL/I
BASED variables, 1.6
labels, 1.1.14
preprocessor not supported, 1.1.10
use of apostrophes in, 1.1.11
use of pointers in embedded SQL, 1.6
PL/I datatypes
allowed in SQL declare section, 1.3.1
CHARACTER VARYING, 1.7
FIXED DECIMAL, 5.2.4.6
supported by Oracle Precompilers, 1.3.1
PL/SQL
embedded PL/SQL, 1.12
pointers
use of in PL/I, 1.6
precision
extracting, 5.2.5.3
in the FIXED DECIMAL PL/I datatype, 5.2.4.6
precision and scale
using the SQLPRC procedure to extract, 5.2.5.3
precompiler command
issuing, 3.1
optional arguments of, 3.2
required arguments, 3.1
Precompiler options
MODE, 3.2.6
precompiler options
default settings, 3.2
displaying, 3.2
entering inline, 3.2.7
inline versus on the command line, 3.2.7
respecifying, 3.2.4
scope of, 3.2.4
scope of inline options, 3.2.7
specifying, 3.2
PREPARE statement
use in Dynamic SQL Method 4, 5.4.7
preprocessor
not supported in SQL blocks, 1.1.10
procedures
declare section in, 1.3.1.3
pseudocolumns
list of, 1.9.2

Q

quotation marks
use of in embedded SQL, 1.1.11

R

RAW
Oracle external datatype, 5.2.5.4
referencing
of host variables, 1.3.2
of indicator variables, 1.4.2
relational operators, 1.1.8
restrictions
on host arrays, 1.5.2
on PL/I variables, 1.6
RMARGIN, 3.2.8
ROWID
Oracle external datatype, 5.2.5.4
rows-processed count
use in error reporting, 2.2.3.3

S

scale
extracting, 5.2.5.3
in the FIXED DECIMAL PL/I datatype, 5.2.4.6
when negative, 5.2.5.3
scope
of host variables, 1.1.12
of precompiler options, 3.2.4
of WHENEVER statement, 2.4.1
select descriptor, 5.2.1
select descriptor area, 5.2.1
select SQLDA
purpose of, 5.1.3
Separate compilation
restrictions on, 3.4.1
separate precompilation
definition of, 3.4
need for, 3.4
SQL statement
terminator for, 1.1.13
SQL*Forms user exit
sample program, 4.6
SQLADR procedure
syntax of, 5.2.1
use of, 5.2.1
SQLCA
declaring, 2.2.1
purpose of, 2.2
SQLCODE variable, 2.2.3.1
declaring, 2.1.4
interpreting values of, 2.1.4
SQLDA
datatypes in, 5.2.5
declaring, 5.2.2
SQLDFMT element in, 5.2.4.6
SQLDFND element in, 5.2.4.3
SQLDH_CUR_VNAMEL element in, 5.2.4.12
SQLDH_MAX_VNAME element in, 5.2.4.11
SQLDH_VNAME element in, 5.2.4.10
SQLDI element in, 5.2.4.9
SQLDI_CUR_VNAMEL element in, 5.2.4.15
SQLDI_MAX_VNAMEL element in, 5.2.4.14
SQLDI_VNAME element in, 5.2.4.13
SQLDNUM element in, 5.2.4.2
SQLDSC element in, 5.2.4.4
SQLDV element in, 5.2.4.6
SQLDVLN element in, 5.2.4.7
SQLDVTYP element in, 5.2.4.8
structure, 5.2.4
variables, 5.2.4
SQLDFMT
element in SQLDA, 5.2.4.6
SQLDFMT element in SQLDA
how value is set, 5.2.4.6
SQLDFND element in SQLDA
how value is set, 5.2.4.3
SQLDH_CUR_VNAME element in SQLDA
how value is set, 5.2.4.12
SQLDH_MAX_VNAME element in SQLDA
how value is set, 5.2.4.11
SQLDH_VNAME element in SQLDA
how value is set, 5.2.4.10
SQLDI element in SQLDA
how value is set, 5.2.4.9
SQLDI_CUR_VNAMEL element in SQLDA
how value is set, 5.2.4.15
SQLDI_MAX_VNAMEL element in SQLDA
how value is set, 5.2.4.14
SQLDI_VNAME element in SQLDA
how value is set, 5.2.4.13
SQLDNUM element in SQLDA
how value is set, 5.2.4.2
SQLDSC element in SQLDA
how N is set, 5.2.4.4
SQLDV element in SQLDA
how value is set, 5.2.4.6
SQLDVLN
must be set by program, 5.2.4.7
SQLDVLN element in SQLDA
how value is set, 5.2.4.7
SQLDVTYP element in SQLDA
how it is used, 5.2.5
how value is set, 5.2.4.8
SQLERRD(3) variable, 2.2.3.3
SQLERRM variable, 2.2.3.5
SQLERROR condition
in the WHENEVER statement, 2.4
SQLGLM function
example of using, 2.3
need for, 2.3
parameters of, 2.3
syntax for, 2.3
SQLNUL procedure
example of using, 5.2.6
parameters of, 5.2.6
purpose of, 5.2.6
syntax for, 5.2.6
use of with SQLDVTYP, 5.2.4.8
SQLPR2 procedure
purpose of, 5.2.5.3
SQLPRC procedure
example of using, 5.2.5.3
parameters of, 5.2.5.3
purpose of, 5.2.5.3
syntax for, 5.2.5.3
SQLSTATE
class codes, 2.1.2
declaring, 2.1.1
mapping to Oracle errors, 2.1.2
predefined classes, 2.1.2
status codes, 2.1.2
using, 2.1.3
values, 2.1.2
SQLWARNING condition
in the WHENEVER statement, 2.4
statement labels, 1.1.14
status codes
use in error reporting, 2.2.3.1
STOP action
in the WHENEVER statement, 2.4
STRING
Oracle external datatype, 5.2.5.4
structure
elements in allowed as host variable, 1.3.1.1
use of as host variable not allowed, 1.3.1.1
subroutines
declare section in, 1.3.1.3
precompiling, 3.4
syntax
embedded SQL, 1.1.3

U

UNSIGNED
Oracle external datatype, 5.2.5.4

V

VAR statement
syntax for, 1.11.1
VARCHAR2
Oracle external datatype, 5.2.5.4
VARRAW
Oracle external datatype, 5.2.5.4

W

warning flags
use in error reporting, 2.2.3.2
WHENEVER statement
automatic checking of SQLCA with, 2.4
CONTINUE action in, 2.4
DO action in, 2.4
GOTO action in, 2.4
maintaining addressability for, 2.4.1.2
NOT FOUND condition in, 2.4
scope of, 2.4.1
SQLERROR condition in, 2.4
SQLWARNING condition in, 2.4
STOP action in, 2.4
syntax for, 2.4
uses for, 2.4