Oracle Call Interface Programmer's Guide
Release 8.1.6
A76975-01
Library
Product
Contents
Index
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
A
aborting OCI calls, 2-34
abstract data type
representing in C applications, 10-8
ADO. See attribute descriptor object
ADT. See abstract data type
Advanced Queueing
dequeue function, 15-5
description, 9-27
enqueue function, 15-7
examples, 15-8
OCI and, 9-27
OCI descriptors for, 9-27
OCI functions for, 9-27
OCI vs. PL/SQL, 9-28
advanced queuing functions, 15-4
advantages
OCI, 1-3
allocation duration
example, 13-14
of objects, 13-14
application failover
callback example, 9-22
callback registration, 9-22
OCI callbacks, 9-20
applications
linking, 2-37
AQ. See Advanced Queueing.
arguments
attributes, 6-16
arrays
binds, 12-3
defines, 12-6
skip parameter for, 5-24
arrays of structures, 5-22
indicator variables, 5-25
OCI calls used, 5-25
skip parameters, 5-23
atomic nullness, 10-29
attribute descriptor object, 11-23
attributes
of handles, 2-13
of objects, 10-17
of parameter descriptors, 6-5
of parameters, 6-5
authentication management, 8-12
authorize functions, 15-89
B
batch error mode, 4-8
BFILE
datatype, 3-20
bind functions, 15-43
bind handle
attributes, A-21
description, 2-10
bind operation, 4-5,
5-2,
12-2
associations made, 5-3
example, 5-6
initializing variables, 5-3
LOBs, 5-10
named datatypes, 5-10,
12-2
named vs. positional, 5-4
OCI array interface, 5-4
OCI_DATA_AT_EXEC mode, 5-16
PL/SQL, 5-5
positional vs. named, 5-4
ref cursor variables, 5-17
REFs, 5-10,
12-3
static arrays, 5-10
steps used, 5-6
binding
arrays, 12-3
OCINumber, 12-8
PL/SQL placeholders, 2-39
summary, 5-17
BLOB
datatype, 3-20
blocking modes, 2-37
branches
detaching, 8-7
resuming, 8-7
buffering LOB operations, 7-9
C
C datatypes
manipulating with OCI, 11-5
cache functions
server roundtrips, C-4
callbacks
application failover, 9-20
dynamic registrations, 9-14
for LOB operations, 7-11
for reading LOBs, 7-12
for writing LOBs, 7-13
from external procedures, 9-19
LOB streaming interface, 7-11
parameter modes, 15-64
registration for application failover, 9-22
restrictions, 9-17
user-defined functions, 9-10
canceling OCI calls, 2-34
CASE OTT parameter, 14-27
CHAR
external datatype, 3-16
character set form, 5-31
character set Id, 5-31
Unicode, A-21,
A-23
CHARZ
external datatype, 3-17
checkerr() function
code listing, 2-28
CLOB
datatype, 3-21
code
example programs, B-1
list of demonstration programs, B-1
CODE OTT parameter, 14-26
codes
functions, 15-236
coding guidelines
function names, 2-36
reserved words, 2-35
coherency
of object cache, 13-4
collections
attributes, 6-13
data manipulation functions, 11-18
describing, 6-2
description, 11-17
functions for manipulating, 11-18
scanning functions, 11-19
columns
attributes, 6-5,
6-15
commit, 2-26
in object applications, 13-14
one-phase for global transactions, 8-7
two-phase for global transactions, 8-7
complex object retrieval, 10-20
implementing, 10-23
navigational prefetching, 10-24
complex object retrieval (COR) descriptor, 2-17
attributes, A-27
complex object retrieval (COR) handle, 2-11
attributes, A-26
CONFIG OTT parameter, 14-27
connect functions, 15-89
connection mode
non-blocking, 2-37
consistency
of object cache, 13-4
copying
objects, 10-32
COR, see complex object retrieval
creating
objects, 10-32
D
data cartridges
OCI functions, xxxiii,
2-3
data definition language
SQL statements, 1-7
data manipulation language
SQL statements, 1-8
data structures
new for 8.0, 2-5
database connection
for object applications, 10-10
databases
attributes, 6-19
describing, 6-2
datatypes
BFILE, 3-20
binding and defining, 12-6
BLOB, 3-20
CLOB, 3-21
conversions, 3-21
direct path loading, 9-41,
A-48
external, 3-4,
3-7
FILE, 3-20
for piecewise operations, 5-38
internal, 3-3,
3-5
internal codes, 3-5
manipulating with OCI, 11-5
mapping and manipulation functions
server roundtrips, C-6
mapping from Oracle to C, 11-2
mapping, Oracle methodology, 11-4
mapping, OTT, 14-9
NCLOB, 3-21
Oracle, 3-2
DATE
external datatype, 3-14
DDL. See data definition language
default file name extensions
OTT, 14-36
default name mapping
OTT, 14-36
define
arrays, 12-6
return and error codes, 2-29
define functions, 15-43
define handle
attributes, A-23
description, 2-10
define operation, 4-14,
5-18,
12-4
example, 5-19
LOBs, 5-21
named datatypes, 5-21,
12-4
piecewise fetch, 5-22
PL/SQL output variables, 5-21
REFs, 5-21,
12-4
static arrays, 5-22
steps used, 5-19
defining
OCINumber, 12-8
deletes
positioned, 2-34
demonstration programs, B-1
list, B-1
describe
explicit, 4-13
explicit and implicit, 6-5
implicit, 4-12
of collections, 6-2
of databases, 6-2
of packages, 6-2
of schemas, 6-2
of sequences, 6-2
of stored functions, 6-2
of stored procedures, 6-2
of synonyms, 6-2
of tables, 6-2
of types, 6-2
of views, 6-2
select-list, 4-11
describe functions, 15-43
describe handle
attributes, A-25
description, 2-11
describe operation
server roundtrips, C-6
descriptor, 2-14
allocating, 2-22
complex object retrieval, 2-17
objects, 11-23
parameter, 2-16
ROWID, 2-16
snapshot, 2-15
descriptor functions, 15-27
descriptor objects, 11-23
detaching branches, 8-7
direct path handles, 2-12
direct path loading, 9-39
column array handle attributes, A-43
column parameter attributes, A-45
context handle attributes, A-40
datatypes of columns, 9-41,
A-48
direct path column array handle, 9-42
direct path context handle, 9-41
direct path stream handle, 9-42
example, 9-44
functions, 9-43
handle attributes, A-40
handles, 9-41
limitations, 9-40
stream handle attributes, A-44
direct path loading functions, 15-74
DML. See data manipulation language
DML with RETURNING clause
See RETURNING clause
duration
example, 13-14
of objects, 13-14
E
embedded objects
fetching, 10-15
embedded SQL, 1-11
mixing with OCI calls, 1-11
enhanced DML array, 4-8
enhanced DML array feature, 4-8
environment handle
attributes, A-3
description, 2-8
error codes
define calls, 2-29
navigational functions, 16-6
error handle
attributes, A-6
description, 2-9
errors
example of handling, 2-28
handling, 2-27
handling in object applications, 10-35
ERRTYPE OTT parameter, 14-27
example
demonstration programs, B-1
non-blocking mode, 2-38
using OCIThread, 9-8
executing SQL statements, 4-6
execution
against multiple servers, 4-5
modes, 4-7
execution snapshots, 4-7
extensions
OTT default file name, 14-36
external datatypes, 3-4,
3-7
CHAR, 3-16
CHARZ, 3-17
conversions, 3-21
DATE, 3-14
FLOAT, 3-11
INTEGER, 3-11
LOBs, 3-19
LONG, 3-13
LONG RAW, 3-16
LONG VARCHAR, 3-16
LONG VARRAW, 3-16
named data types, 3-18
NUMBER, 3-10
RAW, 3-15
REF, 3-18
ROWID, 3-13
SQLT_BLOB, 3-19
SQLT_CLOB, 3-19
SQLT_NCLOB, 3-19
SQLT_NTY, 3-18
SQLT_REF, 3-18
STRING, 3-12
UNSIGNED, 3-16
VARCHAR, 3-13
VARCHAR2, 3-9
VARNUM, 3-12
VARRAW, 3-15
external procedure functions
return codes, 18-3
with_context type, 18-3
external procedures
OCI callbacks, 9-19
F
fetch
piecewise, 5-37,
5-41
fetch operation, 4-15
LOB data, 4-15
setting prefetch count, 4-15
FILE
associating with OS file, 7-3
datatype, 3-20
FLOAT
external datatype, 3-11
flushing, 13-10
object changes, 10-14
objects, 13-10
freeing
objects, 10-32,
13-9
function names
coding guidelines, 2-36
functions
attributes, 6-8
codes, 15-236
new and updated calls, 1-13
G
global transactions, 8-4
GTRID. See transaction identifier
H
handle attributes, 2-13
reading, 2-13
setting, 2-13
handle functions, 15-27
handles, 2-6
advantages of, 2-8
allocating, 2-7,
2-22
bind handle, 2-10
C datatypes, 2-6
child freed when parent freed, 2-7
define handle, 2-10
describe handle, 2-11
direct path, 2-12
environment handle, 2-8
error handle, 2-9
freeing, 2-7
hierarchy of, 2-8
process, 2-13
process attributes, A-50
server handle, 2-9
service context handle, 2-9
statement handle, 2-10
subscription, 2-12,
9-33
transaction handle, 2-10
types, 2-6
user session handle, 2-9
HFILE OTT parameter, 14-26
I
indicator variable, 2-32
arrays of structures, 5-25
for named datatypes, 2-32,
2-33
for REF, 2-32
for REFs, 2-33
named datatype defines, 12-5
PL/SQL OUT binds, 12-5
REF defines, 12-5
with named datatype bind, 12-3
with REF bind, 12-3
INITFILE OTT parameter, 14-26
INITFUNC OTT parameter, 14-26
initialize functions, 15-89
inserts
piecewise, 5-37,
5-39
INTEGER
external datatype, 3-11
internal codes for datatypes
datatype codes, 3-5
internal datatypes, 3-3,
3-5
conversions, 3-21
intype file
providing when running OTT, 14-8
structure of, 14-29
INTYPE OTT parameter, 14-25
K
key words, xxxviii,
2-35
L
linking, 2-37
issues, 1-24
modes, 1-24
support for single-task, 1-27
lists
attributes, 6-18
LOB
amount and offset parameters, 15-110
attributes of transient objects, 7-4
binding, 5-10
buffering, 7-9
callbacks, 7-11
character sets, 15-110
creating, 7-2
creating temporary, 7-16
defining, 5-21
duration of temporary, 7-16
example of temporary, 7-17
external datatypes, 3-19
fetching data, 4-15
fixed-width character sets, 15-110
freeing temporary, 7-16
locator, 2-15
modifying, 7-2
OCI functions, 7-4
temporary, 7-15
varying-width character sets, 15-110
LOB functions, 15-109
server roundtrips, C-3
LOB locator, 2-15
attributes, A-26
locator, 2-14
for LOB datatype, 2-15
locking, 13-12
objects, 13-12
optimistic model, 13-13
LONG
external datatype, 3-13
LONG RAW
external datatype, 3-16
LONG VARCHAR
external datatype, 3-16
LONG VARRAW
external datatype, 3-16
M
marking
objects, 13-9
MDO. See method descriptor object
meta-attributes
of objects, 10-17
of persistent objects, 10-17
of transient objects, 10-20
method descriptor object, 11-23
migration
7.x to 8.0, 1-22
session, 8-12,
15-105
miscellaneous functions, 15-220
multiple servers
executing statement against, 4-5
multithreaded development
basic concepts, 8-23
N
named datatypes
binding, 5-10,
12-2
binding and defining, 12-6
defining, 5-21,
12-4
definition, 3-18
external datatypes, 3-18
indicator variable for, 2-32
indicator variables, 2-33
navigation, 13-17
navigational functions
error codes, 16-6
return values, 16-5
terminology, 16-4
NCHAR
issues, 5-31
NCLOB
datatype, 3-21
nested table
element ordering, 11-21
functions for manipulating, 11-20
new features, 1-12
benefits, 1-12
introduction, 1-12
NLS
OCI functions, xxxiii,
2-3
non-blocking mode, 2-37
example, 2-38
no-op
definition, 16-22
null indicator struct, 10-29
generated by OTT, 10-9
nullness
atomic, 10-29
of objects, 10-29
NULLs
detecting, 2-33
inserting, 2-33
inserting into database, 2-32
inserting using indicator variables, 2-32
NUMBER
external datatype, 3-10
O
object applications
commit, 13-14
database connection, 10-10
rollback, 13-14
object cache, 13-2
coherency, 13-4
consistency, 13-4
initializing, 10-10
loading objects, 13-7
memory parameters, 13-5
operations on, 13-6
removing objects, 13-7
setting the size of, 13-5
object functions
See navigational functions.
server roundtrips, C-4
object identifier
for persistent objects, 10-5
object reference, 10-33
object reference. See REF
object runtime environment
initializing, 10-10
object type translator
sample output, 10-9
See OTT
use with OCI, 10-8
objects
accessing with OCI, 14-19
allocation duration, 13-14
array pin, 10-13
attributes, 10-17
manipulating, 10-13
client-side cache, 13-2
copying, 10-32
creating, 10-32
duration, 13-14
flushing, 13-10
flushing changes, 10-14
freeing, 10-32,
13-9
lifetime, 16-2
LOB attribute of, 7-3
LOB attributes of transient objects, 7-4
locking, 13-12
manipulating with OCI, 14-19
marking, 10-14,
13-9
memory layout of instance, 13-16
memory management, 13-2
meta-attributes, 10-17
navigation, 13-17
simple, 13-17
nullness, 10-29
OCI object application structure, 10-4
persistent, 10-5,
10-6
pin count, 10-28
pin duration, 13-14
pinning, 10-12,
13-7
refreshing, 13-11
secondary memory, 13-16
terminology,
16-2
top-level memory, 13-16
transient, 10-5,
10-7
types, 10-5,
16-2
unmarking, 13-10
unpinning, 10-28,
13-8
use with OCI, 10-3
OCI
accessing and manipulating objects, 14-19
advantages, 1-3
new features, 1-12
object support, 1-6
overview, 1-2
parts of, 1-5
OCI application
compiling, 1-4
general structure, 2-3
initialization example, 2-24
linking, 1-4
steps, 2-18
structure, 2-3
structure using objects, 10-4
terminating, 2-27
using the OTT with, 14-18
with objects
initializing, 10-10
OCI environment
initializing for objects, 10-10
OCI functions
advanced queuing, xxxiii
canceling calls, 2-34
codes, 15-236
data cartridges, xxxiii,
2-3
new and updated calls, 1-13
NLS, xxxiii,
2-3
not supported, 1-21
obsolescent, 1-19
other guides, xxxiii
return codes, 2-27,
2-30
OCI navigational functions, 13-19
flush functions, 13-20
mark functions, 13-20
meta-attribute accessor functions, 13-20
miscellaneous functions, 13-21
naming scheme, 13-19
pin/unpin/free functions, 13-19
OCI process
initializing for objects, 10-10
OCI program. See OCI application
OCI relational functions
advanced queuing and publish-subscribe, 15-4
connect, authorize, and initialize, 15-89
guide to reference entries, 18-2
OCI_ATTR_ALLOC_DURATION
environment handle attribute, A-4
OCI_ATTR_AUTOCOMMIT_DDL
attribute, 6-20
OCI_ATTR_BUF_ADDR, A-44
OCI_ATTR_BUF_SIZE, A-40,
A-44
OCI_ATTR_CACHE
attribute, 6-15
OCI_ATTR_CACHE_ARRAYFLUSH
environment handle attribute, A-3
OCI_ATTR_CACHE_MAX_SIZE
environment handle attribute, A-3
OCI_ATTR_CACHE_OPT_SIZE
environment handle attribute, A-3
OCI_ATTR_CATALOG_LOCATION
attribute, 6-20
OCI_ATTR_CHAR_COUNT
bind handle attribute, A-21
define handle attribute, A-23
use of, 5-33
OCI_ATTR_CHARSET_FORM
attribute, 6-11,
6-14,
6-16
bind handle attribute, A-21
define handle attribute, A-24
OCI_ATTR_CHARSET_ID, A-40,
A-47
attribute, 6-11,
6-14,
6-16,
6-18,
6-19
bind handle attribute, A-21
define handle attribute, A-23
OCI_ATTR_CLUSTERED
attribute, 6-7
OCI_ATTR_COL_COUNT, A-43
OCI_ATTR_COLLECTION_ELEMENT
attribute, 6-9
OCI_ATTR_COLLECTION_TYPECODE
attribute, 6-9
OCI_ATTR_COMPLEXOBJECT_ COLL_OUTOFLINE
COR handle attribute, A-26
OCI_ATTR_COMPLEXOBJECT_LEVEL
COR handle attribute, A-26
OCI_ATTR_COMPLEXOBJECTCOMP _TYPE_LEVEL
COR descriptor attribute, A-27
OCI_ATTR_COMPLEXOBJECTCOMP_TYPE
COR descriptor attribute, A-27
OCI_ATTR_CURSOR_COMMIT_ BEHAVIOR
attribute, 6-20
OCI_ATTR_DATA_SIZE, A-47
attribute, 6-10,
6-13,
6-15,
6-16
OCI_ATTR_DATA_TYPE, A-48
attribute, 6-10,
6-13,
6-15,
6-16
OCI_ATTR_DATE_FORMAT, A-40
OCI_ATTR_DATEFORMAT, A-48
OCI_ATTR_DBA
attribute, 6-7
OCI_ATTR_DIRPATH_MODE, A-41
OCI_ATTR_DIRPATH_NOLOG, A-41
OCI_ATTR_DIRPATH_PARALLEL, A-41
OCI_ATTR_DML_ROW_OFFSET, A-6
OCI_ATTR_DURATION
attribute, 6-7
OCI_ATTR_ENCAPSULATION
attribute, 6-11
OCI_ATTR_ENV
server handle attribute, A-9
service context handle attribute, A-7
OCI_ATTR_EXTERNAL_NAME, 8-7,
8-16
server handle attribute, A-9
OCI_ATTR_EXTERNAL_USER_NAME, A-13
OCI_ATTR_FOCBK
server handle attribute, A-10
OCI_ATTR_HAS_DEFAULT
attribute, 6-17
OCI_ATTR_HAS_FILE
attribute, 6-9
OCI_ATTR_HAS_LOB
attribute, 6-9
OCI_ATTR_HAS_NESTED_TABLE
attribute, 6-9
OCI_ATTR_HW_MARK
attribute, 6-15
OCI_ATTR_IN_V8_MODE
server handle attribute, A-10
service context handle attribute, A-8
OCI_ATTR_INCR
attribute, 6-14
OCI_ATTR_INDEX_ONLY
attribute, 6-7
OCI_ATTR_INITIAL_CLIENT_ROLES, 8-17,
A-13
OCI_ATTR_INTERNAL_NAME, 8-7
server handle attribute, A-10
OCI_ATTR_IOMODE
attribute, 6-17
OCI_ATTR_IS_CONSTRUCTOR
attribute, 6-11
OCI_ATTR_IS_DESTRUCTOR
attribute, 6-11
OCI_ATTR_IS_INCOMPLETE_TYPE
attribute, 6-9
OCI_ATTR_IS_INVOKER_RIGHTS
attribute, 6-8,
6-10
OCI_ATTR_IS_MAP
attribute, 6-12
OCI_ATTR_IS_NULL
attribute, 6-15,
6-17
OCI_ATTR_IS_OPERATOR
attribute, 6-11
OCI_ATTR_IS_ORDER
attribute, 6-12
OCI_ATTR_IS_PREDEFINED_TYPE
attribute, 6-9
OCI_ATTR_IS_RNDS
attribute, 6-12
OCI_ATTR_IS_RNPS
attribute, 6-12
OCI_ATTR_IS_SELFISH
attribute, 6-12
OCI_ATTR_IS_SYSTEM_GENERATED_TYPE
attribute, 6-9
OCI_ATTR_IS_SYSTEM_TYPE
attribute, 6-9
OCI_ATTR_IS_TEMPORARY
attribute, 6-7
OCI_ATTR_IS_TRANSIENT_TYPE
attribute, 6-9
OCI_ATTR_IS_WNDS
attribute, 6-12
OCI_ATTR_IS_WNPS
attribute, 6-12
OCI_ATTR_LEVEL
attribute, 6-17
OCI_ATTR_LINK
attribute, 6-14,
6-18
OCI_ATTR_LIST_ARGUMENTS
attribute, 6-8,
6-11
OCI_ATTR_LIST_COLUMNS, A-41
attribute, 6-7
OCI_ATTR_LIST_OBJECTS
attribute, 6-19
OCI_ATTR_LIST_SCHEMAS
attribute, 6-19
OCI_ATTR_LIST_SUBPROGRAMS
attribute, 6-8
OCI_ATTR_LIST_TYPE
attribute, 6-18
OCI_ATTR_LIST_TYPE_ATTRS
attribute, 6-10
OCI_ATTR_LIST_TYPE_METHODS
attribute, 6-10
OCI_ATTR_LOBEMPTY
LOB locator attribute, A-26
OCI_ATTR_LOCKING_MODE
attribute, 6-20
OCI_ATTR_MAP_METHOD
attribute, 6-10
OCI_ATTR_MAX
attribute, 6-14
OCI_ATTR_MAX_CATALOG_ NAMELEN
attribute, 6-20
OCI_ATTR_MAX_COLUMN_ NAMELEN
attribute, 6-19
OCI_ATTR_MAX_PROC_NAMELEN
attribute, 6-19
OCI_ATTR_MAXDATA_SIZE
bind handle attribute, A-22
use with binding, 5-32
OCI_ATTR_MEMPOOL_APPNAME, A-50
OCI_ATTR_MEMPOOL_HOMENAME, A-50
OCI_ATTR_MEMPOOL_INSTNAME, A-51
OCI_ATTR_MEMPOOL_SIZE, A-51
OCI_ATTR_MIGSESSION
user session handle attribute, A-12
OCI_ATTR_MIN
attribute, 6-14
OCI_ATTR_NAME, A-42,
A-48
attribute, 6-8,
6-10,
6-11,
6-13,
6-14,
6-15,
6-16
OCI_ATTR_NCHARSET_ID
attribute, 6-19
OCI_ATTR_NONBLOCKING_MODE
server handle attribute, A-9
OCI_ATTR_NOWAIT_SUPORT
attribute, 6-20
OCI_ATTR_NUM_ATTRS
attribute, 6-5
OCI_ATTR_NUM_COLS, A-42,
A-43
attribute, 6-7
OCI_ATTR_NUM_DML_ERRORS, A-15
OCI_ATTR_NUM_ELEMENTS
attribute, 6-13
OCI_ATTR_NUM_HANDLES
attribute, 6-19
OCI_ATTR_NUM_PARAMS
attribute, 6-5
OCI_ATTR_NUM_ROWS, A-43
OCI_ATTR_NUM_TYPE_ATTRS
attribute, 6-9
OCI_ATTR_NUM_TYPE_METHODS
attribute, 6-10
OCI_ATTR_OBJ_ID, 6-5
OCI_ATTR_OBJ_NAME, 6-5
OCI_ATTR_OBJ_SCHEMA, 6-5
OCI_ATTR_OBJECT
environment handle attribute, A-4
OCI_ATTR_OBJECT_DETECTCHANGE
environment handle attribute, 13-13
OCI_ATTR_OBJID
attribute, 6-7,
6-14
OCI_ATTR_ORDER
attribute, 6-15
OCI_ATTR_ORDER_METHOD
attribute, 6-10
OCI_ATTR_OVERLOAD
attribute, 6-8
OCI_ATTR_PARAM
describe handle attribute, A-25
use when an attribute is itself a descriptor, 15-29
OCI_ATTR_PARAM_COUNT
describe handle attribute, A-25
statement handle attribute, A-18
OCI_ATTR_PARSE_ERROR_OFFSET, A-20
OCI_ATTR_PARTITIONED
attribute, 6-7
OCI_ATTR_PASSWORD
user session handle attribute, A-12
OCI_ATTR_PDSCL
bind handle attribute, A-22,
A-24
OCI_ATTR_PIN_DURATION
environment handle attribute, A-4
OCI_ATTR_PINOPTION
environment handle attribute, A-4
OCI_ATTR_POSITION
attribute, 6-16
OCI_ATTR_PRECISION, A-49
attribute, 6-5,
6-10,
6-13,
6-15,
6-17
OCI_ATTR_PREFETCH_MEMORY
statement handle attribute, A-19
OCI_ATTR_PREFETCH_ROWS
statement handle attribute, A-19
OCI_ATTR_PROC_MODE, A-51
OCI_ATTR_PROXY_CREDENTIALS, 8-16,
A-13
OCI_ATTR_PTYPE
attribute, 6-6
OCI_ATTR_RADIX
attribute, 6-17
OCI_ATTR_REF_TDO
attribute, 6-7,
6-9,
6-11,
6-14,
6-16,
6-18
OCI_ATTR_ROW_COUNT, A-44
OCI_ATTR_ROWID
statement handle attribute, A-18
OCI_ATTR_ROWS_RETURNED
bind handle attribute, A-23
use with callbacks, 5-30
OCI_ATTR_SAVEPOINT_SUPPORT
attribute, 6-20
OCI_ATTR_SCALE, A-49
attribute, 6-10,
6-13,
6-15,
6-17
OCI_ATTR_SCHEMA_NAME, A-42
attribute, 6-11,
6-13,
6-14,
6-16,
6-17
OCI_ATTR_SEQ
attributes, 6-14
OCI_ATTR_SERVER
service context handle attribute, A-7
OCI_ATTR_SERVER_GROUP
server handle attribute, A-11
OCI_ATTR_SERVER_STATUS
server handle attribute, A-11
OCI_ATTR_SESSION
service context handle attribute, A-7
OCI_ATTR_SHARED_HEAP_ALLOC, A-6
OCI_ATTR_SQLFNCODE
statement handle attribute, A-15
OCI_ATTR_STMT_TYPE
statement handle attribute, A-18
OCI_ATTR_STREAM_OFFSET, A-45
OCI_ATTR_SUB_NAME, A-43
attribute, 6-18
OCI_ATTR_SUBSCR_CALLBACK, A-38
OCI_ATTR_SUBSCR_CTX, A-38
OCI_ATTR_SUBSCR_NAME, A-39
OCI_ATTR_SUBSCR_NAMESPACE, A-38
OCI_ATTR_SUBSCR_PAYLOAD, A-39
OCI_ATTR_TABLESPACE
attribute, 6-7
OCI_ATTR_TIMESTAMP
attribute, 6-6
OCI_ATTR_TRANS
service context handle attribute, A-7
OCI_ATTR_TRANS_NAME, 8-4
transaction handle attribute, A-14
OCI_ATTR_TRANS_TIMEOUT
transaction handle attribute, A-14
OCI_ATTR_TYPE_NAME
attribute, 6-11,
6-13,
6-16,
6-17
OCI_ATTR_TYPECODE
attribute, 6-9,
6-10,
6-13,
6-16
OCI_ATTR_USRNAME
user session handle attribute, A-12
OCI_ATTR_VERSION
attribute, 6-9,
6-19
OCI_ATTR_XID, 8-4
transaction handle attribute, A-14
OCI_CONTINUE, 2-28
OCI_CRED_PROXY, 8-16
OCI_CRED_RDBMS, 8-16
OCI_DEFAULT, 8-23
OCI_DTYPE_AQAGENT, 2-14
OCI_DTYPE_AQDEQ_OPTIONS, 2-14
OCI_DTYPE_AQENQ_OPTIONS, 2-14
OCI_DTYPE_AQMSG_PROPERTIES, 2-14
OCI_DTYPE_AQNFY, 2-14
OCI_DTYPE_COMPLEXOBJECTCOMP, 2-14
OCI_DTYPE_FILE, 2-14
OCI_DTYPE_LOB, 2-14
OCI_DTYPE_PARAM, 2-14,
15-28,
15-40
use in code samples, 4-13
when used, 15-29
OCI_DTYPE_ROWID, 2-14
OCI_DTYPE_SNAP, 2-14
OCI_DURATION_SESSION, 15-111,
18-10
OCI_DURATION_STATEMENT, 15-111,
18-10
OCI_ERROR, 2-27,
8-8
OCI_EVENTS
mode for receiving notifications, 9-32
OCI_EXT_CRED, 8-16
OCI_HTYPE_BIND, 2-6
OCI_HTYPE_COMPLEXOBJECT, 2-6
OCI_HTYPE_COR, 15-40
OCI_HTYPE_DEFINE, 2-6
OCI_HTYPE_DESCRIBE, 2-6
OCI_HTYPE_DIRPATH_COLUMN_ARRAY, 2-7
OCI_HTYPE_DIRPATH_CTX, 2-6
OCI_HTYPE_DIRPATH_STREAM, 2-7
OCI_HTYPE_ENV, 2-6
OCI_HTYPE_ERROR, 2-6
OCI_HTYPE_PROC, 2-7
OCI_HTYPE_SERVER, 2-6
OCI_HTYPE_SESSION, 2-6
OCI_HTYPE_STMT, 2-6,
15-28,
15-40
OCI_HTYPE_SUBSCRIPTION, 2-6
OCI_HTYPE_SVCCTX, 2-6
OCI_HTYPE_TRANS, 2-6
OCI_INVALID_HANDLE, 2-28
OCI_LOCK_X_NOWAIT
parameter usage, 13-13
OCI_MIGRATE, 8-12
OCI_NEED_DATA, 2-28
OCI_NO_DATA, 2-27
OCI_NO_MUTEX, 8-23
OCI_NUM_SHARED_PROCS, 2-22
OCI_PTYPE_ARG
attributes, 6-16
OCI_PTYPE_COL
attributes, 6-15
OCI_PTYPE_COLL
attributes, 6-13
OCI_PTYPE_DATABASE
attributes, 6-19
OCI_PTYPE_FUNC
attributes, 6-8
OCI_PTYPE_LIST
attributes, 6-18
OCI_PTYPE_PKG
attributes, 6-8
OCI_PTYPE_PROC
attributes, 6-8
OCI_PTYPE_SCHEMA
attributes, 6-19
OCI_PTYPE_SYN
attributes, 6-14
OCI_PTYPE_TABLE
attributes, 6-7
OCI_PTYPE_TYPE
attributes, 6-9
OCI_PTYPE_TYPE_ATTR
attributes, 6-10
OCI_PTYPE_TYPE_FUNC
attributes, 6-11
OCI_PTYPE_TYPE_PROC
attributes, 6-11
OCI_PTYPE_VIEW
attributes, 6-7
OCI_SHARED_MODE, 2-22
OCI_STILL_EXECUTING, 2-28
OCI_SUCCESS, 2-27,
8-8
OCI_SUCCESS_WITH_INFO, 2-27
OCI_THREADED, 8-23
OCI_TRANS_LOOSE, 8-5
OCI_TRANS_READONLY, 8-4,
8-10
OCI_TRANS_RESUME, 8-10
OCI_TRANS_SERIALIZABLE, 8-4
OCI_TRANS_TIGHT, 8-5
OCI_TRANS_TWOPHASE, 8-10
OCI_TYPECODE
values, 3-23,
3-24,
3-25
OCIAQAgent
descriptor attributes, A-36
OCIAQDeq(), 15-5
OCIAQDeqOptions