Go to main content
34/34
Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Symbols
#include
file inclusion, Pro*C compared to C,
5.4.1
A
abnormal termination
automatic rollback,
F.15
active set
changing,
6.5.2
,
6.5.3
cursor movement through,
6.5.3
definition of,
2.1.9
how identified,
6.5
if empty,
6.5.3
when fetched from,
6.5.3
when no longer defined,
6.5
ALLOCATE
allocating a cursor variable,
4.5.2
ALLOCATE DESCRIPTOR statement,
14.5.1
,
F.5
ALLOCATE SQL statement,
17.4.2
ALLOCATE SQL statements,
F.4
allocating
cursor variables,
4.5.2
cursors,
F.4
thread context,
11.4.2.2
,
F.17
ANSI C Support,
E.1.3
ANSI dynamic SQL,
A.2.12
reference semantics,
14.3.1
See also dynamic SQL (ANSI),
14
application development process,
2.2
array of structs,
8.10
,
A.2.1
ARRAYLEN statement,
7.5.1
arrays
batch fetch,
8.4.1
bulk operations (ANSI dynamic SQL),
14.3.2
chapter discusses how to use,
8
definition of,
4.8.1
host arrays,
2.1.7
operations,
2.1.7
varying length,
18.1.2
associative interface,
17.4
when to use,
17.4.1
AT clause
in CONNECT statement,
3.2.4.1
in DECLARE CURSOR statement,
3.2.4.1.3
in DECLARE STATEMENT statement,
3.2.4.1.4
in EXECUTE IMMEDIATE statement,
3.2.4.1.4
of COMMIT statement,
F.15
,
F.23
of EXECUTE IMMEDIATE statement,
F.35
of EXECUTE statement,
F.32
of INSERT statement,
F.40
of SAVEPOINT statement,
F.72
of SELECT statement,
F.73
of SROLLBACK statement,
F.71
of UPDATE statement,
F.76
restriction on,
3.2.4.1.3
use of,
3.2.4.1.3
attributes of a collection
descriptions,
18.4.6
AUTO_CONNECT,
10.5.1
precompiler option,
3.1.3.1
AUTO_CONNECT precompiler option,
10.5.1
automatic connections,
3.1.3
,
3.2.4
B
batch fetch
advantage of,
8.4.1
example of,
8.4.1
number of rows returned by,
8.4.3
BFILES,
16.1.2
security,
16.1.3
bind descriptor,
13.10.1
,
15.2.1
,
15.2.1
definition of,
13.10.1
information in,
13.10.2
bind SQLDA
purpose of,
15.1.3
bind variables
input host variables,
13.10.1
binding
definition of,
13.5
BREAK action
of WHENEVER,
F.78
Byte Ordering,
E.1.6
C
C preprocessor
directives supported by Pro*C,
5.4
how used in Pro*C,
5.4
C structs
generating for a REF,
17.13.1
using,
17.12
C types of collection attributes,
18.4.6
C variable in SQLDA
how value is set,
15.3.9
purpose of,
15.3.9
C++,
1.6.5
C++ applications,
12
cache,
17.3
CACHE FREE ALL SQL statement,
17.4.4
CACHE FREE ALL statement,
F.6
CALL SQL statement,
F.7
CALL statement,
7.7.2.3
,
A.2.3
example,
7.7.2.4
Calling Java from PL/SQL,
A.3.5
CASE OTT parameter,
19.5.2.10
case sensitivity
in precompiler options,
10.1.1
CHAR datatype,
4.1.2.17
CHAR_MAP precompiler option,
5.1.1
,
10.5.2
,
A.2.6
character data,
5.1
character strings
multibyte,
4.11.4
CHARF datatype,
4.1.2.19
,
5.3.3
CHARZ datatype,
4.1.2.18
CLOSE CURSOR statement,
14.5.13
CLOSE SQL statements,
F.8
CLOSE statement
dependence on precompiler options,
6.5.4
example,
6.5.4
,
F.8
purpose of,
6.5
,
6.5.4
use in dynamic SQL method 4,
15.6.18
CLOSE_ON_COMMIT
precompiler option,
10.5.4
,
A.3.9
closing
cursors,
F.8
CODE
precompiler option,
12.2.1
CODE OTT parameter,
19.5.2.4
code page,
4.10
CODE precompiler option,
10.5.8
,
10.5.8
coding conventions,
2.3
COLLECT GET statement
example,
18.5.2
COLLECTION APPEND,
F.9
COLLECTION APPEND statement,
18.4.4
SQL statements
COLLECTION APPEND,
F.9
COLLECTION DESCRIBE
example,
18.5.3
COLLECTION DESCRIBE statement,
18.4.6
SQL statements
COLLECTION DESCRIBE,
F.10
COLLECTION GET statement,
18.4.1
SQL statements
COLLECTION GET,
F.11
collection object types
handling,
18.2.2
COLLECTION RESET statement,
18.4.3
example,
18.5.4
SQL statements
COLLECTION RESET,
F.12
COLLECTION SET statement,
18.4.2
example,
18.5.2
SQL statements
COLLECTION SET,
F.13
COLLECTION TRIM statement,
18.4.5
SQL statements
COLLECTION TRIM,
F.14
collection types
structs for,
18.2
collections,
A.2.13
and C,
18.1.3
autonomous access,
18.2.2.1
descriptors,
18.2
element access,
18.2.2.2
manipulating,
18.2.2
nested tables,
18.1.1
OBJECT GET statement,
18.3
OBJECT SET statement,
18.3
VARRAYs,
18.1.2
column list
in INSERT statements,
6.3.2
when permissible to omit,
6.3.2
COMMENT clause
of COMMIT statement,
F.15
Comments
restrictions in PL/SQL block,
13.12.4
comments
ANSI,
2.3.1
which allowed,
2.3.1
commit
automatic,
3.5
explicit versus implicit,
3.5
function of,
3.4
COMMIT SQL statement,
F.15
COMMIT statement,
3.6
effect of,
3.6
ending a transaction,
F.71
example of,
3.6
examples,
F.15
purpose of,
3.6
RELEASE option in,
3.6
using in a PL/SQL block,
3.14.3
where to place,
3.6
committing
transactions,
F.15
communicating over a network,
3.2.1
COMP_CHARSET precompiler option,
10.5.9
,
10.5.9
compiling,
2.6
specifying include file locations,
5.4.7
concurrency
definition of,
3.3
concurrent connections,
3.2.2
conditional precompilation,
2.4
defining symbols,
5.6.1
example,
2.4.2
,
5.6.2
CONFIG OTT parameter,
19.5.2.8
CONFIG precompiler option,
10.5.3
,
10.5.5
,
10.5.6
,
10.5.7
,
10.5.10
,
10.5.10
,
10.5.11
,
10.5.13
configuration files,
10.2.1
and the Object Type Translator,
19.2.2
location,
10.2.1
system,
10.2.2
user,
10.2.2
CONNECT statement,
F.16
,
F.16
AT clause in,
3.2.4.1
connecting to Oracle with,
3.1
examples,
F.16
requirements for,
3.1
USING clause in,
3.2.4.1
using to enable a semantic check,
D.3.1.1
connecting to Oracle,
3.1
automatic connections,
3.1.3
concurrently,
3.2.2
example of,
3.1
using Oracle Net,
3.2.2
connection pooling,
11.6
demo program1,
11.6.2
demo program2,
11.6.3
example,
11.6.3.3
using,
11.6.1
connections
concurrent,
3.2.4.2
default versus nondefault,
3.2.3
Explicit connections,
3.2.4
implicit,
3.2.5
naming of,
3.2.4
const
declaring constants,
5.7.2
CONTEXT ALLOCATE SQL statement,
F.17
CONTEXT ALLOCATE statement,
11.4.2.2
context block
definition of,
20.4.1
CONTEXT FREE statement,
11.4.2.4
,
F.18
CONTEXT OBJECT OPTION GET SQL statement,
17.7.2
CONTEXT OBJECT OPTION SET SQL statement,
17.7.1
CONTEXT USE directive,
11.4.2.3
CONTEXT USE SQL directive,
F.21
CONTEXT USE SQL statement,
11.4.2.3
CONTINUE action
in the WHENEVER statement,
9.8.2.1
of WHENEVER directive,
F.78
,
F.78
result of,
9.8.2.1
CONVBUFSZ clause,
4.11.3
CPP_SUFFIX
precompiler option,
12.2.3
CPP_SUFFIX precompiler option,
10.5.12
CPP_SUFFIX precompiler options,
10.5.12
CREATE PROCEDURE statement
embedded,
7.7.1
creating
savepoints,
F.72
creating temporary LOB,
16.4.5
CURRENT OF clause,
8.3.3
example of,
6.8
mimicking with ROWID,
3.12
,
8.11
purpose of,
6.8
restrictions on,
6.8.1
current row
definition of,
2.1.9
using FETCH to retrieve,
6.5
cursor cache
definition of,
9.10.4
purpose of,
C.8.2.1
cursor control statements
example of typical sequence,
6.9
cursor operations
overview of,
6.5
cursor variables,
4.5
,
F.4
allocating,
4.5.2
declaring,
4.5.1
restrictions on,
4.5.6
cursors,
2.5.1.1
,
4.5
allocating,
F.4
allocating a cursor variable,
4.5.2
analogy for,
2.1.9
association with queries,
6.5
closing,
F.8
declaring,
6.5.1
definition of,
2.1.9
explicit versus implicit,
2.1.9
fetching rows from,
F.36
,
F.37
for multirow queries,
6.5
how handling affects performance,
C.8.1
movement through active set,
6.5.3
opening,
F.67
,
F.68
purpose of,
6.5
reopening,
6.5.2
,
6.5.3
restrictions on declaring,
6.5.1
rules for naming,
6.5.1
scope of,
6.5.1
scrollable cursors,
6.6
statements for manipulating,
6.5
types of,
2.1.9
using more than one,
6.5.1
D
data definition language
in transactions,
3.5
data integrity,
3.2.4.3
definition of,
3.3
data locks,
3.3
database link
creating synonym for,
3.2.5.1
defining,
3.2.5.1
example using,
3.2.5.1
using in INSERT statement,
F.40
where stored,
3.2.5.1
database types
new,
17.15
databases
naming,
3.2.3
datatype equivalencing,
2.1.8
datatypes
ANSI DATE,
4.1.3.2
codes used in descriptors,
15.4.2
coercing NUMBER to VARCHAR2,
15.4.2
conversions,
5.2
,
5.2
dealing with ORACLE internal,
15.4.2
equivalencing,
5.3
equivalencing, purpose of,
2.1.8
internal,
4.1.1
internal versus external,
2.1.6
INTERVAL DAY TO SECOND,
4.1.3.7
INTERVAL YEAR TO MONTH,
4.1.3.6
list of internal,
15.4.1.1
need to coerce,
15.4.2
Oracle,
2.1.6
OTT mappings,
19.2.5
restrictions on using,
17.16
TIMESTAMP,
4.1.3.3
TIMESTAMP WITH LOCAL TIME ZONE,
4.1.3.5
TIMESTAMP WITH TIME ZONE,
4.1.3.4
user-defined type equivalencing,
F.75
when to reset,
15.4.2
DATE datatype,
4.1.2.10
DATE, ANSI
datatype,
4.1.3.2
datetime
avoiding unexpected results,
4.1.3.8
DBMS interaction with MODE,
10.5.14
DBMS option,
5.3.3
DBMS precompiler option,
10.5.14
,
10.5.14
deadlock
definition of,
3.3
effect on transactions,
3.8.1
how broken,
3.8.1
DEALLOCATE DESCRIPTOR statement,
14.5.2
,
F.22
declaration
of cursors,
6.5.1
of host arrays,
8.2
of pointer variables,
4.9.1
of SQLCA,
9.6.1
declarative SQL statements
in transactions,
3.5
DECLARE CURSOR directives
examples,
F.23
DECLARE CURSOR statement,
14.5.10
AT clause in,
3.2.4.1.3
use in dynamic SQL method 4,
15.6.7
DECLARE DATABASE SQL directives,
F.24
Declare Section
allowable statements,
2.3.3
form,
2.3.3
purpose,
2.3.3
required when MODE=ANSI,
10.5.33
requirements,
2.3.3
rules for defining,
2.3.3
when MODE=ANSI,
5.3.4
when required,
2.3.3
,
4.2.1
DECLARE statement,
6.5.1
example of,
6.5.1
purpose of,
6.5
required placement of,
6.5.1
scope of,
F.25
use in dynamic SQL method 3,
13.9.2
DECLARE STATEMENT directive,
F.25
DECLARE STATEMENT statement
AT clause in,
3.2.4.1.4
example of using,
13.11
using with dynamic SQL,
13.11
when required,
13.11
DECLARE statements
examples,
F.25
DECLARE TABLE directive
examples,
F.26
using with the SQLCHECK option,
D.3.1.2
DECLARE TABLE SQL directive,
F.26
DECLARE TABLE statement
need for with AT clause,
3.2.4.1.1
DECLARE TYPE directive,
F.27
DEF_SQLCODE precompiler option,
10.5.15
default connections,
3.2.3
default database,
3.2.3
default file name extensions,
19.5.7
DEFINE precompiler option,
10.5.16
used in application migration,
5.4.9
defining symbols,
2.4.1
DELETE SQL statement,
F.28
DELETE statement
embedded SQL examples,
F.28
example of,
6.3.4
purpose of,
6.3.4
using host arrays in,
8.7
WHERE clause in,
6.3.4
delimiters
C versus SQL,
2.3.4
DEPT table,
2.7
DESCRIBE BIND VARIABLES statement
use in dynamic SQL method 4,
15.6.8
DESCRIBE command
use with PREPARE command,
F.29
DESCRIBE DESCRIPTOR statement,
F.30
DESCRIBE INPUT statement,
14.5.6
DESCRIBE OUTPUT statement,
14.5.7
DESCRIBE SELECT LIST statement
use in dynamic SQL method 4,
15.6.12
DESCRIBE SQL statement,
F.29
DESCRIBE statement
examples,
F.29
use in dynamic SQL Method 4,
13.10.1
descriptions of collection attributes,
18.4.6
descriptors,
15.2.1
bind descriptor,
13.10.1
definition of,
13.10
need for,
15.2.1
select descriptor,
13.10.1
using the sqlald() function to allocate,
15.2.4
using the sqlclu() function to deallocate,
15.6.17
determining current value of precompiler options,
10.2.2
distributed processing
support for,
3.2.2
using Oracle Net for,
3.2.2
distributed transactions,
F.71
DML Returning Clause,
A.3.6
DML returning clauses,
6.4
DO action
in the WHENEVER statement,
9.8.2.2
of WHENEVER directive,
F.78
result of,
9.8.2.2
DTP model,
5.12
dummy host variables
placeholders,
13.4
DURATION precompiler option,
10.5.18
,
17.8.2
dynamic PL/SQL
rules for,
13.12
versus dynamic SQL,
13.12
dynamic SQL
advantages and disadvantages of,
13.2
cannot use cursor variables with,
4.5.6
choosing the right method,
13.6.5
definition of,
2.1.3
guidelines for,
13.6.5
overview of,
13.1
restriction on,
6.8.1
restrictions on use of datatypes,
17.16
restrictions on using datatypes in,
17.16
use of PL/SQL with,
7.9
uses for,
13.2
using the AT clause in,
3.2.4.1.4
when to use,
13.3
dynamic SQL (ANSI)
basics,
14.1
bulk operations,
14.3.2
differences from Oracle dynamic,
14.5.14
Oracle extensions,
14.3
Overview,
14.2
Precompiler Options,
14.1.1
precompiler options,
14.4
reference semantics,
14.3.1
sample program,
14.6.2
sample programs,
14.6
dynamic SQL method 1
commands used with,
13.6.1
description of,
13.7
example of,
13.7.1
how to use,
13.7
requirements for,
13.6.1
use of EXECUTE IMMEDIATE with,
13.7
use of PL/SQL with,
13.12.1
dynamic SQL method 2
commands used with,
13.6.2
description of,
13.8
example of,
13.8.2
requirements for,
13.6.2
use of DECLARE STATEMENT with,
13.11
use of EXECUTE with,
13.8
use of PL/SQL with,
13.12.2
use of PREPARE with,
13.8
dynamic SQL method 3
commands used with,
13.6.3
compared to method 2,
13.9
example program,
13.9.6
requirements for,
13.6.3
sequence of statements used with,
13.9
use of DECLARE STATEMENT with,
13.11
use of DECLARE with,
13.9.2
use of FETCH with,
13.9.4
use of OPEN with,
13.9.3
use of PL/SQL with,
13.12.3
use of PREPARE with,
13.9.1
dynamic SQL method 4
need for descriptors with,
15.2.1
overview of,
13.10.1
prerequisites for using,
15.4
requirements for,
13.6.4
requirements of,
15.1.1
sample program,
15.7
sequence of statements used with,
13.10.4
,
15.6
steps for,
15.5
use of CLOSE statement in,
15.6.18
use of DECLARE CURSOR statement in,
15.6.7
use of DECLARE STATEMENT with,
13.11
use of DESCR,
13.10.1
use of DESCRIBE statement in,
15.6.8
,
15.6.12
use of descriptors with,
13.10
use of FETCH statement in,
15.6.15
use of OPEN statement in,
15.6.11
use of PL/SQL with,
13.12.4
use of PREPARE statement in,
15.6.6
use of the SQLDA in,
13.10.1
,
15.2.1
using host arrays with,
15.6.19
using the FOR clause with,
13.11.1
,
15.6.19
when needed,
13.10
dynamic SQL methods
overview of,
13.6
dynamic SQL statements
binding of host variables in,
13.5
definition of,
13.1
requirements for,
13.4
use of placeholders in,
13.4
using host arrays in,
13.11.1
versus static SQL statements,
13.1
E
embedded PL/SQL
advantages of,
7.1.1
cursor FOR loop,
7.1.3
example of,
7.3.1
,
7.3.2
overview of,
2.1.4
packages,
7.1.5
PL/SQL tables,
7.1.6
procedures and functions,
7.1.4
requirements for,
7.2
SQLCHECK option,
7.2
support for SQL,
2.1.4
user-defined records,
7.1.7
using %TYPE,
7.1.2
using the VARCHAR pseudotype with,
7.3.3
using to improve performance,
C.4
where allowed,
7.2
embedded SQL
ALLOCATE statement,
F.4
CLOSE statement,
F.8
CONTEXT ALLOCATE statement,
11.4.2.2
,
F.17
CONTEXT FREE statement,
11.4.2.4
definition of,
2.1.1
difference from interactive SQL,
2.1.2
ENABLE THREADS statement,
11.4.2.1
EXEC SQL CACHE FREE ALL,
17.4.4
EXECUTE statement,
F.32
key concepts of,
2.1
mixing with host-language statements,
2.1.2
OPEN statement,
F.67
overview of,
2.1.1
PREPARE statement,
F.69
requirements for,
2.1.2
SAVEPOINT statement,
F.72
SELECT statement,
F.73
syntax for,
2.1.2
testing with SQL*Plus,
1.3
TYPE directive,
F.75
UPDATE statement,
F.76
using OCI types in,
17.14.2
using REFs in,
17.13.3
VAR directive,
F.77
when to use,
1.3
WHENEVER directive,
F.78
embedded SQL statements
labels for,
9.8.2.5
referencing host arrays in,
8.3.1
referencing host variables in,
4.2.2
suffixes and prefixes not allowed,
2.3.2
terminator for,
2.3.13
use of apostrophes in,
2.3.4
use of quotation marks in,
2.3.4
embedding
PL/SQL blocks in precompiler programs,
F.32
EMP table,
2.7
ENABLE THREADS SQL statement,
F.31
ENABLE THREADS statement,
11.4.2.1
enabling
threads,
11.4.2.1
encoding scheme (character set or code page),
4.10
enqueues
locking,
3.3
entering options,
5.4.4
,
10.4
equivalencing
host variable equivalencing,
F.77
user-defined type equivalencing,
F.75
equivalencing of datatypes
datatype equivalencing,
2.1.8
error detection
error reporting,
F.78
error handling,
2.1.11
alternatives,
9.2
need for,
9.1
overview of,
2.1.11
SQLCA versus WHENEVER statement,
9.2.2
use of ROLLBACK statement in,
3.8
error messages
maximum length of,
9.7
use in error reporting,
9.5.5
using the sqlglm() function to get,
9.7
where available in SQLCA,
9.5.5
error reporting
key components of,
9.5
use of error messages in,
9.5.5
use of parse error offset in,
9.5.4
use of rows-processed count in,
9.5.3
use of warning flags in,
9.5.2
WHENEVER directive,
F.78
ERRORS precompiler option,
10.5.19
ERRTYPE
precompiler option,
10.5.20
ERRTYPE OTT parameter,
19.5.2.9
ERRTYPE precompiler option,
17.8.5
exception, PL/SQL
definition of,
7.4.1
EXEC ORACLE DEFINE statement,
5.6
EXEC ORACLE ELSE statement,
2.4
,
5.6
EXEC ORACLE ENDIF statement,
2.4
,
5.6
EXEC ORACLE IFDEF statement,
2.4
,
5.6
EXEC ORACLE IFNDEF statement,
2.4
,
5.6
EXEC ORACLE OPTION statement
set option values inline,
10.4
EXEC ORACLE statement
scope of,
10.4.2.2
syntax for,
10.4.2
uses for,
10.4.2.1
EXEC ORACLE statements,
2.4
EXEC SQL CACHE FREE statement,
17.4.4
EXEC SQL clause
using to embed SQL,
2.1.2
EXEC SQL INCLUDE
contrasted with #include,
5.4.8
EXEC SQL VAR statement
CONVBUFSZ clause,
4.11.3
EXEC TOOLS
GET CONTEXT statement,
20.5.5
GET statement,
20.5.3
MESSAGE statement,
20.5.6
SET CONTEXT statement,
20.5.4
SET statement,
20.5.2
EXEC TOOLS statements,
20.5
executable SQL statements
purpose of,
6.3
uses for,
2.1.1.1
where allowed,
2.1.1.1
EXECUTE ... END-EXEC SQL statement,
F.32
EXECUTE DESCRIPTOR statement
SQL statements
EXECUTE DESCRIPTOR,
F.34
EXECUTE IMMEDIATE SQL statement,
F.35
EXECUTE IMMEDIATE statement,
14.5.9
AT clause in,
3.2.4.1.4
examples,
F.35
use in dynamic SQL method 1,
13.7
EXECUTE optional keyword of ARRAYLEN statement,
7.5.2
EXECUTE SQL statement,
F.33
EXECUTE statement,
14.5.8
examples,
F.32
,
F.33
use in dynamic SQL method 2,
13.8
execution of statements,
13.5
execution plan,
C.5
,
C.5.2
EXPLAIN PLAN statement
function of,
C.5.2
using to improve performance,
C.5.2
explicit connections,
3.2.4
description of,
3.2.4
multiple,
3.2.4.2
single,
3.2.4.1
extensions
default file name,
19.5.7
external datatypes
definition of,
2.1.6
FLOAT,
4.1.2.4
INTEGER,
4.1.2.3
STRING,
4.1.2.5
external procedures,
A.3.3
callbacks,
7.8
calling from PL/SQL,
7.8
creating,
7.8.2
error-handling,
7.8.3
restrictions,
7.8.1
F
F variable in SQLDA
how value is set,
15.3.6
purpose of,
15.3.6
FAQs,
1.6
features
new,
Preface
features,new,
Preface
FETCH DESCRIPTOR SQL statement,
F.37
FETCH SQL statement,
F.36
FETCH statement,
14.5.12
example of,
6.5.3
examples,
F.36
INTO clause in,
6.5.3
purpose of,
6.5
,
6.5.3
results of,
6.5.3
use in dynamic SQL method 3,
13.9.4
use in dynamic SQL method 4,
15.6.15
used after OPEN command,
F.68
used after OPEN statement,
F.67
fetching
rows from cursors,
F.36
,
F.37
fetching in batches
batch fetch,
8.4.1
FIPS flagger
warns of array usage,
8.3.4
warns of missing Declare Section,
4.2.1
warns of use of pointers as host variables,
5.1.3.3
FIPS precompiler option,
10.5.22
flags
warning flags,
9.5.2
FLOAT datatype,
4.1.2.4
FOR clause
example of using,
8.8
of embedded SQL EXECUTE DESCRIPTOR statement,
F.34
,
F.34
of embedded SQL EXECUTE statement,
F.33
,
F.33
purpose of,
8.8
requirements for,
8.8
restrictions on,
8.8.1
using in dynamic SQL method 4,
15.6.19
using with host arrays,
8.8
when variable negative or zero,
8.8
FOR UPDATE OF clause
locking rows with,
3.11
purpose of,
3.11.1
when to use,
3.11
FORCE clause
of COMMIT statement,
F.15
of ROLLBACK statement,
F.71
forward references
why not allowed,
6.5.1
FREE SQL statement,
17.4.3
,
F.38
free() function,
15.6.17
example of using,
15.6.17
freeing
thread context,
11.4.2.4
,
F.18
Frequently Asked Questions,
1.6
full scan
description of,
C.6
function prototype
definition of,
10.5.8
functions
cannot serve as host variables,
4.2.2.1
G
GENXTB form
how to run,
20.12
use with user exits,
20.12
GENXTB utility
how to run,
20.12
use with user exits,
20.12
GET DESCRIPTOR statement,
14.5.3
Globalization Support,
4.10
,
A.2.5
GOTO action
in the WHENEVER statement,
9.8.2.5
of WHENEVER directive,
F.78
result of,
9.8.2.5
guidelines
for dynamic SQL,
13.6.5
for separate precompilations,
2.5.1
for the WHENEVER statement,
9.8.6
for transactions,
3.14.1
H
HEADER precompiler option,
5.5
,
10.5.23
heap
definition of,
9.10.4
HFILE OTT parameter,
19.5.2.7
hints
COST,
C.5.1
for the ORACLE SQL statement optimizer,
6.7
in DELETE statements,
F.28
in SELECT statements,
F.73
in UPDATE statements,
F.76
HOLD_CURSOR
precompiler option
used to improved performance,
C.8.2.4
what it affects,
C.8
HOLD_CURSOR option
of ORACLE Precompilers,
F.8
HOLD_CURSOR precompiler option,
10.5.23
host arrays
advantages of,
8.1
declaring,
8.2
,
8.2
dimensioning,
8.2
in the DELETE statement,
8.7
in the INSERT statement,
8.5
in the SELECT statement,
8.4
in the UPDATE statement,
8.6
in the WHERE clause,
8.9
matching sizes of,
8.3.1
referencing,
8.2.1
,
8.3.1
restrictions on,
8.3.3
,
8.4.7
,
8.5.1
,
8.6.1
,
8.7.1
used as input host variables,
8.3
used as output host variables,
8.3
using in dynamic SQL method 4,
15.6.19
using in dynamic SQL statements,
13.11.1
using the FOR clause with,
8.8
using to improve performance,
C.3
when not allowed,
8.2.1
host language
definition of,
2.1.1
,
2.1.1.1
host program
definition of,
2.1.1
host structures
arrays in,
4.8.1
declaring,
4.8
host variables,
6.1.1
assigning values to,
2.1.5
declarations,
18.2.1
declaring,
2.3.3
,
18.2.1
definition of,
2.1.5
dummy,
13.4
host variable equivalencing,
F.77
in EXECUTE statement,
F.33
in OPEN statement,
F.67
in user exits,
20.4.1
input versus output,
6.1.1
must resolve to an address,
4.2.2.1
overview of,
2.1.5
purpose of,
6.1
restrictions on,
4.2.2.1
rules for naming,
2.3.8
using in PL/SQL,
7.3
I
I variable in SQLDA
how value is set,
15.3.5
purpose of,
15.3.5
IAP in SQL*Forms
purpose of,
20.13
identifiers, ORACLE
how to form,
F.3.5
implicit connections,
3.2.5
multiple,
3.2.5.2
single,
3.2.5.1
IN OUT parameter mode,
7.1.4
IN parameter mode,
7.1.4
INAME precompiler option,
10.5.25
INCLUDE
precompiler option, use of,
5.4.7
using to include the SQLCA,
9.6.1
INCLUDE precompiler option,
E.1.11
indexes
using to improve performance,
C.6
indicator arrays,
8.3.2
example of using,
8.3.2
uses for,
8.3.2
INDICATOR keyword,
4.3.1
indicator variables
assigning values to,
6.2
association with host variables,
6.2
declarations,
18.2.1
declaring,
4.3
,
18.2.1
definition of,
2.1.5
function of,
6.2
guidelines,
4.3.3
interpreting values of,
6.2
naming of,
4.8.4
referencing,
4.3
requirements for,
6.2
used with multibyte character strings,
4.11.6
using in PL/SQL,
7.4
using to detect NULLs,
6.2
using to detect truncated values,
6.2
using to insert NULLs,
6.2.1
using to return NULLs,
6.2.2
using to test for NULLs,
6.2.4
with structures,
4.8.4
in-doubt transaction,
3.13
INITFILE OTT parameter,
19.5.2.5
INITFUNC OTT parameter,
19.5.2.6
initialization function
calling,
19.3.2
tasks of,
19.3.3
input host variables
assigning values to,
6.1.1
definition of,
6.1.1
restrictions on,
6.1.1
uses for,
6.1.1
where allowed,
6.1.1
INSERT SQL statement,
F.40
examples,
F.40
INSERT statement
column list in,
6.3.2
example of,
6.3.2
INTO clause in,
6.3.2
purpose of,
6.3.2
requirements for,
6.3.2
using host arrays in,
8.5
VALUES clause in,
6.3.2
inserting
rows into tables and views,
F.40
INTEGER datatype,
4.1.2.3
interface
native,
5.12
XA,
5.12
internal datatypes
definition of,
2.1.6
INTERVAL DAY TO SECOND datatype,
4.1.3.7
INTERVAL YEAR TO MONTH datatype,
4.1.3.6
INTO clause
for output host variables,
6.1.1
in FETCH statements,
6.5.3
in INSERT statements,
6.3.2
in SELECT statements,
6.3.1
of FETCH DESCRIPTOR statement,
F.37
of FETCH statement,
F.36
of SELECT statement,
F.73
used with FETCH instead of SELECT,
6.5.1
intype file,
19.5.4
providing when running OTT,
19.2.4
structure of,
19.5.4
INTYPE OTT parameter,
19.5.2.2
INTYPE precompiler option,
10.5.27
invalid use
of precompiler preprocessor,
5.4.5.1
J
joins
restriction on,
6.8.1
L
L variable in SQLDA
how value is set,
15.3.3
purpose of,
15.3.3
label name
maximum length of,
9.8.2.5
Large Objects (LOBs),
A.2.11
LDA,
5.10
remote and multiple connections,
5.10.2
setup for OCI version 8,
5.10.1
lines
continuation,
2.3.9
maximum length,
2.3.10
LINES precompiler option,
10.5.28
link
database link,
3.2.5.1
linking,
2.6
on UNIX,
1.6.11
on VMS,
1.6.11
two-task,
2.6
Linking in an XA Library,
E.1.8
LNAME precompiler option,
10.5.29
LNPROC
VMS link script,
1.6.11
LOB APPEND SQL statement,
F.41
LOB APPEND statement,
16.4.1
LOB ASSIGN SQL statement,
F.42
LOB ASSIGN statement,
16.4.2
LOB CLOSE SQL statement,
F.43
LOB CLOSE statement,
16.4.3
LOB COPY SQL statement,
F.44
LOB COPY statement,
16.4.4
LOB CREATE TEMPORARY SQL statement,
F.45
LOB CREATE temporary statement,
16.4.5
LOB DESCRIBE SQL statement,
F.46
LOB DISABLE BUFFERING SQL statement,
F.47
LOB DISABLE BUFFERING statement,
16.4.6
LOB ENABLE BUFFERING SQL statement,
F.48
LOB ENABLE BUFFERING statement,
16.4.7
LOB ERASE SQL statement,
F.49
LOB ERASE statement,
16.4.8
LOB FILE CLOSE ALL SQL statement,
F.50
LOB FILE CLOSE ALL statement,
16.4.9
LOB file close all statement,
16.4.9
LOB FILE SET SQL statement,
F.51
LOB FILE SET statement,
16.4.10
LOB FLUSH BUFFER SQL statement,
F.52
LOB FLUSH BUFFER statement,
16.4.11
LOB FREE TEMPORARY SQL statement,
F.53
LOB FREE TEMPORARY statement,
16.4.12
LOB LOAD FROM FILE statement,
16.4.13
LOB LOAD SQL statement,
F.54
LOB OPEN SQL statement,
F.55
LOB OPEN statement,
16.4.14
LOB READ SQL statement,
F.56
LOB READ statement,
16.4.15
LOB TRIM SQL statement,
F.57
LOB WRITE SQL statement,
F.58
LOBs
access methods,
16.2.1
BFILES,
16.1.2
buffering system,
16.3.2
external,
16.1.2
initializing,
16.2.3
internal,
16.1.1
locators,
16.1.5
locators in C,
16.2.2
temporary,
16.1.6
Location of Included Files,
E.1.2
location of the Pro*C/C++ Executable,
E.1.9
location transparency
how provided,
3.2.5.1
lock
released by ROLLBACK statement,
F.71
LOCK TABLE statement
closes mall cursors,
3.11.2
example of,
3.11.2
locking tables with,
3.11.2
NOWAIT parameter in,
3.11.2
purpose of,
3.11.2
locking,
3.11
definition of,
3.3
explicit versus implicit,
3.11
modes of,
3.3
overriding default,
3.11
privileges needed to obtain,
3.14.2
table versus row,
3.11
uses for,
3.11
with FOR UPDATE OF,
3.11
with the LOCK TABLE statement,
3.11.2
logon,
3.1
Logon Data Area,
5.10
LONG datatype,
4.1.2.7
LONG RAW datatype,
4.1.2.13
LONG VARCHAR
datatype,
4.1.2.15
LONG VARRAW datatype,
4.1.2.16
LTYPE precompiler option,
10.5.30
lvalue,
4.2
M
M variable in SQLDA
how value is set,
15.3.8
purpose of,
15.3.8
macro precompiler options,
10.2.3
malloc()
example of using,
15.6.14
purpose of,
15.6.14
MAXLITERAL
default value for,
2.3.11
MAXLITERAL precompiler option,
10.5.31
MAXOPENCURSORS
precompiler option
effect on performance,
C.8.2.2
for multiple cursors,
6.5.1
specifying for separate precompilation,
2.5.1.2
what it affects,
C.8
MAXOPENCURSORS precompiler option,
10.5.32
metadata,
18.4.7
micro precompiler options,
10.2.3
migration
error message codes,
A.3.11
include files,
5.4.10
migration from earlier releases,
A.4
MODE interaction with DBMS,
10.5.14
MODE precompiler option,
10.5.33
modes, parameter,
7.1.4
multithreaded applications
sample program,
11.5
user-interface features
embedded SQL statements and directives,
11.4.2
N
N variable in SQLDA
how value is set,
15.3.1
purpose of,
15.3.1
naming
of cursors,
6.5.1
of database objects,
F.3.5
of select-list items,
15.2.1
of SQL*Forms user exits,
20.14.1
NATIVE
value of DBMS option,
10.5.14
native interface,
5.12
navigational access sample program,
17.11
nested tables,
18.1.1
creation,
18.1.1
network
communicating over,
3.2.1
protocols,
3.2.1
reducing traffic,
C.4
new features,
Preface
NLS parameters,
4.10
NLS_CURRENCY,
4.10
NLS_DATE_FORMAT,
4.10
NLS_DATE_LANGUAGE,
4.10
NLS_ISO_CURRENCY,
4.10
NLS_LANG,
4.10
NLS_LANGUAGE,
4.10
NLS_NUMERIC_CHARACTERS,
4.10
NLS_TERRITORY,
4.10
NLS_CHAR precompiler option,
10.5.34
,
10.5.35
NLS_LOCAL precompiler option,
10.5.36
node
current,
3.2.3
definition of,
3.2.1
NOT FOUND condition
in the WHENEVER statement,
9.8.1.3
meaning of,
9.8.1.3
of WHENEVER directive,
F.78
NOWAIT parameter
effect of,
3.11.2
in LOCK TABLE statements,
3.11.2
omitting,
3.11.2
NULLs
definition of,
2.1.5
detecting,
6.2
handling in dynamic SQL method 4,
15.4.3
hardcoding,
6.2.1
inserting,
6.2.1
restrictions on,
6.2.4
returning,
6.2.2
testing for,
6.2.4
using the sqlnul() function to test for,
15.4.3
null-terminated strings,
4.1.2.5.2
NUMBER datatype,
4.1.2.2
using the sqlprc() function with,
15.4.2.1
numeric expressions
cannot serve as host variables,
4.2.2.1
O
object cache,
17.3
OBJECT CREATE SQL statement,
17.5.3
,
F.59
OBJECT DELETE SQL statement,
17.5.6
,
F.60
OBJECT DEREF SQL statement,
17.5.4
,
F.61
OBJECT FLUSH SQL statement,
F.62
OBJECT FLUSH SQL statements,
17.5.8
OBJECT GET SQL statement,
17.6.2
,
F.63
OBJECT RELEASE SQL statement,
F.64
OBJECT SET SQL statement,
17.6.1
,
F.65
Object Type Translator (OTT),
A.2.10
command line,
19.2.3
command line syntax,
19.5.1
creating types in the database,
19.2.1
default name mapping,
19.5.7
outtype file,
19.2.8
parameters,
19.5.2
providing an intype file,
19.2.4
reference,
19.5
restriction,
19.5.8
using,
19
,
19.2
using with Pro*C/C++,
19.4
Object Types,
A.2.9
OBJECT UPDATE SQL statement,
17.5.7
,
F.66
objects
accessing with OCI,
19.3.1
introduction to,
17.1
manipulating with OCI,
19.3.1
persistent,
17.3.1
persistent versus transient copies of,
17.3.1
references to,
17.1.2
support,
17
transient,
17.3.1
types,
17.1.1
using object types in Pro*C/C++,
17.2
OBJECTS precompiler option,
10.5.21
,
10.5.37
,
17.8.3
OCI applications
using the OTT with,
19.3
OCI calls,
1.6.3
embedding,
5.10
in an X/A environment,
5.12.1.3
OCI onblon() call
not used to connect,
5.10
OCI orlon() call
not used to connect,
5.10
OCI Release 8,
5.8
accessing and manipulating objects,
19.3.1
embedding in Pro*C/C++,
5.9.3
interfacing to,
5.9
parameters in the environment handle,
5.8.2
SQLLIB extensions,
5.8
OCI types
declaring,
17.14.1
manipulating,
17.14.3
OCIDate,
17.14
OCINumber,
17.14
OCIRaw,
17.14
OCIString,
17.14
using in embedded SQL,
17.14.2
OCIDate,
17.14
declaring,
17.14.1
ocidfn.h,
5.10
OCINumber,
17.14
declaring,
17.14.1
OCIRaw,
17.14
declaring,
17.14.1
OCIString,
17.14
declaring,
17.14.1
ONAME precompiler option,
10.5.38
OPEN CURSOR statement,
14.5.11
OPEN DESCRIPTOR SQL statement,
F.68
OPEN SQL statement,
F.67
OPEN statement,
6.5.2
dependence on precompiler options,
6.5.2
effect of,
6.5.2
example of,
6.5.2
examples,
F.67
purpose of,
6.5
,
6.5.2
use in dynamic SQL method 3,
13.9.3
use in dynamic SQL method 4,
15.6.11
opening
a cursor variable,
4.5.3
cursors,
F.67
,
F.68
operators
C versus SQL,
2.3.12
restrictions on,
2.3.12
optimization approach,
C.5.1
optimizer hints,
C.5.1
in C,
6.7
in C++,
6.7.1
,
12.2.1
ORACA,
9.2.2
example of using,
9.10.6
using to gather cursor cache statistics,
9.10.5.11
ORACA precompiler option,
10.5.39
ORACAID component,
9.10.5.1
Oracle
datatypes,
2.1.6
Forms Version 4,
20.5
Open Gateway
using the ROWID datatype with,
4.1.2.9
Toolset,
20.5
Oracle Call Interface version 7,
5.10
Oracle Communications Area,
9.10
Oracle names
how to form,
F.3.5
Oracle Net
connecting to Oracle through,
3.2.2
connection syntax,
3.2.1
for concurrent connections,
3.2.2
function of,
3.2.1
OTT parameter TRANSITIVE,
19.5.2.12
OTT parameters
CASE,
19.5.2.10
CODE,
19.5.2.4
CONFIG,
19.5.2.8
ERRTYPE,
19.5.2.9
HFILE,
19.5.2.7
INITFILE,
19.5.2.5
INITFUNC,
19.5.2.6
INTYPE,
19.5.2.2
OUTTYPE,
19.5.2.3
SCHEMA_NAMES,
19.5.2.11
USERID,
19.5.2.1
where they appear,
19.5.3
OUT parameter mode,
7.1.4
output host variables
assigning values to,
6.1.1
definition of,
6.1.1
outtype file,
19.5.4
when running OTT,
19.2.8
OUTTYPE OTT parameter,
19.5.2.3
overhead
reducing,
C.2
P
PAGELEN
precompiler option,
10.5.40
parameter modes,
7.1.4
PARSE
precompiler option,
10.5.41
parse error offset
how to interpret,
9.5.4
use in error reporting,
9.5.4
parsing dynamic statements
PREPARE statement,
F.69
password
defining,
3.1
passwords
changing at runtime,
A.2.4
performance
eliminating extra parsing to improve,
C.8
optimizing SQL statements to improve,
C.5
reasons for poor,
C.1
using embedded PL/SQL to improve,
C.4
using HOLD_CURSOR to improve,
C.8.2.4
using host arrays to improve,
C.3
using indexes to improve,
C.6
using RELEASE_CURSOR to improve,
C.8.2.4
using row-level locking to improve,
C.7
persistent copies of objects,
17.3.1
persistent objects,
17.3.1
placeholders
duplicate,
13.8.1
,
13.12.2
naming,
13.8.1
proper order of,
13.8.1
use in dynamic SQL statements,
13.4
PL/SQL,
1.4
anonymous block
used to open a cursor variable,
4.5.3
cursor FOR loop,
7.1.3
description of,
1.4
difference from SQL,
1.4
executing a block using the AT clause,
3.2.4.1.2
integration with database server,
7.1.2
main advantage of,
1.4
packages,
7.1.5
PL/SQL tables,
7.1.6
procedures and functions,
7.1.4
RECORD type
cannot be bound to a C struct,
4.8.2
relationship with SQL,
1.4
setting SQLCA,
9.6.4
user-defined records,
7.1.7
PL/SQL blocks
embedded in precompiler programs,
F.32
pointer
definition of,
4.9
to cursor variables
restrictions on,
4.5.1
pointer variables
declaring,
4.9.1
determining size of referenced value,
4.9.2
referencing,
4.9.2
referencing struct members with,
4.9.2
precedence of precompiler options,
10.2.2
,
10.2.2
precision
definition of,
15.4.2.1
using sqlprc() to extract,
15.4.2.1
when not specified,
15.4.2.1
precompilation
conditional,
2.4
separate,
2.5
,
2.5
precompilation unit,
3.1
,
10.3
precompiled header files,
5.5
,
A.2.2
C++ restrictions,
5.5.4.2
CODE option,
5.5.4.2
,
5.5.4.2
PARSE option,
5.5.4.2
precompiler options
alphabetized list,
10.3
,
10.5
AUTO_CONNECT,
10.5.1
case sensitivity,
10.1.1
CHAR_MAP,
5.1.1
,
10.5.2
,
A.2.6
CLOSE_ON_COMMIT,
6.6.2
,
10.5.4
CODE,
10.5.8
,
10.5.8
COMP_CHARSET,
10.5.9
,
10.5.9
CONFIG,
10.5.3
,
10.5.5
,
10.5.6
,
10.5.7
,
10.5.10
,
10.5.11
,
10.5.13
configuration files,
10.2.1
CPP_SUFFIX,
10.5.12
,
10.5.12
DBMS,
10.5.14
DEF_SQLCODE,
10.5.15
DEFINE,
10.5.16
determining current value,
10.2.2
DURATION,
10.5.18
DYNAMIC,
14.4
entering,
10.4
entering on the command line,
10.4.1
ERRORS,
10.5.19
ERRTYPE,
10.5.20
FIPS,
10.5.22
HEADER,
10.5.23
HOLD_CURSOR,
10.5.23
,
10.5.24
INAME,
10.5.25
INCLUDE,
10.5.26
,
10.5.26
INTYPE,
10.5.27
LINES,
10.5.28
list of,
10.5
LNAME,
10.5.29
LTYPE,
10.5.30
MAXLITERAL,
2.3.11
,
10.5.31
MAXOPENCURSORS,
10.5.32
micro and macro,
10.2.3
MODE,
10.5.33
,
14.4
NLS_CHAR,
10.5.34
,
10.5.35
NLS_LOCAL,
10.5.36
OBJECTS,
10.5.21
,
10.5.37
ONAME,
10.5.38
ORACA,
10.5.39
PAGELEN,
10.5.40
PARSE,
10.5.41
precedence,
10.2.2
PREFETCH,
10.5.42
RELEASE_CURSOR,
10.5.43
scope,
10.2.5
scope of,
10.3
SELECT_ERROR,
10.5.44
specifying,
10.4.1
SQLCHECK,
10.5.45
,
17.8.6
syntax for,
10.4.1
SYS_INCLUDE,
10.5.46
THREADS,
10.5.47
,
11.4.1
TYPE_CODE,
10.5.48
,
14.4
UNSAFE_NULL,
10.5.49
USERID,
10.5.50
using,
10.5
VARCHAR,
10.5.52
VERSION,
10.5.53
predefined symbols,
2.4.1
PREFETCH precompiler option,
6.6.3
,
10.5.42
,
A.3.3
PREPARE SQL statement,
F.69
PREPARE statement,
14.5.5
effect on data definition statements,
13.6.2
examples,
F.69
use in dynamic SQL,
13.8
,
13.9.1
use in dynamic SQL method 4,
15.6.6
preprocessor
example,
5.6.2
EXEC ORACLE directives,
5.6
preprocessor directives
directives not supported by Pro*C,
5.4.2.1
preprocessor, support of,
4.1
private SQL area
association with cursors,
2.1.9
definition of,
2.1.9
opening of,
2.1.9
purpose of,
C.8.2.1
Pro*C/C++ Precompiler
common uses for,
1.2
Globalization Support,
4.10
new database types,
17.15
new features,
A
object support in,
17
runtime context,
5.8.1
use of PL/SQL with,
7.2
using OTT with,
19.4
procedural database extension,
7.1.5
program termination
normal versus abnormal,
3.9
programming guidelines,
2.3
Q
queries
association with cursors,
6.5
forwarding,
3.2.5.1
incorrectly coded,
6.3.1
kinds of,
6.3
requirements for,
6.3
returning more than one row,
6.3
single-row versus multirow,
6.3.1
R
RAW datatype,
4.1.2.11
READ ONLY parameter
in SET TRANSACTION statement,
3.10
read-only transactions
description of,
3.10
example of,
3.10
how ended,
3.10
record,
7.1.7
REF
structure for,
17.13.1
REF (reference to object),
17.1.2
REFERENCE clause
in TYPE statement,
5.3.2.1
reference semantics (ANSI dynamic SQL),
14.3.1
references to objects (REFs)
declaring,
17.13.2
using,
17.13
using in embedded SQL,
17.13.3
referencing
of host arrays,
8.2.1
,
8.3.1
REFs
declaring,
17.13.2
,
17.13.2
using,
17.13
,
17.13
using in embedded SQL,
17.13.3
REGISTER CONNECT SQL statement,
F.70
RELEASE option,
3.9
if omitted,
3.9
in COMMIT statement,
3.6
in ROLLBACK statement,
3.8
purpose of,
3.6
restriction on,
3.8
RELEASE_CURSOR
precompiler option
what it affects,
C.8
RELEASE_CURSOR option
of ORACLE Precompilers,
F.8
using to improve performance,
C.8.2.4
RELEASE_CURSOR precompiler option,
10.5.43
remote database
declaration of,
F.24
reserved namespaces,
B.2
reserved words and keywords,
B.1
resource manager,
5.12
restrictions
on AT clause,
3.2.4.1.3
on Comments,
13.12.4
on CURRENT OF clause,
6.8.1
on declaring cursors,
6.5.1
on FOR clause,
8.8.1
on host arrays,
8.3.3
,
8.4.7
,
8.5.1
,
8.6.1
,
8.7.1
on input host variables,
6.1.1
on NULLs,
6.2.4
on separate precompilation,
2.5.1.1
on SET TRANSACTION statement,
3.10
use of CURRENT OF clause,
8.3.3
retrieving rows from a table
embedded SQL,
F.73
return codes
user exits,
20.8
returning clause
DELETE,
6.3.4
in INSERT,
6.4
in UPDATE,
6.3.3
returning clauses,
6.4
roll back
to a savepoint,
F.72
to the same savepoint multiple times,
F.71
ROLLBACK SQL statement,
F.71
ROLLBACK statement,
3.8
effect of,
3.8
ending a transaction,
F.71
example of,
3.8
examples,
F.71
in error handling routines,
3.8
purpose of,
3.8
RELEASE option in,
3.8
TO SAVEPOINT clause in,
3.8
using in a PL/SQL block,
3.14.3
where to place,
3.8
rollbacks
automatic,
3.8
function of,
3.4
statement-level,
3.8.1
row locks
acquiring with FOR UPDATE OF,
3.11.1
advantage of,
C.7
using to improve performance,
C.7
when acquired,
3.11.1.1
when released,
3.11.1.1
ROWID
logical,
4.1.2.9
,
4.7
pseudocolumn,
3.12
using to mimic CURRENT OF,
3.12
,
8.11
pseudocolumns,
4.7
,
4.7
universal,
4.1.2.9
,
4.1.2.9
,
4.7
,
A.3.7
ROWID datatype,
4.1.2.9
rows
fetching from cursors,
F.36
,
F.37
inserting into tables and views,
F.40
updating,
F.76
rows-processed count
use in error reporting,
9.5.3
runtime context
establishing,
5.8.1
terminating,
5.8.1
runtime type checking,
17.8.7
S
S variable in SQLDA
how value is set,
15.3.7
purpose of,
15.3.7
sample database tables
DEPT table,
2.7
EMP table,
2.7
sample object type code,
17.11
sample programs
ansidyn1.pc,
14.6.1
ansidyn2.pc,
14.6.2
calldemo.sql, with sample9.pc,
7.7.2.1
coldemo1.pc,
18.5.5
cppdemo1.pc,
12.3.1
cppdemo2.pc,
12.3.2
cppdemo3.pc,
12.3.3
cursor variable demos,
4.5.7
cv_demo.pc,
4.5.7.2
cv_demo.sql,
4.5.7.1
extp1.pc,
7.8.2
how to precompile,
2.8
lobdemo1.pc,
16.6.3
navdemo1.pc,
17.11
oraca.pc,
9.10.6
,
9.10.6
sample10.pc,
15.7
sample11.pc,
4.5.7.2
sample12.pc,
15.6.20
sample1.pc,
2.8
sample2.pc,
4.8.5
sample3.pc,
8.4.5
sample4.pc,
5.3.5
sample5.pc,
20.11
sample6.pc,
13.7.1
sample7.pc,
13.8.2
sample8.pc,
13.9.6
sample9.pc,
7.7.2.1
sqlvcp.pc,
4.4.7
SAVEPOINT SQL statement,
F.72
SAVEPOINT statement,
F.72
example of,
3.7
examples,
F.72
purpose of,
3.7
savepoints
creating,
F.72
definition of,
3.7
uses for,
3.7
when erased,
3.7
Scale
using SQLPRC to extract,
F.77
scale
definition of,
15.4.2.1
,
F.77
using sqlprc() to extract,
15.4.2.1
when negative,
15.4.2.1
,
F.77
SCHEMA_NAMES OTT parameter,
19.5.2.11
usage,
19.5.6
scope
of a cursor variable,
4.5.1
of DECLARE STATEMENT directive,
F.25
of precompiler options,
10.3
of the EXEC ORACLE statement,
10.4.2.2
of WHENEVER statement,
9.8.5
search condition
definition of,
6.3.5
in the WHERE clause,
6.3.5
select descriptor,
15.2.1
,
15.2.1
information in,
13.10.2
select list
definition of,
6.3.1
number of items in,
6.3.1
using the free() function for,
15.6.17
using the malloc() function for,
15.6.14
SELECT SQL statement,
F.73
select SQLDA
purpose of,
15.1.3
SELECT statement,
6.3.1
clauses available for,
6.3.1.1
embedded SQL examples,
F.73
example of,
6.3.1
INTO clause in,
6.3.1
purpose of,
6.3.1
testing,
6.3.1.1
using host arrays in,
8.4
WHERE clause in,
6.3.1
SELECT_ERROR
precompiler option,
6.3.1
,
10.5.44
semantic checking
controlling with the SQLCHECK option,
D.2
definition of,
D.1
enabling,
D.3.1
with the SQLCHECK option,
D.1
separate precompilation
guidelines for,
2.5.1
referencing cursors for,
2.5.1.1
restrictions on,
2.5.1.1
specifying MAXOPENCURSORS for,
2.5.1.2
using a single SQLCA with,
2.5.1.3
server
integration with PL/SQL,
7.1.2
session
definition of,
3.3
sessions
beginning,
F.16
SET clause
in UPDATE statements,
6.3.3
purpose of,
6.3.3
use of subqueries in,
6.3.3
SET DESCRIPTOR statement,
14.5.4
,
F.74
SET TRANSACTION statement
example of,
3.10
purpose of,
3.10
READ ONLY parameter in,
3.10
requirements for,
3.10
restrictions on,
3.10
Size of an Integer and ROWID,
E.1.5
SQL
benefits of,
1.3
Embedded SQL,
1.3
nature of,
1.3
need for,
1.3
SQL Communications Area,
9.2.2
SQLCA,
9.6
SQL Descriptor Area
SQLDA,
13.10.1
,
15.2.1
SQL directives
CONTEXT USE,
11.4.2.3
,
F.21
DECLARE DATABASE,
F.24
DECLARE STATEMENT,
F.25
DECLARE TABLE,
F.26
DECLARE TYPE,
F.27
TYPE,
F.75
VAR,
F.77
WHENEVER,
F.78
SQL statements
ALLOCATE,
F.4
ALLOCATE DESCRIPTOR TYPE,
F.5
CACHE FREE ALL,
F.6
CALL,
7.7.2.3
,
F.7
CLOSE,
F.8
COMMIT,
F.15
concerns when executing,
6.3
CONNECT,
F.16
CONTEXT ALLOCATE,
F.17
,
F.17
CONTEXT FREE,
F.18
,
F.18
CONTEXT OBJECT OPTION GET,
F.19
CONTEXT OBJECT OPTION SET,
F.20
DEALLOCATE DESCRIPTOR,
F.22
DELETE,
F.28
DESCRIBE,
F.29
DESCRIBE DESCRIPTOR,
F.30
ENABLE THREADS,
F.31
executable versus directive,
2.1.1.1
EXECUTE,
F.33
EXECUTE ... END-EXEC,
F.32
EXECUTE IMMEDIATE,
F.35
FETCH,
F.36
FETCH DESCRIPTOR,
F.37
for defining and controlling transactions,
3.4
for manipulating a cursor,
6.3
,
6.5
FREE,
F.38
INSERT,
F.40
LOB APPEND,
F.41
LOB ASSIGN,
F.42
LOB CLOSE,
F.43
LOB COPY,
F.44
LOB CREATE,
F.45
LOB DESCRIBE,
F.46
LOB DISABLE BUFFERING,
F.47
LOB ENABLE BUFFERING,
F.48
LOB ERASE,
F.49
LOB FILE CLOSE,
F.50
LOB FILE SET,
F.51
LOB FLUSH BUFFER,
F.52
LOB FREE TEMPORARY,
F.53
LOB LOAD,
F.54
LOB OPEN,
F.55
LOB READ,
F.56
LOB TRIM,
F.57
LOB WRITE,
F.58
OBJECT CREATE,
F.59
OBJECT DELETE,
F.60
OBJECT DEREF,
F.61
OBJECT FLUSH,
F.62
OBJECT GET,
F.63
OBJECT RELEASE,
F.64
OBJECT SET,
F.65
OBJECT UPDATE,
F.66
OPEN,
F.67
OPEN DESCRIPTOR,
F.68
optimizing to improve performance,
C.5
PREPARE,
F.69
REGISTER CONNECT,
F.70
ROLLBACK,
F.71
rules for executing,
C.5
SAVEPOINT,
F.72
,
F.72
SELECT,
F.73
SET DESCRIPTOR,
F.74
summary of,
F.1
types of,
2.1.1.1
UPDATE,
F.76
SQL*Forms
display error screen in,
20.8
IAP constants in,
20.8.1
returning values to,
20.8
reverse return code switch in,
20.8
SQL*Net
connecting using Version 2,
3.1.2
SQL*Plus,
1.3
using to test SELECT statements,
6.3.1.1
versus embedded SQL,
1.3
SQL, dynamic,
2.1.3
SQL_CURSOR,
F.4
SQL_SINGLE_RCTX
defined constant,
5.11
definition of,
5.9
sqlald() function
example of using,
15.6.3
purpose of,
15.2.4
syntax for,
15.2.4
sqlaldt() function
see SQLSQLDAAlloc,
5.11
SQLCA,
9.2.2
,
9.5
components in,
9.6.3
components set for a PL/SQL block,
9.6.4
declaring,
9.6.1
description of,
9.6
explicit versus implicit checking of,
9.2.2
including multiple times,
5.4.7
overview of,
2.1.11
SQLCABC component in,
9.6.3.2
SQLCAID component in,
9.6.3.1
sqlerrd,
9.6.3.6
sqlerrd[2] component in,
9.6.3.6
sqlerrmc component in,
9.6.3.4
sqlerrml component in,
9.6.3.4
sqlwarn,
9.6.3.7
use in separate precompilations,
2.5.1.3
using more than one,
9.6
using with SQL*Net,
9.6
sqlca.h
listing of,
9.6.2
use of SQLCA_STORAGE_CLASS with,
2.5.1.3
SQLCAID component,
9.6.3.1
SQLCDAFromResultSetCursor(),
5.11
SQLCDAGetCurrent,
5.11
sqlcdat()
see SQLCDAFromResultSetCursor(),
5.11
SQLCHECK option
restrictions on,
D.2
usage notes for,
10.5.45
what it affects,
D.2
SQLCHECK precompiler option,
10.5.45
,
17.8.6
,
D.3.1.1
,
D.3.1.2
SQLCHECK support for objects,
17.8.6
sqlclu() function
example of using,
15.6.17
purpose of,
15.6.17
syntax for,
15.6.17
sqlclut() function
see SQLSQLDAFree(),
5.11
SQLCODE
with MODE=ANSI,
10.5.33
sqlcode
component in SQLCA,
9.2.2
,
9.5.1
SQLCODE status variable
declaring,
9.4
when declared with the SQLCA,
9.4
when used,
9.4
sqlcpr.h,
9.7
sqlcurt() function
see SQLDAToResultSetCursor(),
5.11
SQLDA
bind versus select,
13.10.3
C variable in,
15.3.9
definition of,
13.10.3
F variable in,
15.3.6
I variable in,
15.3.5
information stored in,
13.10.3
L variable in,
15.3.3
M variable in,
15.3.8
N variable in,
15.3.1
purpose of,
13.10.1
S variable in,
15.3.7
struct, contents of,
15.2.3
structure of,
15.3
T variable in,
15.3.4
use in dynamic SQL method 4,
15.2.1
V variable in,
15.3.2
X variable in,
15.3.10
Y variable in,
15.3.11
Z variable in,
15.3.12
sqlda.h,
15.1.3
SQLDAToResultSetCursor(),
5.11
SQLEnvGet function in SQLLIB,
5.9.1
SQLEnvGet(),
5.11
sqlerrd
component,
9.5.4
,
9.6.3.6
sqlerrd[2] component,
9.5.3
,
9.6.3.6
returns N or rows fetched,
8.4.3
use with data manipulation statements,
8.4.2
sqlerrm
component in the SQLCA,
9.2.2
sqlerrmc component,
9.6.3.4
sqlerrml component,
9.6.3.4
SQLERROR
WHENEVER directive condition,
F.78
SQLERROR condition
in the WHENEVER statement,
9.8.1.2
meaning of,
9.8.1.2
SQLErrorGetText(),
5.11
SQLExtProcError(),
5.11
,
7.8.3
sqlglm(),
9.7
sqlglm() function,
9.7
,
9.7
example of using,
9.7
parameters of,
9.7
sqlglmt()
see SQLErrorGetText,
5.11
sqlgls() function,
9.9
example of use,
4.4.7
sample program for,
9.9.2
see SQLLIB
function SQLStmGetText,
4.4.7
sqlglst() function
see SQLStmtGetText,
5.11
SQLIEM function
in user exits,
20.8.2
purpose of,
20.8.2
syntax for,
20.8.2
sqlld2() function,
5.12.1.3
sqlld2t() function
see SQLLDAGetName,
5.11
SQLLDAGetName,
5.11
sqlldat() function
see SQLCDAGetCurrent,
5.11
SQLLIB
and embedded SQL,
2.1.2
extensions for OCI interoperability,
5.8
function
SQLCDAFromResultSetCursor,
5.11
function SQLCDAGetCurrent,
5.11
function SQLColumnNullCheck,
5.11
function SQLDAFree,
5.11
function SQLDAToResultSetCursor,
5.11
function SQLEnvGet,
5.9.1
,
5.11
function SQLErrorGetText,
5.11
function SQLExtProcError,
5.11
,
7.8.3
function SQLLDAGetName,
5.11
function SQLNumberPrecV6,
5.11
function SQLNumberPrecV7,
5.11
function SQLRowidGet,
5.11
function SQLStmtGetText(),
5.11
function SQLSvcCtxGet,
5.9.2
,
5.11
function SQLVarcharGetLength,
4.4.6
new names for functions,
A.2.7
new names for public functions,
5.11
SQLLIB function
SQLSQLDAAlloc,
5.11
SQLVarcharGetLength,
5.11
sqlnul() function
example of using,
15.4.3
purpose of,
15.4.3
syntax for,
15.4.3
use of with T variable,
15.3.4
sqlnult() function
see SQLColumnNullCheck(),
5.11
SQLNumberPrecV6,
5.11
SQLNumberPrecV7,
5.11
sqlpr2() function,
15.4.2.1
sqlpr2t() function
see SQLNumberPrecV7,
5.11
sqlprc() function,
15.4.2.1
,
15.4.2.1
sqlprct() function
see SQLNumberPrecV6,
5.11
SQLRowidGet(),
5.11
SQLSQLDAAlloc,
5.11
SQLSQLDAFree(),
5.11
SQLSTATE
class codes,
9.3.2
declaring,
9.3.1
mapping to Oracle errors,
9.3.2
status codes,
9.3.2
status variable,
9.2.1
,
9.3
using,
9.3.3
values,
9.3.2
with MODE=ANSI,
10.5.33
SQLStmtGetText,
5.11
SQLSvcCtxGet function in SQLLIB,
5.9.2
SQLSvcCtxGet(),
5.11
SQLVarcharGetLength,
5.11
sqlvcp() function, see SQLLIB
function SQLVarcharGetLength,
4.4.6
sqlvcpt() function
see SQLVarcharGetLength,
5.11
sqlwarn
flag,
9.6.3.7
SQLWARNING
WHENEVER directive condition,
F.78
SQLWARNING condition
in the WHENEVER statement,
9.8.1.1
meaning of,
9.8.1.1
Standard Header Files,
E.1.1
statement-level rollback
description of,
3.8.1
to break deadlocks,
3.8.1
status codes
meaning of,
9.5.1
status variables,
9.2.1
STOP action
in the WHENEVER statement,
9.8.2.6
of WHENEVER directive,
F.78
result of,
9.8.2.6
stored procedures
program example,
7.7.2.1
stored subprograms
calling,
7.7.2.1
creating,
7.7.1
packaged versus standalone,
7.7
stored versus inline,
7.7
STRING datatype,
4.1.2.5
string host variables
declaring,
5.1.4
Struct Component Alignment,
E.1.4
structs
array of,
8.10
,
A.2.1
as host variables,
4.8
C, using,
17.12
for collection object types,
18.2
generating C structs for a REF,
17.13.1
pointers as host variables,
4.9.3
structs (structures)
cannot be nested,
4.8.3
structures (structs)
nesting not permitted for host,
4.8.3
subqueries
definition of,
6.3.2.1
example of,
6.3.2.1
,
6.3.3
uses for,
6.3.2.1
using in the SET clause,
6.3.3
using in the VALUES clause,
6.3.2.1
symbols
defining,
2.4.1
syntax checking
controlling with the SQLCHECK option,
D.2
definition of,
D.1
syntax diagram
description of,
F.3
how to read,
F.3
how to use,
F.3
symbols used in,
F.3
syntax, embedded SQL,
2.1.2
SYS_INCLUDE
system header files in C++,
12.2.4
SYS_INCLUDE precompiler option,
10.5.46
SYSDBA/SYSOPER Privileges,
A.3.8
System Configuration File,
E.1.10
system configuration file,
10.2.2
system failure
effect on transactions,
3.5
System Global Area (SGA),
7.7
system header files
specifying the location of,
12.2.4
system-specific Oracle documentation,
1.6.11
,
2.6
,
3.2.2
,
5.4.4
,
5.12.1.4
,
20
system-specific reference,
4.1.2.3
,
10.1.1
,
10.2.1
,
10.5.26
,
10.5.46
T
T variable in SQLDA
how value is set,
15.3.4
purpose of,
15.3.4
table locks
acquiring with LOCK TABLE,
3.11.2
effect of,
3.11.2
row share,
3.11.2
when released,
3.11.2
tables
inserting rows into,
F.40
nested,
18.1.1
updating rows in,
F.76
terminal
encoding scheme,
4.10
termination, program
normal versus abnormal,
3.9
THREADS
precompiler option,
10.5.47
,
11.4.1
threads,
F.17
allocating context,
11.4.2.2
,
F.17
enabling,
11.4.2.1
,
F.31
freeing context,
11.4.2.4
,
F.18
use context,
11.4.2.3
TIMESTAMP datatype,
4.1.3.3
TIMESTAMP WITH LOCAL TIME ZONE datatype,
4.1.3.5
TIMESTAMP WITH TIME ZONE datatype,
4.1.3.4
TO clause
of ROLLBACK statement,
F.71
TO SAVEPOINT clause
in ROLLBACK statement,
3.8
purpose of,
3.8
restriction on,
3.8
Toolset
Oracle,
20.5
trace facility
function of,
C.5.2
using to improve performance,
C.5.2
transaction processing
overview of,
2.1.10
statements used for,
2.1.10
transaction processing monitor,
5.12
transactions
committing,
F.15
contents of,
2.1.10
,
3.5
definition of,
2.1.10
description of,
3.4
distributed,
F.71
failure during,
3.5
guarding databases with,
3.4
guidelines for,
3.14.1
how to begin,
3.5
how to end,
3.5
making permanent,
3.6
read-only,
3.10
rolling back,
F.71
subdividing with savepoints,
3.7
terminating,
3.6
undoing,
3.8
undoing parts of,
3.7
when rolled back automatically,
3.5
,
3.8
transient copies of objects,
17.3.1
transient objects,
17.3.1
TRANSITIVE OTT parameter,
19.5.2.12
truncated values
detecting,
6.2
,
7.4.2
truncation error
when generated,
6.2.5
tuning, performance,
C.1
two-task
linking,
2.6
type checking at runtime,
17.8.7
TYPE directive
examples,
F.75
type inheritance,
17.1.3
example,
17.10
IS OF type operator,
17.1.3
example,
17.1.3
,
17.1.3
TREAT operator,
17.1.3
example,
17.1.3
,
17.1.3
TYPE SQL directive,
F.75
TYPE_CODE
precompiler option,
10.5.48
U
undo a transaction,
F.71
Unicode character set,
5.1.5
Unicode variables,
A.3.1
unions
cannot be nested in host structures,
4.8.3
not permitted as host structures,
4.8.3
universal ROWID,
4.1.2.9
,
4.7
,
A.3.7
UNIX
linking a Pro*C application under,
1.6.11
UNSAFE_NULL precompiler option,
10.5.49
UNSIGNED datatype,
4.1.2.14
UPDATE SQL statement,
F.76
UPDATE statement
embedded SQL examples,
F.76
example of,
6.3.2.1
purpose of,
6.3.2.1
SET clause in,
6.3.3
using host arrays in,
8.6
WHERE clause in,
6.3.3
updating
rows in tables and views,
F.76
use
thread context,
11.4.2.3
,
F.21
user configuration file
to set precompiler options,
10.2.2
User Exits,
E.1.13
user exits
calling from a SQL*Forms trigger,
20.6
common uses for,
20.2
example of,
20.9
kinds of statements allowed in,
20.4
linking into IAP,
20.13
meaning of codes returned by,
20.8
naming,
20.14.1
passing parameters to,
20.7
requirements for variables in,
20.4.1
running the GENXTB form,
20.12
running the GENXTB utility for,
20.12
use of WHENEVER statement in,
20.8.3
user session
definition of,
3.3
user-defined record,
7.1.7
user-defined stored function
used in WHERE clause,
6.3.5
user-defined type equivalencing,
F.75
USERID option
when required,
10.5.50
USERID OTT parameter,
19.5.2.1
USERID precompiler option,
10.5.50
using with the SQLCHECK option,
D.3.1.1
usernames
defining,
3.1
using C structures,
17.12
USING clause
in CONNECT statement,
3.2.4.1
in the EXECUTE statement,
13.8.1
of FETCH statement,
F.36
of OPEN statement,
F.67
purpose of,
13.8.1
using indicator variables in,
13.8.1
using collection types,
17.13
using dbstring
Oracle Net database specification string,
F.16
Using REFs in Embedded SQL,
17.13.3
V
V variable in SQLDA
how value is set,
15.3.2
purpose of,
15.3.2
V7
value of DBMS option,
10.5.14
VALUES clause
in INS,
6.3.2
of embedded SQL INSERT statement,
F.40
of INSERT statement,
F.40
use of subqueries in,
6.3.2.1
VAR directive
examples,
F.77
VAR SQL directive,
F.77
VAR statement
syntax for,
5.3.1
,
5.3.2
VARCHAR
arrays of,
8.2
VARCHAR datatype,
4.1.2.8
VARCHAR precompiler option,
10.5.52
VARCHAR pseudotype
requirements for using with PL/SQL,
7.3.3
VARCHAR variables
advantages of,
4.4.1
declaring,
4.4.1
length member in,
4.4.1
must be passed to a function by reference,
4.4.5
specifying the length of,
4.4.1
structure of,
4.4.1
using macros to define length of,
5.4.1
versus character arrays,
5.1.4.2
VARCHAR2 datatype,
4.1.2.1
,
5.3.3
variables,
2.1.5
cursor,
4.5
host,
18.2.1
indicator,
18.2.1
VARNUM datatype,
4.1.2.6
VARRAW datatype,
4.1.2.12
varrays
creation,
18.1.2
varying length arrays,
18.1.2
VERSION precompiler option,
10.5.53
,
17.8.1
views
inserting rows into,
F.40
updating rows in,
F.76
VMS
linking a precompiler application,
1.6.11
W
warning flags
use in error reporting,
9.5.2
WHENEVER directive
examples,
F.78
WHENEVER SQL directive,
F.78
WHENEVER statement
automatic checking of SQLCA with,
9.8.1
CONTINUE action in,
9.8.2.1
DO action in,
9.8.2.2
DO BREAK action in,
9.8.2.3
DO CONTINUE action in,
9.8.2.4
examples of,
9.8.3
GOTO action in,
9.8.2.5
guidelines for,
9.8.6
maintaining addressability for,
9.8.6.4
new actions,
A.2.8
NOT FOUND condition in,
9.8.1.3
overview of,
2.1.11
scope of,
9.8.5
SQLERROR condition in,
9.8.1.2
SQLWARNING condition in,
9.8.1.1
STOP action in,
9.8.2.6
use in user exits,
20.8.3
using to avoid infinite loops,
9.8.6.3
using to handle end-of-data conditions,
9.8.6.2
where to place,
9.8.6.1
WHERE clause
host arrays in,
8.9
if omitted,
6.3.5
in DELETE statements,
6.3.4
in SELECT statements,
6.3.1
in UPDATE statements,
6.3.3
purpose of,
6.3.5
search condition in,
6.3.5
WHERE CURRENT OF clause
CURRENT OF clause,
6.8
WORK option
of COMMIT statement,
F.15
of ROLLBACK statement,
F.71
X
X variable in SQLDA
how value is set,
15.3.10
purpose of,
15.3.10
XA interface,
5.12
X/Open,
5.12
application development,
5.12
Y
Y variable in SQLDA
how value is set,
15.3.11
purpose of,
15.3.11
Z
Z variable in SQLDA
how value is set,
15.3.12
purpose of,
15.3.12
Scripting on this page enhances content navigation, but does not change the content in any way.