Go to main content
36/36
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
.dsp files
1
.pre files
checking the paths
1
#include
file inclusion, Pro*C compared to C
1
A
abnormal termination
automatic rollback
1
active set
changing
1
,
2
cursor movement through
1
definition of
1
how identified
1
if empty
1
when fetched from
1
when no longer defined
1
ALLOCATE
allocating a cursor variable
1
ALLOCATE DESCRIPTOR statement
1
,
2
ALLOCATE SQL statement
1
ALLOCATE SQL statements
1
allocating
cursors
1
cursor variables
1
thread context
1
,
2
ANSI C Support
1
ANSI dynamic SQL
reference semantics
1
See also dynamic SQL (ANSI)
1
application development process
1
ARRAYLEN statement
1
array of structs
1
arrays
batch fetch
1
bulk operations (ANSI dynamic SQL)
1
chapter discusses how to use
1
definition of
1
host arrays
1
operations
1
varying length
1
associative interface
when to use
1
AT clause
in CONNECT statement
1
in DECLARE CURSOR statement
1
in DECLARE STATEMENT statement
1
in EXECUTE IMMEDIATE statement
1
of COMMIT statement
1
of DECLARE CURSOR directive
1
of EXECUTE IMMEDIATE statement
1
of EXECUTE statement
1
of INSERT statement
1
of SAVEPOINT statement
1
of SELECT statement
1
of SROLLBACK statement
1
of UPDATE statement
1
restriction on
1
use of
1
attributes of a collection
descriptions
1
AUTO_CONNECT
precompiler option
1
AUTO_CONNECT precompiler option
1
automatic connections
1
,
2
B
batch fetch
advantage of
1
example of
1
number of rows returned by
1
BFILES
security
1
bind descriptor
definition of
1
information in
1
binding
definition of
1
bind SQLDA
purpose of
1
bind variables
input host variables
1
BREAK action
of WHENEVER
1
Byte Ordering
1
C
C++
1
C++ applications
1
cache
1
CACHE FREE ALL SQL statement
1
CACHE FREE ALL statement
1
CALL SQL statement
1
CALL statement
example
1
CASE OTT parameter
1
case sensitivity
in precompiler options
1
CHAR_MAP precompiler option
1
,
2
character data
1
character strings
multibyte
1
CHAR datatype
1
CHARF datatype
1
,
2
CHARZ datatype
1
CLOSE_ON_COMMIT
precompiler option
1
,
2
,
3
CLOSE_ON_COMMIT precompiler option
1
CLOSE CURSOR statement
1
CLOSE SQL statements
1
CLOSE statement
dependence on precompiler options
1
example
1
,
2
purpose of
1
,
2
use in dynamic SQL method 4
1
closing
cursors
1
CODE
precompiler option
1
CODE option
1
CODE OTT parameter
1
code page
1
CODE precompiler option
1
coding conventions
1
COLLECT GET statement
example
1
COLLECTION APPEND
1
COLLECTION APPEND statement
SQL statements
COLLECTION APPEND
1
COLLECTION DESCRIBE
example
1
COLLECTION DESCRIBE statement
SQL statements
COLLECTION DESCRIBE
1
COLLECTION GET statement
SQL statements
COLLECTION GET
1
collection object types
handling
1
COLLECTION RESET statement
example
1
SQL statements
COLLECTION RESET
1
collections
and C
1
autonomous access
1
descriptors
1
element access
1
manipulating
1
nested tables
1
OBJECT GET statement
1
OBJECT SET statement
1
VARRAYs
1
COLLECTION SET statement
example
1
SQL statements
COLLECTION SET
1
COLLECTION TRIM statement
SQL statements
COLLECTION TRIM
1
collection types
structs for
1
column list
in INSERT statements
1
when permissible to omit
1
COMMENT clause
of COMMIT statement
1
comments
ANSI
1
which allowed
1
Comments
restrictions in PL/SQL block
1
commit
automatic
1
explicit versus implicit
1
function of
1
COMMIT SQL statement
1
COMMIT statement
effect of
1
ending a transaction
1
example of
1
examples
1
purpose of
1
RELEASE option in
1
using in a PL/SQL block
1
where to place
1
committing
transactions
1
communicating over a network
1
COMP_CHARSET precompiler option
1
,
2
compiling
specifying include file locations
1
concurrency
definition of
1
concurrent connections
1
conditional precompilation
defining symbols
1
example
1
,
2
CONFIG OTT parameter
1
CONFIG precompiler option
1
,
2
,
3
,
4
,
6
configuration files
and the Object Type Translator
1
location
1
,
2
system
1
user
1
connecting to Oracle
automatic connections
1
concurrently
1
example of
1
using Oracle Net
1
connection pooling
demo program1
1
demo program2
1
example
1
using
1
connections
concurrent
1
default versus nondefault
1
Explicit connections
1
implicit
1
naming of
1
CONNECT statement
AT clause in
1
connecting to Oracle with
1
examples
1
requirements for
1
USING clause in
1
using to enable a semantic check
1
const
declaring constants
1
CONTEXT ALLOCATE SQL statement
1
CONTEXT ALLOCATE statement
1
context block
definition of
1
CONTEXT FREE statement
1
,
2
CONTEXT OBJECT OPTION GET SQL statement
1
CONTEXT OBJECT OPTION SET SQL statement
1
CONTEXT USE directive
1
CONTEXT USE SQL directive
1
CONTEXT USE SQL statement
1
CONTINUE action
in the WHENEVER statement
1
of WHENEVER directive
1
result of
1
CONVBUFSZ clause
1
CPP_SUFFIX
precompiler option
1
CPP_SUFFIX precompiler option
1
CPP_SUFFIX precompiler options
1
C preprocessor
directives supported by Pro*C
1
how used in Pro*C
1
CREATE PROCEDURE statement
embedded
1
creating
savepoints
1
creating temporary LOB
1
C structs
generating for a REF
1
using
1
C types of collection attributes
1
CURRENT OF clause
example of
1
mimicking with ROWID
1
,
2
purpose of
1
restrictions on
1
current row
definition of
1
using FETCH to retrieve
1
cursor cache
definition of
1
purpose of
1
cursor control statements
example of typical sequence
1
cursor operations
overview of
1
cursors
allocating
1
allocating a cursor variable
1
analogy for
1
association with queries
1
closing
1
declaring
1
definition of
1
explicit versus implicit
1
fetching rows from
1
,
2
for multirow queries
1
how handling affects performance
1
movement through active set
1
opening
1
,
2
purpose of
1
reopening
1
,
2
restrictions on declaring
1
rules for naming
1
scope of
1
scrollable cursors
1
statements for manipulating
1
types of
1
using more than one
1
cursor variables
allocating
1
declaring
1
restrictions on
1
C variable in SQLDA
how value is set
1
purpose of
1
D
database link
creating synonym for
1
defining
1
example using
1
using in INSERT statement
1
where stored
1
databases
naming
1
database types
new
1
data definition language
in transactions
1
data integrity
definition of
1
data locks
1
datatype equivalencing
1
datatypes
ANSI DATE
1
codes used in descriptors
1
coercing NUMBER to VARCHAR2
1
conversions
1
dealing with ORACLE internal
1
equivalencing
1
equivalencing, purpose of
1
internal
1
internal versus external
1
INTERVAL DAY TO SECOND
1
INTERVAL YEAR TO MONTH
1
list of internal
1
need to coerce
1
Oracle
1
OTT mappings
1
restrictions on using
1
TIMESTAMP
1
TIMESTAMP WITH LOCAL TIME ZONE
1
TIMESTAMP WITH TIME ZONE
1
user-defined type equivalencing
1
when to reset
1
DATE, ANSI
datatype
1
DATE datatype
1
datetime
avoiding unexpected results
1
DBMS interaction with MODE
1
DBMS option
1
,
2
DBMS precompiler option
1
,
2
deadlock
definition of
1
effect on transactions
1
how broken
1
DEALLOCATE DESCRIPTOR statement
1
,
2
declaration
of cursors
1
of host arrays
1
of pointer variables
1
of SQLCA
1
declarative SQL statements
in transactions
1
DECLARE CURSOR directives
examples
1
DECLARE CURSOR statement
AT clause in
1
use in dynamic SQL method 4
1
DECLARE DATABASE SQL directives
1
Declare Section
allowable statements
1
form
1
purpose
1
required when MODE=ANSI
1
requirements
1
rules for defining
1
when MODE=ANSI
1
when required
1
,
2
DECLARE statement
example of
1
purpose of
1
required placement of
1
scope of
1
use in dynamic SQL method 3
1
DECLARE STATEMENT directive
1
DECLARE statements
examples
1
DECLARE STATEMENT statement
AT clause in
1
example of using
1
using with dynamic SQL
1
when required
1
DECLARE TABLE directive
examples
1
using with the SQLCHECK option
1
DECLARE TABLE SQL directive
1
DECLARE TABLE statement
need for with AT clause
1
DECLARE TYPE directive
1
DEF_SQLCODE precompiler option
1
default connections
1
default database
1
default file name extensions
1
DEFINE precompiler option
used in application migration
1
defining symbols
1
DELETE SQL statement
1
DELETE statement
embedded SQL examples
1
example of
1
purpose of
1
using host arrays in
1
WHERE clause in
1
delimiters
C versus SQL
1
DEPT table
1
DESCRIBE BIND VARIABLES statement
use in dynamic SQL method 4
1
DESCRIBE command
use with PREPARE command
1
DESCRIBE DESCRIPTOR statement
1
DESCRIBE INPUT statement
1
DESCRIBE OUTPUT statement
1
DESCRIBE SELECT LIST statement
use in dynamic SQL method 4
1
DESCRIBE SQL statement
1
DESCRIBE statement
examples
1
use in dynamic SQL Method 4
1
descriptions of collection attributes
1
descriptors
bind descriptor
1
definition of
1
need for
1
select descriptor
1
using the sqlald() function to allocate
1
using the sqlclu() function to deallocate
1
determining current value of precompiler options
1
directory structures
1
distributed processing
support for
1
using Oracle Net for
1
distributed transactions
1
DML returning clauses
1
DO action
in the WHENEVER statement
1
of WHENEVER directive
1
result of
1
DTP model
1
dummy host variables
placeholders
1
DURATION precompiler option
1
,
2
Dynamic Link Libraries (DLLs)
1
dynamic PL/SQL
rules for
1
versus dynamic SQL
1
dynamic SQL
advantages and disadvantages of
1
cannot use cursor variables with
1
choosing the right method
1
definition of
1
guidelines for
1
method 1
1
method 2
1
method 3
1
method 4
1
overview of
1
restriction on
1
restrictions on use of datatypes
1
restrictions on using datatypes in
1
use of PL/SQL with
1
uses for
1
using the AT clause in
1
when to use
1
dynamic SQL (ANSI)
basics
1
bulk operations
1
differences from Oracle dynamic
1
Oracle extensions
1
Overview
1
precompiler options
1
Precompiler Options
1
reference semantics
1
sample program
1
sample programs
1
dynamic SQL method 1
commands used with
1
description of
1
example of
1
how to use
1
requirements for
1
use of EXECUTE IMMEDIATE with
1
use of PL/SQL with
1
dynamic SQL method 2
commands used with
1
description of
1
example of
1
requirements for
1
use of DECLARE STATEMENT with
1
use of EXECUTE with
1
use of PL/SQL with
1
use of PREPARE with
1
dynamic SQL method 3
commands used with
1
compared to method 2
1
example program
1
requirements for
1
sequence of statements used with
1
use of DECLARE STATEMENT with
1
use of DECLARE with
1
use of FETCH with
1
use of OPEN with
1
use of PL/SQL with
1
use of PREPARE with
1
dynamic SQL method 4
need for descriptors with
1
overview of
1
prerequisites for using
1
requirements for
1
requirements of
1
sample program
1
sequence of statements used with
1
,
2
steps for
1
use of CLOSE statement in
1
use of DECLARE CURSOR statement in
1
use of DECLARE STATEMENT with
1
use of DESCR
1
use of DESCRIBE statement in
1
,
2
use of descriptors with
1
use of FETCH statement in
1
use of OPEN statement in
1
use of PL/SQL with
1
use of PREPARE statement in
1
use of the SQLDA in
1
,
2
using host arrays with
1
using the FOR clause with
1
,
2
when needed
1
dynamic SQL methods
overview of
1
dynamic SQL statements
binding of host variables in
1
definition of
1
requirements for
1
use of placeholders in
1
using host arrays in
1
versus static SQL statements
1
E
embedded PL/SQL
advantages of
1
cursor FOR loop
1
example of
1
,
2
overview of
1
packages
1
PL/SQL tables
1
procedures and functions
1
requirements for
1
SQLCHECK option
1
support for SQL
1
user-defined records
1
using %TYPE
1
using the VARCHAR pseudotype with
1
using to improve performance
1
where allowed
1
embedded SQL
ALLOCATE statement
1
CLOSE statement
1
CONTEXT ALLOCATE statement
1
,
2
CONTEXT FREE statement
1
definition of
1
difference from interactive SQL
1
ENABLE THREADS statement
1
EXEC SQL CACHE FREE ALL
1
EXECUTE statement
1
key concepts of
1
mixing with host-language statements
1
OPEN statement
1
overview of
1
PREPARE statement
1
requirements for
1
SAVEPOINT statement
1
SELECT statement
1
syntax for
1
testing with SQL*Plus
1
TYPE directive
1
UPDATE statement
1
using OCI types in
1
using REFs in
1
VAR directive
1
WHENEVER directive
1
when to use
1
embedded SQL statements
labels for
1
referencing host arrays in
1
referencing host variables in
1
suffixes and prefixes not allowed
1
terminator for
1
use of apostrophes in
1
use of quotation marks in
1
embedding
PL/SQL blocks in precompiler programs
1
EMP table
1
ENABLE THREADS SQL statement
1
ENABLE THREADS statement
1
enabling
threads
1
encoding scheme (character set or code page)
1
enqueues
locking
1
entering options
1
,
2
environment variables
1
equivalencing
host variable equivalencing
1
user-defined type equivalencing
1
equivalencing of datatypes
datatype equivalencing
1
error detection
error reporting
1
error handling
alternatives
1
need for
1
overview of
1
SQLCA versus WHENEVER statement
1
use of ROLLBACK statement in
1
error messages
maximum length of
1
use in error reporting
1
using the sqlglm() function to get
1
where available in SQLCA
1
error reporting
key components of
1
use of error messages in
1
use of parse error offset in
1
use of rows-processed count in
1
use of warning flags in
1
WHENEVER directive
1
ERRORS precompiler option
1
ERRTYPE
precompiler option
1
ERRTYPE OTT parameter
1
ERRTYPE precompiler option
1
exception, PL/SQL
definition of
1
EXEC ORACLE DEFINE statement
1
EXEC ORACLE ELSE statement
1
,
2
EXEC ORACLE ENDIF statement
1
,
2
EXEC ORACLE IFDEF statement
1
,
2
EXEC ORACLE IFNDEF statement
1
,
2
EXEC ORACLE OPTION statement
set option values inline
1
EXEC ORACLE statement
scope of
1
syntax for
1
uses for
1
EXEC ORACLE statements
1
EXEC SQL CACHE FREE statement
1
EXEC SQL clause
using to embed SQL
1
EXEC SQL INCLUDE
contrasted with #include
1
EXEC SQL VAR statement
CONVBUFSZ clause
1
EXEC TOOLS
GET CONTEXT statement
1
GET statement
1
MESSAGE statement
1
SET CONTEXT statement
1
SET statement
1
EXEC TOOLS statements
1
executable SQL statements
purpose of
1
uses for
1
where allowed
1
EXECUTE ... END-EXEC SQL statement
1
EXECUTE DESCRIPTOR statement
SQL statements
EXECUTE DESCRIPTOR
1
EXECUTE IMMEDIATE SQL statement
1
EXECUTE IMMEDIATE statement
AT clause in
1
examples
1
use in dynamic SQL method 1
1
EXECUTE optional keyword of ARRAYLEN statement
1
EXECUTE SQL statement
1
EXECUTE statement
examples
1
,
2
use in dynamic SQL method 2
1
execution of statements
1
execution plan
1
,
2
EXPLAIN PLAN statement
function of
1
using to improve performance
1
explicit connections
description of
1
multiple
1
single
1
extensions
default file name
1
external datatypes
definition of
1
FLOAT
1
INTEGER
1
STRING
1
external procedures
callbacks
1
calling from PL/SQL
1
creating
1
error-handling
1
restrictions
1
F
FAQs
1
FETCH DESCRIPTOR SQL statement
1
fetching
rows from cursors
1
,
2
fetching in batches
batch fetch
1
FETCH SQL statement
1
FETCH statement
example of
1
examples
1
INTO clause in
1
purpose of
1
,
2
results of
1
used after OPEN command
1
used after OPEN statement
1
use in dynamic SQL method 3
1
use in dynamic SQL method 4
1
FIPS flagger
warns of array usage
1
warns of missing Declare Section
1
warns of use of pointers as host variables
1
FIPS precompiler option
1
flags
warning flags
1
FLOAT datatype
1
FORCE clause
of COMMIT statement
1
of ROLLBACK statement
1
FOR clause
example of using
1
of embedded SQL EXECUTE DESCRIPTOR statement
1
of embedded SQL EXECUTE statement
1
purpose of
1
requirements for
1
restrictions on
1
using in dynamic SQL method 4
1
using with host arrays
1
when variable negative or zero
1
FOR UPDATE OF clause
locking rows with
1
purpose of
1
when to use
1
forward references
why not allowed
1
free() function
example of using
1
freeing
thread context
1
,
2
FREE SQL statement
1
,
2
Frequently Asked Questions
1
full scan
description of
1
function prototype
definition of
1
functions
cannot serve as host variables
1
F variable in SQLDA
how value is set
1
purpose of
1
G
generic documentation references
default values for options
1
header files, location of
1
linking
1
GENXTB form
how to run
1
use with user exits
1
GENXTB utility
how to run
1
use with user exits
1
GET DESCRIPTOR statement
1
Globalization Support
1
GOTO action
in the WHENEVER statement
1
of WHENEVER directive
1
result of
1
guidelines
for dynamic SQL
1
for separate precompilations
1
for the WHENEVER statement
1
for transactions
1
H
header files
location of
1
HEADER precompiler option
1
,
2
heap
definition of
1
HFILE OTT parameter
1
hints
COST
1
for the ORACLE SQL statement optimizer
1
in DELETE statements
1
in SELECT statements
1
in UPDATE statements
1
HOLD_CURSOR
precompiler option
used to improved performance
1
what it affects
1
HOLD_CURSOR option
of ORACLE Precompilers
1
HOLD_CURSOR precompiler option
1
host arrays
advantages of
1
declaring
1
dimensioning
1
in the DELETE statement
1
in the INSERT statement
1
in the SELECT statement
1
in the UPDATE statement
1
in the WHERE clause
1
matching sizes of
1
referencing
1
,
2
restrictions on
1
,
2
,
3
,
4
,
5
used as input host variables
1
used as output host variables
1
using in dynamic SQL method 4
1
using in dynamic SQL statements
1
using the FOR clause with
1
using to improve performance
1
when not allowed
1
host language
definition of
1
,
2
host program
definition of
1
host structures
arrays in
1
declaring
1
host variables
assigning values to
1
declarations
1
declaring
1
,
2
definition of
1
dummy
1
host variable equivalencing
1
in EXECUTE statement
1
in OPEN statement
1
input versus output
1
in user exits
1
must resolve to an address
1
overview of
1
purpose of
1
restrictions on
1
rules for naming
1
using in PL/SQL
1
I
IAP in SQL*Forms
purpose of
1
identifiers, ORACLE
how to form
1
implicit connections
multiple
1
single
1
INAME precompiler option
1
INCLUDE
precompiler option, use of
1
using to include the SQLCA
1
INCLUDE, SYS_INCLUDE Precompiler Options
1
INCLUDE option
1
INCLUDE precompiler option
1
indexes
using to improve performance
1
indicator arrays
example of using
1
uses for
1
INDICATOR keyword
1
indicator variables
assigning values to
1
association with host variables
1
declarations
1
declaring
1
,
2
definition of
1
function of
1
guidelines
1
interpreting values of
1
naming of
1
referencing
1
requirements for
1
used with multibyte character strings
1
using in PL/SQL
1
using to detect NULLs
1
using to detect truncated values
1
using to insert NULLs
1
using to return NULLs
1
using to test for NULLs
1
with structures
1
in-doubt transaction
1
INITFILE OTT parameter
1
INITFUNC OTT parameter
1
initialization function
calling
1
tasks of
1
IN OUT parameter mode
1
IN parameter mode
1
input host variables
assigning values to
1
definition of
1
restrictions on
1
uses for
1
where allowed
1
inserting
rows into tables and views
1
INSERT SQL statement
examples
1
INSERT statement
column list in
1
example of
1
INTO clause in
1
purpose of
1
requirements for
1
using host arrays in
1
VALUES clause in
1
INTEGER datatype
1
interface
native
1
XA
1
internal datatypes
definition of
1
INTERVAL DAY TO SECOND datatype
1
INTERVAL YEAR TO MONTH datatype
1
INTO clause
for output host variables
1
in FETCH statements
1
in INSERT statements
1
in SELECT statements
1
of FETCH DESCRIPTOR statement
1
of FETCH statement
1
of SELECT statement
1
used with FETCH instead of SELECT
1
intype file
providing when running OTT
1
structure of
1
INTYPE OTT parameter
1
INTYPE precompiler option
1
invalid use
of precompiler preprocessor
1
I variable in SQLDA
how value is set
1
purpose of
1
J
joins
restriction on
1
L
label name
maximum length of
1
large objects
1
LDA
remote and multiple connections
1
setup for OCI version 8
1
lines
continuation
1
maximum length
1
LINES precompiler option
1
link
database link
1
linking
on UNIX
1
on VMS
1
two-task
1
Linking in an XA Library
1
LNAME precompiler option
1
LNPROC
VMS link script
1
LOB APPEND SQL statement
1
LOB APPEND statement
1
LOB ASSIGN SQL statement
1
LOB ASSIGN statement
1
LOB CLOSE SQL statement
1
LOB CLOSE statement
1
LOB COPY SQL statement
1
LOB COPY statement
1
LOB CREATE TEMPORARY SQL statement
1
LOB CREATE temporary statement
1
LOB DESCRIBE SQL statement
1
LOB DISABLE BUFFERING SQL statement
1
LOB DISABLE BUFFERING statement
1
LOB ENABLE BUFFERING SQL statement
1
LOB ENABLE BUFFERING statement
1
LOB ERASE SQL statement
1
LOB ERASE statement
1
LOB FILE CLOSE ALL SQL statement
1
LOB file close all statement
1
LOB FILE CLOSE ALL statement
1
LOB FILE SET SQL statement
1
LOB FILE SET statement
1
LOB FLUSH BUFFER SQL statement
1
LOB FLUSH BUFFER statement
1
LOB FREE TEMPORARY SQL statement
1
LOB FREE TEMPORARY statement
1
LOB LOAD FROM FILE statement
1
LOB LOAD SQL statement
1
LOB OPEN SQL statement
1
LOB OPEN statement
1
LOB READ SQL statement
1
LOB READ statement
1
LOBs
access methods
1
buffering system
1
external
1
initializing
1
internal
1
locators
1
locators in C
1
temporary
1
LOB TRIM SQL statement
1
LOB WRITE SQL statement
1
Location of Included Files
1
location of the Pro*C/C++ Executable
1
location transparency
how provided
1
lock
released by ROLLBACK statement
1
locking
definition of
1
explicit versus implicit
1
modes of
1
overriding default
1
privileges needed to obtain
1
table versus row
1
uses for
1
with FOR UPDATE OF
1
with the LOCK TABLE statement
1
LOCK TABLE statement
closes mall cursors
1
example of
1
locking tables with
1
NOWAIT parameter in
1
purpose of
1
logon
1
Logon Data Area
1
LONG datatype
1
LONG RAW datatype
1
LONG VARCHAR
datatype
1
LONG VARRAW datatype
1
LTYPE precompiler option
1
lvalue
1
L variable in SQLDA
how value is set
1
purpose of
1
M
macro precompiler options
1
malloc()
example of using
1
purpose of
1
MAXLITERAL
default value for
1
MAXLITERAL precompiler option
1
MAXOPENCURSORS
precompiler option
effect on performance
1
for multiple cursors
1
specifying for separate precompilation
1
what it affects
1
MAXOPENCURSORS precompiler option
1
MEMFORPREFETCH precompiler option
1
metadata
1
micro precompiler options
1
Microsoft Visual Studio
integrating Pro*C/C++ into
1
migration
include files
1
MODE interaction with DBMS
1
MODE precompiler option
1
modes, parameter
1
msvcrt.lib runtime library
1
multithreaded applications
sample program
1
user-interface features
embedded SQL statements and directives
1
M variable in SQLDA
how value is set
1
purpose of
1
N
naming
of cursors
1
of database objects
1
of select-list items
1
of SQL*Forms user exits
1
NATIVE
value of DBMS option
1
,
2
native interface
1
navigational access sample program
1
nested tables
creation
1
network
communicating over
1
protocols
1
reducing traffic
1
NLS_CHAR precompiler option
1
,
2
NLS_LOCAL precompiler option
1
NLS parameters
NLS_CURRENCY
1
NLS_DATE_FORMAT
1
NLS_DATE_LANGUAGE
1
NLS_ISO_CURRENCY
1
NLS_LANG
1
NLS_LANGUAGE
1
NLS_NUMERIC_CHARACTERS
1
NLS_TERRITORY
1
node
current
1
definition of
1
NOT FOUND condition
in the WHENEVER statement
1
meaning of
1
of WHENEVER directive
1
NOWAIT parameter
effect of
1
in LOCK TABLE statements
1
omitting
1
NULLs
definition of
1
detecting
1
handling in dynamic SQL method 4
1
hardcoding
1
inserting
1
restrictions on
1
returning
1
testing for
1
using the sqlnul() function to test for
1
null-terminated strings
1
NUMBER datatype
using the sqlprc() function with
1
numeric expressions
cannot serve as host variables
1
N variable in SQLDA
how value is set
1
purpose of
1
O
object cache
1
OBJECT CREATE SQL statement
1
,
2
OBJECT DELETE SQL statement
1
,
2
OBJECT DEREF SQL statement
1
,
2
OBJECT FLUSH SQL statement
1
OBJECT FLUSH SQL statements
1
OBJECT GET SQL statement
1
,
2
OBJECT RELEASE SQL statement
1
objects
accessing with OCI
1
demonstration program
1
introduction to
1
manipulating with OCI
1
persistent
1
persistent versus transient copies of
1
references to
1
support
1
transient
1
types
1
using object types in Pro*C/C++
1
OBJECT SET SQL statement
1
,
2
OBJECTS precompiler option
1
,
2
Object Type Translator (OTT)
command line
1
command line syntax
1
creating types in the database
1
default name mapping
1
outtype file
1
parameters
1
providing an intype file
1
reference
1
restriction
1
using
1
,
2
using with Pro*C/C++
1
OBJECT UPDATE SQL statement
1
,
2
OCI applications
using the OTT with
1
OCI calls
embedding
1
in an X/A environment
1
OCIDate
declaring
1
ocidfn.h
1
OCINumber
declaring
1
OCI onblon() call
not used to connect
1
OCI orlon() call
not used to connect
1
OCIRaw
declaring
1
OCI Release 8
accessing and manipulating objects
1
embedding in Pro*C/C++
1
interfacing to
1
parameters in the environment handle
1
SQLLIB extensions
1
OCIString
declaring
1
OCI types
declaring
1
manipulating
1
OCIDate
1
OCINumber
1
OCIRaw
1
OCIString
1
using in embedded SQL
1
ONAME precompiler option
1
OPEN CURSOR statement
1
OPEN DESCRIPTOR SQL statement
1
opening
a cursor variable
1
cursors
1
,
2
OPEN SQL statement
1
OPEN statement
dependence on precompiler options
1
effect of
1
example of
1
examples
1
purpose of
1
,
2
use in dynamic SQL method 3
1
use in dynamic SQL method 4
1
operators
C versus SQL
1
restrictions on
1
optimization approach
1
optimizer hints
in C
1
in C++
1
,
2
ORACA
example of using
1
using to gather cursor cache statistics
1
ORACAID component
1
ORACA precompiler option
1
,
2
,
3
,
4
,
5
,
6
Oracle
datatypes
1
Forms Version 4
1
Open Gateway
using the ROWID datatype with
1
Toolset
1
Oracle Call Interface version 7
1
Oracle Communications Area
1
Oracle names
how to form
1
Oracle Net
connecting to Oracle through
1
connection syntax
1
for concurrent connections
1
function of
1
Oracle Net Services
connecting
1
orasql9.lib
1
orasql9.lib library file
1
OTT (Object Type Translator)
1
OTT parameters
CASE
1
CODE
1
CONFIG
1
ERRTYPE
1
HFILE
1
INITFILE
1
INITFUNC
1
INTYPE
1
OUTTYPE
1
SCHEMA_NAMES
1
USERID
1
where they appear
1
OTT parameter TRANSITIVE
1
OUT parameter mode
1
output host variables
assigning values to
1
definition of
1
outtype file
when running OTT
1
OUTTYPE OTT parameter
1
overhead
reducing
1
P
PAGELEN
precompiler option
1
parameter modes
1
PARSE
precompiler option
1
parse error offset
how to interpret
1
use in error reporting
1
PARSE option
1
parsing dynamic statements
PREPARE statement
1
password
defining
1
paths
checking
1
checking the .pre files
1
pcscfg.cfg configuration file
1
performance
eliminating extra parsing to improve
1
optimizing SQL statements to improve
1
reasons for poor
1
using embedded PL/SQL to improve
1
using HOLD_CURSOR to improve
1
using host arrays to improve
1
using indexes to improve
1
using RELEASE_CURSOR to improve
1
using row-level locking to improve
1
persistent copies of objects
1
persistent objects
1
PL/SQL
anonymous block
used to open a cursor variable
1
cursor FOR loop
1
description of
1
difference from SQL
1
executing a block using the AT clause
1
integration with database server
1
main advantage of
1
packages
1
PL/SQL tables
1
procedures and functions
1
RECORD type
cannot be bound to a C struct
1
relationship with SQL
1
setting SQLCA
1
user-defined records
1
PL/SQL blocks
embedded in precompiler programs
1
placeholders
duplicate
1
,
2
naming
1
proper order of
1
use in dynamic SQL statements
1
PLAN_BASELINE
precompiler option
1
PLAN_ENABLED
precompiler option
1
PLAN_FIXED
precompiler option
1
PLAN_PREFIX
precompiler option
1
PLAN_RUN
precompiler option
1
pointer
definition of
1
to cursor variables
restrictions on
1
pointer variables
declaring
1
determining size of referenced value
1
referencing
1
referencing struct members with
1
precedence of precompiler options
1
precision
definition of
1
using sqlprc() to extract
1
when not specified
1
precompilation
conditional
1
separate
1
precompilation unit
1
,
2
precompiled header files
C++ restrictions
1
CODE option
1
PARSE option
1
precompiler options
alphabetized list
1
,
2
AUTO_CONNECT
1
case sensitivity
1
CHAR_MAP
1
,
2
CLOSE_ON_COMMIT
1
,
2
,
3
CODE
1
COMP_CHARSET
1
,
3
CONFIG
1
,
2
,
3
,
4
,
5
configuration files
1
CPP_SUFFIX
1
DBMS
1
,
2
DEF_SQLCODE
1
DEFINE
1
determining current value
1
DURATION
1
DYNAMIC
1
entering
1
entering on the command line
1
ERRORS
1
ERRTYPE
1
FIPS
1
HEADER
1
HOLD_CURSOR
1
,
2
INAME
1
INCLUDE
1
INTYPE
1
LINES
1
list of
1
LNAME
1
LTYPE
1
MAXLITERAL
1
,
2
MAXOPENCURSORS
1
MEMFORPREFETCH
1
micro and macro
1
MODE
1
,
2
NLS_CHAR
1
,
2
NLS_LOCAL
1
OBJECTS
1
,
2
ONAME
1
ORACA
1
,
2
,
3
,
4
,
5
,
6
PAGELEN
1
PARSE
1
PLAN_BASELINE
1
PLAN_ENABLED
1
PLAN_FIXED
1
PLAN_PREFIX
1
PLAN_RUN
1
precedence
1
PREFETCH
1
RELEASE_CURSOR
1
scope
1
scope of
1
SELECT_ERROR
1
,
2
specifying
1
SQLCHECK
1
syntax for
1
SYS_INCLUDE
1
THREADS
1
,
2
TYPE_CODE
1
,
2
UNSAFE_NULL
1
USERID
1
using
1
VARCHAR
1
VERSION
1
Precompiler Options, SYS_INCLUDE, INCLUDE
1
predefined symbols
1
PREFETCH precompiler option
1
,
2
PREPARE SQL statement
1
PREPARE statement
effect on data definition statements
1
examples
1
use in dynamic SQL
1
,
2
use in dynamic SQL method 4
1
preprocessor
example
1
EXEC ORACLE directives
1
preprocessor, support of
1
preprocessor directives
directives not supported by Pro*C
1
private SQL area
association with cursors
1
definition of
1
opening of
1
purpose of
1
Pro*C/C++
configuration files
1
integrating into Microsoft Visual Studio
1
library file
1
linking
1
Pro*C/C++ Precompiler
common uses for
1
Globalization Support
1
new database types
1
object support in
1
runtime context
1
use of PL/SQL with
1
using OTT with
1
procedural database extension
1
programming guidelines
1
program termination
normal versus abnormal
1
project files
1
Q
queries
association with cursors
1
forwarding
1
incorrectly coded
1
kinds of
1
requirements for
1
returning more than one row
1
single-row versus multirow
1
R
RAW datatype
1
READ ONLY parameter
in SET TRANSACTION statement
1
read-only transactions
description of
1
example of
1
how ended
1
record
1
REF
structure for
1
REF (reference to object)
1
REFERENCE clause
in TYPE statement
1
reference semantics (ANSI dynamic SQL)
1
references to objects (REFs)
declaring
1
using
1
using in embedded SQL
1
referencing
of host arrays
1
,
2
REFs
declaring
1
using
1
using in embedded SQL
1
REGISTER CONNECT SQL statement
1
RELEASE_CURSOR
precompiler option
what it affects
1
RELEASE_CURSOR option
of ORACLE Precompilers
1
using to improve performance
1
RELEASE_CURSOR precompiler option
1
RELEASE option
if omitted
1
in COMMIT statement
1
in ROLLBACK statement
1
purpose of
1
restriction on
1
remote database
declaration of
1
reserved namespaces
1
reserved words and keywords
1
resource manager
1
restrictions
on AT clause
1
on Comments
1
on CURRENT OF clause
1
on declaring cursors
1
on FOR clause
1
on host arrays
1
,
2
,
3
,
4
,
5
on input host variables
1
on NULLs
1
on separate precompilation
1
on SET TRANSACTION statement
1
use of CURRENT OF clause
1
retrieving rows from a table
embedded SQL
1
return codes
user exits
1
returning clause
DELETE
1
in INSERT
1
in UPDATE
1
returning clauses
1
roll back
to a savepoint
1
to the same savepoint multiple times
1
rollbacks
automatic
1
function of
1
statement-level
1
ROLLBACK SQL statement
1
ROLLBACK statement
effect of
1
ending a transaction
1
example of
1
examples
1
in error handling routines
1
purpose of
1
RELEASE option in
1
TO SAVEPOINT clause in
1
using in a PL/SQL block
1
where to place
1
ROWID
logical
1
pseudocolumn
using to mimic CURRENT OF
1
,
2
universal
1
ROWID datatype
1
row locks
acquiring with FOR UPDATE OF
1
advantage of
1
using to improve performance
1
when acquired
1
when released
1
rows
fetching from cursors
1
,
2
inserting into tables and views
1
updating
1
rows-processed count
use in error reporting
1
runtime context
establishing
1
terminating
1
runtime type checking
1
S
sample database tables
DEPT table
1
EMP table
1
sample object type code
1
sample programs
ANSIDYN1
1
ansidyn1.pc
1
ANSIDYN2
1
ansidyn2.pc
1
building
1
calldemo.sql, with sample9.pc
1
COLDEMO1
1
coldemo1.pc
1
CPPDEMO1
1
cppdemo1.pc
1
CPPDEMO2
1
cppdemo2.pc
1
CPPDEMO3
1
cppdemo3.pc
1
cursor variable demos
1
CV_DEMO
1
cv_demo.pc
1
cv_demo.sql
1
default drive
1
described
1
EMPCLASS
1
extp1.pc
1
how to precompile
1
,
2
LOBDEMO1
1
lobdemo1.pc
1
location of
1
,
2
MLTTHRD1
1
NAVDEMO1
1
navdemo1.pc
1
OBJDEMO1
1
ORACA
1
oraca.pc
1
PLSSAM
1
SAMPLE
1
SAMPLE1
1
sample1.pc
1
SAMPLE10
1
sample10.pc
1
SAMPLE11
1
sample11.pc
1
SAMPLE12
1
sample12.pc
1
SAMPLE2
1
sample2.pc
1
SAMPLE3
1
sample3.pc
1
SAMPLE4
1
sample4.pc
1
SAMPLE5
1
sample5.pc
1
SAMPLE6
1
sample6.pc
1
SAMPLE7
1
sample7.pc
1
SAMPLE8
1
sample8.pc
1
SAMPLE9
1
sample9.pc
1
setting the path
1
setting the path for the .pre files
1
SQLVCP
1
sqlvcp.pc
1
WINSAM
1
sample tables
building
1
savepoints
creating
1
definition of
1
uses for
1
when erased
1
SAVEPOINT SQL statement
1
SAVEPOINT statement
example of
1
examples
1
purpose of
1
scale
definition of
1
,
2
using sqlprc() to extract
1
when negative
1
,
2
Scale
using SQLPRC to extract
1
SCHEMA_NAMES OTT parameter
usage
1
scope
of a cursor variable
1
of DECLARE STATEMENT directive
1
of precompiler options
1
of the EXEC ORACLE statement
1
of WHENEVER statement
1
search condition
definition of
1
in the WHERE clause
1
SELECT_ERROR
precompiler option
1
,
2
,
3
select descriptor
information in
1
select list
definition of
1
number of items in
1
using the free() function for
1
using the malloc() function for
1
select SQLDA
purpose of
1
SELECT SQL statement
1
SELECT statement
clauses available for
1
embedded SQL examples
1
example of
1
INTO clause in
1
purpose of
1
testing
1
using host arrays in
1
WHERE clause in
1
semantic checking
controlling with the SQLCHECK option
1
definition of
1
enabling
1
with the SQLCHECK option
1
separate precompilation
guidelines for
1
referencing cursors for
1
restrictions on
1
specifying MAXOPENCURSORS for
1
using a single SQLCA with
1
server
integration with PL/SQL
1
session
definition of
1
sessions
beginning
1
SET clause
in UPDATE statements
1
purpose of
1
use of subqueries in
1
SET DESCRIPTOR statement
1
,
2
SET TRANSACTION statement
example of
1
purpose of
1
READ ONLY parameter in
1
requirements for
1
restrictions on
1
Size of an Integer and ROWID
1
SQL
benefits of
1
Embedded SQL
1
nature of
1
need for
1
SQL_CURSOR
1
SQL_SINGLE_RCTX
defined constant
1
definition of
1
SQL, dynamic
1
SQL*Forms
display error screen in
1
IAP constants in
1
returning values to
1
reverse return code switch in
1
SQL*Plus
using to test SELECT statements
1
versus embedded SQL
1
sqlald() function
example of using
1
purpose of
1
syntax for
1
sqlaldt() function
see SQLSQLDAAlloc
1
SQLCA
components in
1
components set for a PL/SQL block
1
declaring
1
description of
1
explicit versus implicit checking of
1
including multiple times
1
overview of
1
SQLCABC component in
1
SQLCAID component in
1
sqlerrd
1
sqlerrd[2] component in
1
sqlerrmc component in
1
sqlerrml component in
1
sqlwarn
1
use in separate precompilations
1
using more than one
1
using with Oracle Net Services
1
sqlca.h
listing of
1
use of SQLCA_STORAGE_CLASS with
1
SQLCAID component
1
SQLCDAFromResultSetCursor()
1
SQLCDAGetCurrent
1
sqlcdat()
see SQLCDAFromResultSetCursor()
1
SQLCHECK option
restrictions on
1
what it affects
1
SQLCHECK precompiler option
1
,
2
,
3
SQLCHECK support for objects
1
sqlclu() function
example of using
1
purpose of
1
syntax for
1
sqlclut() function
see SQLSQLDAFree()
1
sqlcode
component in SQLCA
1
,
2
SQLCODE
with MODE=ANSI
1
SQLCODE status variable
declaring
1
when declared with the SQLCA
1
when used
1
SQL Communications Area
SQLCA
1
sqlcpr.h
1
sqlcurt() function
see SQLDAToResultSetCursor()
1
SQLDA
bind versus select
1
C variable in
1
definition of
1
F variable in
1
information stored in
1
I variable in
1
L variable in
1
M variable in
1
N variable in
1
purpose of
1
struct, contents of
1
structure of
1
S variable in
1
T variable in
1
use in dynamic SQL method 4
1
V variable in
1
X variable in
1
Y variable in
1
Z variable in
1
sqlda.h
1
SQLDAToResultSetCursor()
1
SQL Descriptor Area
SQLDA
1
,
2
SQL directives
CONTEXT USE
1
,
2
DECLARE DATABASE
1
DECLARE STATEMENT
1
DECLARE TABLE
1
DECLARE TYPE
1
TYPE
1
VAR
1
WHENEVER
1
SQLEnvGet()
1
SQLEnvGet function in SQLLIB
1
sqlerrd
component
1
,
2
sqlerrd[2] component
returns N or rows fetched
1
use with data manipulation statements
1
sqlerrm
component in the SQLCA
1
sqlerrmc component
1
sqlerrml component
1
SQLERROR
WHENEVER directive condition
1
SQLERROR condition
in the WHENEVER statement
1
meaning of
1
SQLErrorGetText()
1
SQLExtProcError()
1
,
2
sqlglm()
1
sqlglm() function
example of using
1
parameters of
1
sqlglmt()
see SQLErrorGetText
1
sqlgls() function
example of use
1
sample program for
1
see SQLLIB
function SQLStmGetText
1
sqlglst() function
see SQLStmtGetText
1
sqlld2() function
1
sqlld2t() function
see SQLLDAGetName
1
SQLLDAGetName
1
sqlldat() function
see SQLCDAGetCurrent
1
SQLLIB
and embedded SQL
1
extensions for OCI interoperability
1
function
SQLCDAFromResultSetCursor
1
function SQLCDAGetCurrent
1
function SQLColumnNullCheck
1
function SQLDAFree
1
function SQLDAToResultSetCursor
1
function SQLEnvGet
1
,
2
function SQLErrorGetText
1
function SQLExtProcError
1
,
2
function SQLLDAGetName
1
function SQLNumberPrecV6
1
function SQLNumberPrecV7
1
function SQLRowidGet
1
function SQLStmtGetText()
1
function SQLSvcCtxGet
1
,
2
function SQLVarcharGetLength
1
new names for public functions
1
SQLLIB function
SQLSQLDAAlloc
1
SQLVarcharGetLength
1
sqlnul() function
example of using
1
purpose of
1
syntax for
1
use of with T variable
1
sqlnult() function
see SQLColumnNullCheck()
1
SQLNumberPrecV6
1
SQLNumberPrecV7
1
sqlpr2() function
1
sqlpr2t() function
see SQLNumberPrecV7
1
sqlprc() function
1
sqlprct() function
see SQLNumberPrecV6
1
SQLRowidGet()
1
SQLSQLDAAlloc
1
SQLSQLDAFree()
1
SQLSTATE
class codes
1
declaring
1
mapping to Oracle errors
1
status codes
1
status variable
1
,
2
using
1
values
1
with MODE=ANSI
1
SQL statements
ALLOCATE
1
ALLOCATE DESCRIPTOR TYPE
1
CACHE FREE ALL
1
CALL
1
,
2
CLOSE
1
COMMIT
1
concerns when executing
1
CONNECT
1
CONTEXT ALLOCATE
1
CONTEXT FREE
1
CONTEXT OBJECT OPTION GET
1
CONTEXT OBJECT OPTION SET
1
DEALLOCATE DESCRIPTOR
1
DELETE
1
DESCRIBE
1
DESCRIBE DESCRIPTOR
1
ENABLE THREADS
1
executable versus directive
1
EXECUTE
1
EXECUTE ... END-EXEC
1
EXECUTE IMMEDIATE
1
FETCH
1
FETCH DESCRIPTOR
1
for defining and controlling transactions
1
for manipulating a cursor
1
,
2
FREE
1
INSERT
1
LOB APPEND
1
LOB ASSIGN
1
LOB CLOSE
1
LOB COPY
1
LOB CREATE
1
LOB DESCRIBE
1
LOB DISABLE BUFFERING
1
LOB ENABLE BUFFERING
1
LOB ERASE
1
LOB FILE CLOSE
1
LOB FILE SET
1
LOB FLUSH BUFFER
1
LOB FREE TEMPORARY
1
LOB LOAD
1
LOB OPEN
1
LOB READ
1
LOB TRIM
1
LOB WRITE
1
OBJECT CREATE
1
OBJECT DELETE
1
OBJECT DEREF
1
OBJECT FLUSH
1
OBJECT GET
1
OBJECT RELEASE
1
OBJECT SET
1
OBJECT UPDATE
1
OPEN
1
OPEN DESCRIPTOR
1
optimizing to improve performance
1
PREPARE
1
REGISTER CONNECT
1
ROLLBACK
1
rules for executing
1
SAVEPOINT
1
SELECT
1
SET DESCRIPTOR
1
summary of
1
types of
1
UPDATE
1
SQLStmtGetText
1
SQLStmtGetText() function
1
SQLSvcCtxGet()
1
SQLSvcCtxGet function in SQLLIB
1
SQLVarcharGetLength
1
sqlvcp() function
1
sqlvcp() function, see SQLLIB
function SQLVarcharGetLength
1
sqlvcpt() function
see SQLVarcharGetLength
1
sqlwarn
flag
1
SQLWARNING
WHENEVER directive condition
1
SQLWARNING condition
in the WHENEVER statement
1
meaning of
1
Standard Header Files
1
statement-level rollback
description of
1
to break deadlocks
1
status codes
meaning of
1
status variables
1
STOP action
in the WHENEVER statement
1
of WHENEVER directive
1
result of
1
stored procedures
program example
1
stored subprograms
calling
1
creating
1
packaged versus standalone
1
stored versus inline
1
STRING datatype
1
string host variables
declaring
1
Struct Component Alignment
1
structs
array of
1
as host variables
1
C, using
1
for collection object types
1
generating C structs for a REF
1
pointers as host variables
1
structs (structures)
cannot be nested
1
structures (structs)
nesting not permitted for host
1
subqueries
definition of
1
example of
1
,
2
uses for
1
using in the SET clause
1
using in the VALUES clause
1
S variable in SQLDA
how value is set
1
purpose of
1
symbols
defining
1
syntax, embedded SQL
1
syntax checking
controlling with the SQLCHECK option
1
definition of
1
syntax diagram
description of
1
how to read
1
how to use
1
symbols used in
1
SYS_INCLUDE
system header files in C++
1
SYS_INCLUDE, INCLUDE Precompiler Options
1
SYS_INCLUDE precompiler option
1
system configuration file
1
System Configuration File
1
system failure
effect on transactions
1
System Global Area (SGA)
1
system header files
specifying the location of
1
system-specific Oracle documentation
1
,
2
,
3
,
4
,
5
,
6
system-specific reference
1
,
2
,
3
,
4
,
5
T
table locks
acquiring with LOCK TABLE
1
effect of
1
row share
1
when released
1
tables
inserting rows into
1
nested
1
updating rows in
1
terminal
encoding scheme
1
termination, program
normal versus abnormal
1
threads
allocating context
1
,
2
enabling
1
,
2
freeing context
1
,
2
use context
1
THREADS
precompiler option
1
,
2
TIMESTAMP datatype
1
TIMESTAMP WITH LOCAL TIME ZONE datatype
1
TIMESTAMP WITH TIME ZONE datatype
1
TO clause
of ROLLBACK statement
1
Toolset
Oracle
1
TO SAVEPOINT clause
in ROLLBACK statement
1
purpose of
1
restriction on
1
trace facility
function of
1
using to improve performance
1
transaction processing
overview of
1
statements used for
1
transaction processing monitor
1
transactions
committing
1
contents of
1
,
2
definition of
1
description of
1
distributed
1
failure during
1
guarding databases with
1
guidelines for
1
how to begin
1
how to end
1
making permanent
1
read-only
1
rolling back
1
subdividing with savepoints
1
terminating
1
undoing
1
undoing parts of
1
when rolled back automatically
1
,
2
transient copies of objects
1
transient objects
1
TRANSITIVE OTT parameter
1
truncated values
detecting
1
,
2
truncation error
when generated
1
tuning, performance
1
T variable in SQLDA
how value is set
1
purpose of
1
two-task
linking
1
TYPE_CODE
precompiler option
1
type checking at runtime
1
TYPE directive
examples
1
type inheritance
example
1
IS OF type operator
example
1
TREAT operator
example
1
TYPE SQL directive
1
U
undo a transaction
1
Unicode character set
1
unions
cannot be nested in host structures
1
not permitted as host structures
1
universal ROWID
1
UNIX
linking a Pro*C application under
1
UNSAFE_NULL precompiler option
1
UNSIGNED datatype
1
UPDATE SQL statement
1
UPDATE statement
embedded SQL examples
1
example of
1
purpose of
1
SET clause in
1
using host arrays in
1
WHERE clause in
1
updating
rows in tables and views
1
use
thread context
1
,
2
user configuration file
to set precompiler options
1
user-defined record
1
user-defined stored function
used in WHERE clause
1
user-defined type equivalencing
1
user exits
calling from a SQL*Forms trigger
1
common uses for
1
example of
1
kinds of statements allowed in
1
linking into IAP
1
meaning of codes returned by
1
naming
1
passing parameters to
1
requirements for variables in
1
running the GENXTB form
1
running the GENXTB utility for
1
use of WHENEVER statement in
1
User Exits
1
USERID option
when required
1
USERID OTT parameter
1
USERID precompiler option
using with the SQLCHECK option
1
usernames
defining
1
user session
definition of
1
USING clause
in CONNECT statement
1
in the EXECUTE statement
1
of FETCH statement
1
of OPEN statement
1
purpose of
1
using indicator variables in
1
using collection types
1
using C structures
1
using dbstring
Oracle Net database specification string
1
Using REFs in Embedded SQL
1
V
V7
value of DBMS option
1
,
2
VALUES clause
in INS
1
of embedded SQL INSERT statement
1
of INSERT statement
1
use of subqueries in
1
VARCHAR
arrays of
1
VARCHAR2 datatype
1
,
2
VARCHAR datatype
1
VARCHAR precompiler option
1
VARCHAR pseudotype
requirements for using with PL/SQL
1
VARCHAR variables
advantages of
1
declaring
1
length member in
1
must be passed to a function by reference
1
specifying the length of
1
structure of
1
using macros to define length of
1
versus character arrays
1
VAR directive
examples
1
variables
cursor
1
host
1
indicator
1
VARNUM datatype
1
VARRAW datatype
1
varrays
creation
1
VAR SQL directive
1
VAR statement
syntax for
1
,
2
varying length arrays
1
VERSION precompiler option
1
views
inserting rows into
1
updating rows in
1
VMS
linking a precompiler application
1
V variable in SQLDA
how value is set
1
purpose of
1
W
warning flags
use in error reporting
1
WHENEVER directive
examples
1
WHENEVER SQL directive
1
WHENEVER statement
automatic checking of SQLCA with
1
CONTINUE action in
1
DO action in
1
DO BREAK action in
1
DO CONTINUE action in
1
examples of
1
GOTO action in
1
guidelines for
1
maintaining addressability for
1
NOT FOUND condition in
1
overview of
1
scope of
1
SQLERROR condition in
1
SQLWARNING condition in
1
STOP action in
1
use in user exits
1
using to avoid infinite loops
1
using to handle end-of-data conditions
1
where to place
1
WHERE clause
host arrays in
1
if omitted
1
in DELETE statements
1
in SELECT statements
1
in UPDATE statements
1
purpose of
1
search condition in
1
WHERE CURRENT OF clause
CURRENT OF clause
1
WITH HOLD
clause of DECLARE CURSOR statement
1
WORK option
of COMMIT statement
1
of ROLLBACK statement
1
X
X/Open
application development
1
XA interface
1
X variable in SQLDA
how value is set
1
purpose of
1
Y
Y variable in SQLDA
how value is set
1
purpose of
1
Z
Z variable in SQLDA
how value is set
1
purpose of
1
Scripting on this page enhances content navigation, but does not change the content in any way.