Oracle Call Interface Programmer's Guide
Release 8.1.5
A67846-01
Library
Product
Contents
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
A
aborting OCI calls, 2-33
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-25
enqueue function, 15-7
examples, 15-8
OCI and, 9-25
OCI descriptors for, 9-25
OCI functions for, 9-25
OCI vs. PL/SQL, 9-26
advanced queuing functions, 15-4
advantages
OCI, 1-3
allocation duration
example, 13-14
of objects, 13-14
application failover
callback example, 9-20
callback registration, 9-20
OCI callbacks, 9-18
applications
linking, 2-36
AQ. See advanced queueing.
arguments
attributes, 6-16
arrays
binds, 12-3
defines, 12-6
skip parameter for, 5-20
arrays of structures, 5-17
indicator variables, 5-20
OCI calls used, 5-20
skip parameters, 5-18
atomic nullness, 10-29
attribute descriptor object, 11-23
attributes
of handles, 2-12
of objects, 10-17
of parameter descriptors, 6-5
of parameters, 6-5
authentication management, 8-10
authorize functions, 15-87
B
BFILE
datatype, 3-20
bind functions, 15-42
bind handle
attributes, A-20
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-11
PL/SQL, 5-5
positional vs. named, 5-4
ref cursor variables, 5-12
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-12
BLOB
datatype, 3-20
blocking modes, 2-36
branches
detaching, 8-7
resuming, 8-7
buffering LOB operations, 7-11
C
C datatypes
manipulating with OCI, 11-5
cache functions
server roundtrips, C-4
callbacks
application failover, 9-18
dynamic registrations, 9-15
for LOB operations, 7-13
for reading LOBs, 7-14
for writing LOBs, 7-15
from external procedures, 9-17
LOB streaming interface, 7-13
parameter modes, 15-63
registration for application failover, 9-20
restrictions, 9-16
user-defined functions, 9-11
canceling OCI calls, 2-33
CASE OTT parameter, 14-27
CHAR
external datatype, 3-16
character set form, 5-26
character set Id, 5-26
Unicode, A-20,
A-22
CHARZ
external datatype, 3-17
checkerr() function
code listing, 2-28
CLOB
datatype, 3-20
code
example programs, B-1
list of demonstration programs, B-1
CODE OTT parameter, 14-26
codes
functions, 15-230
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-16
attributes, A-26
complex object retrieval (COR) handle, 2-11
attributes, A-25
CONFIG OTT parameter, 14-27
connect functions, 15-87
connection mode
non-blocking, 2-36
consistency
of object cache, 13-4
copying
objects, 10-32
COR, see complex object retrieval
creating
objects, 10-32
D
data cartridges
OCI functions, xxxiv,
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
datatype code
internal, 3-5
datatype mapping
Oracle methodology, 11-4
OTT, 14-10
datatype mapping and manipulation functions
server roundtrips, C-6
datatypes
BFILE, 3-20
BLOB, 3-20
CLOB, 3-20
conversions, 3-21
direct path loading, 9-39,
A-47
external, 3-4,
3-7
FILE, 3-20
for piecewise operations, 5-33
internal, 3-3,
3-5
manipulating with OCI, 11-5
mapping from Oracle to C, 11-2
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-28
define functions, 15-42
define handle
attributes, A-22
description, 2-10
define operation, 4-14,
5-13,
12-4
example, 5-14
LOBs, 5-17
named datatypes, 5-16,
12-4
piecewise fetch, 5-17
PL/SQL output variables, 5-17
REFs, 5-16,
12-4
static arrays, 5-17
steps used, 5-14
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-11
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-10
describe functions, 15-42
describe handle
attributes, A-24
description, 2-11
describe operation
server roundtrips, C-5
descriptor, 2-14
allocating, 2-22
complex object retrieval, 2-16
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-37
column array handle attributes, A-42
column parameter attributes, A-44
context handle attributes, A-39
datatypes of columns, 9-39,
A-47
direct path column array handle, 9-40
direct path context handle, 9-39
direct path stream handle, 9-40
example, 9-42
functions, 9-41
handle attributes, A-39
handles, 9-39
limitations, 9-38
stream handle attributes, A-43
direct path loading functions, 15-72
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
environment handle
attributes, A-3
description, 2-8
error codes
define calls, 2-28
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-37
using OCIThread, 9-9
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-18
LONG, 3-13
LONG RAW, 3-15
LONG VARCHAR, 3-16
LONG VARRAW, 3-16
named data types, 3-18
NUMBER, 3-10
RAW, 3-14
REF, 3-18
ROWID, 3-13
SQLT_BLOB, 3-18
SQLT_CLOB, 3-18
SQLT_NCLOB, 3-18
SQLT_NTY, 3-18
SQLT_REF, 3-18
STRING, 3-11
UNSIGNED, 3-15
VARCHAR, 3-13
VARCHAR2, 3-8
VARNUM, 3-12
VARRAW, 3-15
external procedure functions
return codes, 18-3
with_context type, 18-3
external procedures
OCI callbacks, 9-17
F
fetch
piecewise, 5-32,
5-36
fetch operation, 4-14
LOB data, 4-15
setting prefetch count, 4-15
FILE
associating with OS file, 7-5
datatype, 3-20
locator, 7-4
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-230
new and updated calls, 1-12
G
global transactions, 8-4
GTRID. See transaction identifier
H
handle attributes, 2-12
reading, 2-12
setting, 2-12
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-12
process attributes, A-49
server handle, 2-9
service context handle, 2-9
statement handle, 2-10
subscription, 2-11,
9-31
transaction handle, 2-9
types, 2-6
user session handle, 2-9
HFILE OTT parameter, 14-26
I
indicator variable, 2-31
arrays of structures, 5-20
for named datatypes, 2-31,
2-33
for REF, 2-31
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-87
inserts
piecewise, 5-32,
5-34
INTEGER
external datatype, 3-11
internal datatypes, 3-3,
3-5
conversions, 3-21
datatype codes, 3-5
intype file
providing when running OTT, 14-8
structure of, 14-29
INTYPE OTT parameter, 14-25
K
key words, xxxv,
2-35
L
linking, 2-36
issues, 1-25
modes, 1-25
support for single-task, 1-27
lists
attributes, 6-18
LOB, 7-2
amount and offset parameters, 15-108
attributes of transient objects, 7-6
binding, 5-10
buffering, 7-11
callbacks, 7-13
character sets, 15-108
creating, 7-4
creating temporary, 7-18
defining, 5-17
duration of temporary, 7-18
example of temporary, 7-19
external datatypes, 3-18
fetching data, 4-15
fixed-width character sets, 15-108
freeing temporary, 7-18
locator, 2-15
modifying, 7-4
OCI functions, 7-6
temporary, 7-17
varying-width character sets, 15-108
LOB functions, 15-107
server roundtrips, C-2
LOB locator, 2-15,
7-2
attributes, A-25
locator, 2-14
for FILEs, 7-4
for LOB datatype, 2-15,
7-2
locking, 13-12
objects, 13-12
optimistic model, 13-13
LONG
external datatype, 3-13
LONG RAW
external datatype, 3-15
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-11,
15-103
miscellaneous functions, 15-215
multiple servers
executing statement against, 4-5
multi-threaded development
basic concepts, 8-15
N
named datatypes
binding, 5-10,
12-2
binding and defining, 12-6
defining, 5-16,
12-4
definition, 3-18
external datatypes, 3-18
indicator variable for, 2-31
indicator variables, 2-33
navigation, 13-17
navigational functions
error codes, 16-6
return values, 16-5
terminology, 16-4
NCHAR
issues, 5-26
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, xxxiv,
2-3
non-blocking mode, 2-36
example, 2-37
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-32
inserting, 2-32
inserting into database, 2-31
inserting using indicator variables, 2-31
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-5
LOB attributes of transient objects, 7-6
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-17
structure, 2-3
structure using objects, 10-4
terminating, 2-26
using the OTT with, 14-18
with objects
initializing, 10-10
OCI environment
initializing for objects, 10-10
OCI functions
canceling calls, 2-33
codes, 15-230
data cartridges, xxxiv,
2-3
new and updated calls, 1-12
NLS, xxxiv,
2-3
not supported, 1-21
obsolescent, 1-19
return codes, 2-27,
2-29
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-87
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-43
OCI_ATTR_BUF_SIZE, A-39,
A-43
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-20
define handle attribute, A-22
use of, 5-28
OCI_ATTR_CHARSET_FORM
attribute, 6-11,
6-14,
6-16
bind handle attribute, A-20
define handle attribute, A-23
OCI_ATTR_CHARSET_ID, A-39,
A-46
attribute, 6-11,
6-14,
6-16,
6-18,
6-19
bind handle attribute, A-20
define handle attribute, A-22
OCI_ATTR_CLUSTERED
attribute, 6-7
OCI_ATTR_COL_COUNT, A-42
OCI_ATTR_COLLECTION_ELEMENT
attribute, 6-9
OCI_ATTR_COLLECTION_TYPECODE
attribute, 6-9
OCI_ATTR_COMPLEXOBJECT_ COLL_OUTOFLINE
COR handle attribute, A-25
OCI_ATTR_COMPLEXOBJECT_LEVEL
COR handle attribute, A-25
OCI_ATTR_COMPLEXOBJECTCOMP _TYPE_LEVEL
COR descriptor attribute, A-26
OCI_ATTR_COMPLEXOBJECTCOMP_TYPE
COR descriptor attribute, A-26
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-47
attribute, 6-10,
6-13,
6-15,
6-16
OCI_ATTR_DATE_FORMAT, A-39
OCI_ATTR_DATEFORMAT, A-47
OCI_ATTR_DBA
attribute, 6-7
OCI_ATTR_DIRPATH_MODE, A-40
OCI_ATTR_DIRPATH_NOLOG, A-40
OCI_ATTR_DIRPATH_PARALLEL, A-40
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
server handle attribute, A-9
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_INTERNAL_NAME
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-40
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-25
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-21
use with binding, 5-27
OCI_ATTR_MEMPOOL_APPNAME, A-49
OCI_ATTR_MEMPOOL_HOMENAME, A-49
OCI_ATTR_MEMPOOL_INSTNAME, A-50
OCI_ATTR_MEMPOOL_SIZE, A-50
OCI_ATTR_MIGSESSION
user session handle attribute, A-12
OCI_ATTR_MIN
attribute, 6-14
OCI_ATTR_NAME, A-41,
A-47
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-41,
A-42
attribute, 6-7
OCI_ATTR_NUM_DML_ERRORS, A-14
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-42
OCI_ATTR_NUM_TYPE_ATTRS
attribute, 6-9
OCI_ATTR_NUM_TYPE_METHODS
attribute, 6-10
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-24
OCI_ATTR_PARAM_COUNT
describe handle attribute, A-24
statement handle attribute, A-17
OCI_ATTR_PARTITIONED
attribute, 6-7
OCI_ATTR_PASSWORD
user session handle attribute, A-12
OCI_ATTR_PDSCL
bind handle attribute, A-21,
A-23
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-48
attribute, 6-5,
6-10,
6-13,
6-15,
6-17
OCI_ATTR_PREFETCH_MEMORY
statement handle attribute, A-18
OCI_ATTR_PREFETCH_ROWS
statement handle attribute, A-18
OCI_ATTR_PROC_MODE, A-50
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-43
OCI_ATTR_ROWID
statement handle attribute, A-17
OCI_ATTR_ROWS_RETURNED
bind handle attribute, A-22
use with callbacks, 5-25
OCI_ATTR_SAVEPOINT_SUPPORT
attribute, 6-20
OCI_ATTR_SCALE, A-48
attribute, 6-10,
6-13,
6-15,
6-17
OCI_ATTR_SCHEMA_NAME, A-41
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_SESSION
service context handle attribute, A-7
OCI_ATTR_SHARED_HEAP_ALLOC, A-6
OCI_ATTR_STMT_TYPE
statement handle attribute, A-17
OCI_ATTR_STREAM_OFFSET, A-44
OCI_ATTR_SUB_NAME, A-42
attribute, 6-18
OCI_ATTR_SUBSCR_CALLBACK, A-37
OCI_ATTR_SUBSCR_CTX, A-37
OCI_ATTR_SUBSCR_NAME, A-38
OCI_ATTR_SUBSCR_NAMESPACE, A-37
OCI_ATTR_SUBSCR_PAYLOAD, A-38
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
transaction handle attribute, A-13
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
transaction handle attribute, A-13
OCI_EVENTS
mode for receiving notifications, 9-30
OCI_LOCK_X_NOWAIT
parameter usage, 13-13
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-21
OCI_TYPECODE
values, 3-23,
3-24,
3-25
OCIAQAgent
descriptor attributes, A-35
OCIAQDeq(), 15-5
OCIAQDeqOptions
descriptor attributes, A-28
OCIAQEnq(), 15-7
OCIAQEnqOptions
descriptor attributes, A-26
OCIAQListen(), 15-19
OCIAQMsgProperties
descriptor attributes, A-31
OCIArray, 11-17
binding and defining, 11-17,
12-6
OCIArray manipulation
code example, 11-19
OCIAttrGet(), 15-28
used for describing, 4-11
OCIAttrSet(), 15-29
OCIBindArrayOfStruct(), 15-43
OCIBindByName(), 15-44
OCIBindByPos(), 15-48
OCIBindDynamic(), 15-52
OCIBindObject(), 15-56
OCIBreak(), 15-216
use of, 2-33,
2-37
OCICacheFlush(), 16-9
OCICacheFree(), 16-48
OCICacheRefresh(), 16-11
OCICacheUnmark(), 16-17
OCICacheUnpin(), 16-49
OCIColl, 11-17
binding and defining, 11-17
OCICollAppend(), 17-6
OCICollAssign(), 17-7
OCICollAssignElem(), 17-8
OCICollGetElem(), 17-10
OCICollIsLocator(), 17-13
OCICollMax(), 17-14
OCICollSetUpdateStatus(), 17-15
OCICollSize(), 17-16
OCICollTrim(), 17-18
OCIComplexObject
use of, 10-23
OCIComplexObjectComp
use of, 10-23
OCIDate, 11-7
binding and defining, 11-7,
12-6
OCIDate manipulation
code example, 11-8
OCIDateAddDays(), 17-28
OCIDateAddMonths(), 17-29
OCIDateAssign(), 17-30
OCIDateCheck(), 17-31
OCIDateCompare(), 17-33
OCIDateDaysBetween(), 17-34
OCIDateFromText(), 17-35
OCIDateGetDat(), 17-37
OCIDateGetTime(), 17-38
OCIDateLastDay(), 17-39
OCIDateNextDay(), 17-40
OCIDateSetDate(), 17-41
OCIDateSetTime(), 17-42
OCIDateSysDate(), 17-43
OCIDateToText(), 17-44
OCIDateZoneToZone(), 17-46
OCIDefineArrayOfStruct(), 15-58
OCIDefineByPos(), 15-59
OCIDefineDynamic(), 15-63
OCIDefineObject(), 15-65
OCIDescAlloc(), 15-31
OCIDescFree(), 15-33
OCIDescribeAny(), 15-67
usage examples, 6-20
using, 6-2
OCIDirPathAbort(), 15-73
OCIDirPathColArrayEntryGet(), 15-74
OCIDirPathColArrayEntrySet(), 15-76
OCIDirPathColArrayReset(), 15-79
OCIDirPathColArrayRowGet(), 15-78
OCIDirPathColArrayToStream(), 15-80
