Skip Headers

Oracle® Call Interface Programmer's Guide
10g Release 1 (10.1)
Part Number B10779-01
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Master Index
Master Index		 Go to Feedback page
Feedback
Go to previous page
Previous
 View PDF

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

ADO. See attribute descriptor object
ADT. See object type
advantages
OCI, 1-3
allocation duration
example, 13-16
of objects, 13-15
application failover
callback registration, 9-43
OCI callbacks, 9-41
AQ. See Streams Advanced Queuing.
argument attributes, 6-17
arrays
binds, 11-34
defines, 11-37
DML, maximum rows, 5-4
skip parameter for, 5-24
arrays of structures, 5-23
indicator variables, 5-25
OCI calls used, 5-25
skip parameters, 5-23
atomic NULLs, 10-30
attribute descriptor object, 11-25
attributes
of handles, 2-12
of objects, 10-17
of parameter descriptors, 6-5
of parameters, 6-5
authentication
by Distinguished Name, 8-15
by X.509 Certificate, 8-15
management, 8-10
authentication information handle attributes, A-16
authorize functions, 15-4

B

batch error mode, 4-8, 4-9
BFILE
datatype, 3-23
bin directory, D-2
BINARY_DOUBLE, 3-7
BINARY_FLOAT, 3-7
bind functions, 15-68
bind handle
attributes, A-36
description, 2-10
bind operation, 4-5, 5-2, 11-32
associations made, 5-2
example, 5-6
initializing variables, 5-3
LOBs, 5-10
named datatypes, 11-32
named versus positional, 5-3
OCI array interface, 5-4
OCI_DATA_AT_EXEC mode, 5-16
PL/SQL, 5-4
positional versus named, 5-3
REF cursor variables, 5-17
REFs, 11-33
steps used, 5-6
binding
arrays, 11-34
buffer expansion, 5-34
OCINumber, 11-39
PL/SQL placeholders, 2-37
summary, 5-9
BLOB
datatype, 3-23
BLOBs (binary large objects)
datatype, 3-23
blocking modes, 2-35
branches
detaching, 8-6
resuming, 8-6
buffer expansion during binding, 5-34
buffering LOB operations, 7-11
building OCI applications on Unix, B-1

C

C datatypes
manipulating with OCI, 11-4
cache functions
server round trips, C-5
callbacks
application failover, 9-41
dynamic registrations, 9-35
for LOB operations, 7-14
for reading LOBs, 7-14
for writing LOBs, 7-16
from external procedures, 9-40
LOB streaming interface, 7-14
parameter modes, 15-98
registration for application failover, 9-43
restrictions, 9-38
user-defined functions, 9-30
canceling OCI calls, 2-32
cancelling a cursor, 16-13
cartridge functions, 19-1
CASE OTT parameter, 14-32
cdemomt.c, D-3
CHAR
external datatype, 3-18
character length semantics, 5-34, 5-35, 6-23
character set form, 5-30
character set ID, 5-30
Unicode, A-36, A-40
CHARZ
external datatype, 3-19
CLOB
datatype, 3-23
code
example programs, B-1
list of demonstration programs, B-1
CODE OTT parameter, 14-30
coding guidelines
reserved words, 2-33
coherency
of object cache, 13-4
collections
attributes, 6-12
data manipulation functions, 11-18
describing, 6-2
description, 11-17
functions for manipulating, 11-18
multi level, 11-22
scanning functions, 11-19
column objects
direct path loading of, 12-19
columns
attributes, 6-5, 6-15
commit, 2-24
in object applications, 13-15
one-phase for global transactions, 8-7
two-phase for global transactions, 8-7
compiling
OCI applications, D-3
OCI with Oracle XA, D-5
Oracle XA Library, D-5
complex object retrieval, 10-21
implementing, 10-24
navigational prefetching, 10-25
complex object retrieval (COR) descriptor, 2-17
attributes, A-43
complex object retrieval (COR) handle, 2-11
attributes, A-43
CONFIG OTT parameter, 14-31
configuration files, D-2
location, D-2
connect functions, 15-4
connection mode
nonblocking, 2-35
connection pooling, 9-10, 9-23
code example, 9-17
consistency
of object cache, 13-4
copying
objects, 10-33
COR, see complex object retrieval
creating
objects, 10-33
cursor cancellation, 16-13

D

data cartridges
OCI functions, 2-2, 19-1
data definition language
SQL statements, 1-7
data manipulation language
SQL statements, 1-7
data structures
new for 8.0, 2-4
database connection
for object applications, 10-10
databases
attributes, 6-20
describing, 6-2
datatypes
ANSI DATE, 3-24
BFILE, 3-23
binding and defining, 11-38
BLOBs (binary large objects), 3-23
CLOB, 3-23
conversions, 3-27
direct path loading, 12-3, A-74
external, 3-4, 3-8
FILE, 3-23
for piecewise operations, 5-41
internal, 3-4
internal codes, 3-5
INTERVAL DAY TO SECOND, 3-26
INTERVAL YEAR TO MONTH, 3-25
manipulating with OCI, 11-4
mapping and manipulation functions, C-7
mapping from Oracle to C, 11-2
mapping, Oracle methodology, 11-4
mapping, OTT, 14-10
NCLOB, 3-24
Oracle, 3-2
TIMESTAMP, 3-24
TIMESTAMP WITH LOCAL TIME ZONE, 3-25
TIMESTAMP WITH TIME ZONE, 3-25
DATE
external datatype, 3-15
date cache, 12-15
DATE, ANSI
datatype, 3-24
datetime
avoiding unexpected results, 3-26
datetime and date
migration rules, 3-31
DDL. See data definition language
default file name extensions
OTT, 14-41
default name mapping
OTT, 14-41
define
arrays, 11-37
return and error codes, 2-27
define functions, 15-68
define handle
attributes, A-39
description, 2-10
define operation, 4-16, 5-17, 11-35
example, 5-18
LOBs, 5-20
named datatypes, 11-35
piecewise fetch, 5-22
PL/SQL output variables, 5-22
REFs, 11-35
steps used, 5-18
defining
OCINumber, 11-39
deletes
positioned, 2-33
demonstration programs, B-1, D-3
list, B-1
describe
explicit, 4-15
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-68
describe handle
attributes, A-41
description, 2-10
describe operation
server round trips, C-6
describe, explicit, 4-12
describe, implicit, 4-12
descriptor, 2-13
allocating, 2-21
complex object retrieval, 2-17
objects, 11-25
parameter, 2-16
ROWID, 2-16
snapshot, 2-15
descriptor functions, 15-48
descriptor objects, 11-25
detaching branches, 8-6
direct path
of date columns, 12-15
direct path function context, 12-5
direct path handles, 2-11
direct path loading, 12-2
column array handle attributes, A-69
column parameter attributes, A-71
context handle attributes, A-60
datatypes of columns, 12-3, A-74
direct path column array handle, 12-6
direct path context handle, 12-5
direct path stream handle, 12-7
example, 12-9
functions, 12-8, 16-149
handle attributes, A-60
handles, 12-4
in pieces, 12-34
limitations, 12-9
stream handle attributes, A-70
directory structures, D-2
DML. See data manipulation language
DML with RETURNING clause
See RETURNING clause
duration
example, 13-16
of objects, 13-15
dynamic registration
Oracle XA Library, D-6

E

embedded objects
fetching, 10-15
embedded SQL, 1-10
mixing with OCI calls, 1-10
EMP table, D-3
enhanced DML array, 4-9
enhanced DML array feature, 4-8
environment handle
attributes, A-3
description, 2-8
error codes
define calls, 2-27
navigational functions, 17-6
error handle
attributes, A-10
description, 2-8
errors
handling, 2-26
handling in object applications, 10-37
ERRTYPE OTT parameter, 14-31
example
demonstration programs, B-1
nonblocking mode, 2-36
executing SQL statements, 4-7
execution
against multiple servers, 4-5
modes, 4-8
execution snapshots, 4-8
explicit describe, 4-12
extensions
OTT default file name, 14-41
external datatypes, 3-4, 3-8
CHAR, 3-18
CHARZ, 3-19
conversions, 3-27
DATE, 3-15
FLOAT, 3-13
INTEGER, 3-12
LOBs, 3-21
LONG, 3-15
LONG RAW, 3-17
LONG VARCHAR, 3-17
LONG VARRAW, 3-18
named datatypes, 3-20
NUMBER, 3-11
RAW, 3-16
REF, 3-20
ROWID, 3-21
SQLT_BLOB, 3-21
SQLT_CLOB, 3-21
SQLT_NCLOB, 3-21
SQLT_NTY, 3-20
SQLT_REF, 3-20
STRING, 3-13
UNSIGNED, 3-17
VARCHAR, 3-15
VARCHAR2, 3-10
VARNUM, 3-14
VARRAW, 3-17
external procedure functions
return codes, 19-3
with_context type, 19-3
external procedures
OCI callbacks, 9-40
Externally Initialized Context, 8-21

F

failover
callback example, 9-43
failover callbacks, 9-41
failover callbacks structure and parameters, 9-42
fetch
piecewise, 5-40, 5-45
fetch operation, 4-16
LOB data, 4-17
setting prefetch count, 4-17
FILE
associating with OS file, 7-3
datatype, 3-23
fine grained access control
partitioned, 8-16
FLOAT
external datatype, 3-13
flushing, 13-11
object changes, 10-14
objects, 13-11
freeing
objects, 10-33, 13-9
functions
attributes, 6-8

G

generic documentation references
compiling and linking OCI applications, D-3, D-4
demonstration programs, D-3
invoking OTT from the command line, D-8
thread safety, D-3
XA linking file names
global transactions, 8-3
globalization support, 2-39
OCI functions, 2-2
GTRID. See transaction identifier

H

handle attributes, 2-12
reading, 2-12
setting, 2-12
handle functions, 15-48
handles, 2-4
advantages of, 2-8
allocating, 2-6, 2-21
bind handle, 2-10
C datatypes, 2-5
child freed when parent freed, 2-8
define handle, 2-10
describe handle, 2-10
direct path, 2-11
environment handle, 2-8
error handle, 2-8
freeing, 2-6
process attributes, A-77
server handle, 2-9
service context handle, 2-8
statement handle, 2-10
subscription, 2-11, 9-57
transaction handle, 2-9
types, 2-5
user session handle, 2-9
header files
location of, D-2, D-3
HFILE OTT parameter, 14-31

I

implicit describe, 4-12
include directory, D-2
indicator variables, 2-30
arrays of structures, 5-25
for named datatypes, 2-29, 2-31
for REF, 2-29
for REFs, 2-31
named datatype defines, 11-36
PL/SQL OUT binds, 11-36
REF defines, 11-36
with named datatype bind, 11-34
with REF bind, 11-34
INITFILE OTT parameter, 14-30
INITFUNC OTT parameter, 14-31
initialize functions, 15-4
inserts
piecewise, 5-40, 5-42
Instant Client feature, 1-22
INTEGER
external datatype, 3-12
internal codes for datatypes
datatype codes, 3-5
internal datatypes, 3-4
conversions, 3-27
INTERVAL DAY TO SECOND datatype, 3-26
INTERVAL YEAR TO MONTH datatype, 3-25
intype file
providing when running OTT, 14-9
structure of, 14-34
INTYPE File Assistant, D-7
INTYPE OTT parameter, 14-29

K

key words, 2-33

L

LDAP registration of publish-subscribe notification, 9-59
libraries
oci.lib, D-4
linking
OCI applications, D-4
OCI with Oracle XA, D-5
Oracle XA Library, D-5
lists
attributes, 6-19
lmsgen utility, 2-47
LoadLibrary, D-4
LOB functions, 16-23
server round trips, C-3
LOB locator, 2-15
attributes, A-42
LOBs
amount and offset parameters, 16-25
attributes of transient objects, 7-4
binding, 5-10
buffering, 7-11
callbacks, 7-14
character sets, 16-25
creating, 7-2
creating temporary, 7-18
defining, 5-20
duration of temporary, 7-19
example of temporary, 7-20
external datatypes, 3-21
failover does not work, 9-45
fetching data, 4-17
fixed-width character sets, 16-25
freeing temporary, 7-18
greater than 4GB, 7-5
locator, 2-15
modifying, 7-2
OCI functions, 7-10
size maximum, 7-5
temporary, 7-17
varying-width character sets, 16-25
locator, 2-13
for LOB datatype, 2-15
locking, 13-13
objects, 13-13
optimistic model, 13-14
LONG
external datatype, 3-15
LONG RAW
external datatype, 3-17
LONG VARCHAR
external datatype, 3-17
LONG VARRAW
external datatype, 3-18

M

make.bat, D-3
Makefile (Unix), B-1
marking
objects, 13-10
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-25
migration
7.x to 8.0, 1-20
session, 8-10, 15-32
miscellaneous functions, 16-215
multiple servers
executing statement against, 4-5
multithreaded development
basic concepts, 9-2
multithreading, D-3

N

named datatypes
binding, 11-32
binding and defining, 11-38
defining, 11-35
definition, 3-20
external datatypes, 3-20
indicator variables, 2-31
indicator variables for, 2-29
native double, 3-26
native float, 3-26
navigation, 13-18
navigational functions
error codes, 17-6
return values, 17-5
terminology, 17-3
NCHAR
issues, 5-30
NCLOB
datatype, 3-24
nested table
element ordering, 11-21
functions for manipulating, 11-21
nested tables
direct path loading of, 12-17
NLS_LANG, 2-39
NLS_NCHAR, 2-39
nonblocking mode, 2-35
example, 2-36
non-final object tables
direct path loading of, 12-33
no-op
definition, 17-24
NULL indicator
setting for an object attribute, 10-32
NULL indicator struct, 10-30
generated by OTT, 10-8
nullness
of objects, 10-30
NULLs
atomic, 10-30
inserting, 2-30
inserting into database, 2-29
inserting using indicator variables, 2-29
NUMBER
external datatype, 3-11

O

object
view, 10-20
object applications
commit, 13-15
database connection, 10-10
rollback, 13-15
object cache, 13-2
coherency, 13-4
consistency, 13-4
initializing, 10-9
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 round trips, C-5
object identifier
for persistent objects, 10-5
object reference, 10-35
object reference. See REFs
object runtime environment
initializing, 10-9
object tables
direct path loading of, 12-32
object type
representing in C applications, 10-8
object type translator
sample output, 10-8
See OTT
use with OCI, 10-8
Object Type Translator (OTT), D-7
objects
accessing with OCI, 14-23
allocation duration, 13-15
array pin, 10-13
attributes, 10-17
manipulating, 10-13
client-side cache, 13-2
copying, 10-33
creating, 10-33
duration, 13-15
flushing, 13-11
flushing changes, 10-14
freeing, 10-33, 13-9
lifetime, 17-2
LOB attributes of transient objects, 7-4
locking, 13-13
manipulating with OCI, 14-23
marking, 10-14, 13-10
memory layout of instance, 13-17
memory management, 13-2
meta-attributes, 10-17
navigation, 13-18
simple, 13-18
NCHAR and NVARCHAR2 attribute of, 11-3
NULLs, 10-30
OCI object application structure, 10-3
persistent, 10-5
pin count, 10-29
pin duration, 13-15
pinning, 10-11, 13-7
refreshing, 13-12
secondary memory, 13-17
terminology, 17-2
top-level memory, 13-17
transient, 10-5, 10-6
types, 10-5, 17-2
unmarking, 13-10
unpinning, 10-29, 13-9
use with OCI, 10-2
OCI, 11-31
aborting calls, 2-32
accessing and manipulating objects, 14-23
advantages, 1-3
object support, 1-5
Oracle XA Library, D-5
overview, 1-2
parts of, 1-4
sample programs, D-3
OCI application
compiling, 1-3
general structure, 2-2
initialization example, 2-22
linking, 1-3
steps, 2-18
structure, 2-2
structure using objects, 10-3
terminating, 2-25
using the OTT with, 14-22
with objects
initializing, 10-9
OCI applications
compiling, D-3
linking, D-4
running, D-5
oci directory, D-2
OCI environment
initializing for objects, 10-9
OCI functions
canceling calls, 2-32
data cartridges, 2-2
globalization, 2-2
not supported, 1-20
obsolescent, 1-18
return codes, 2-26, 2-28
OCI navigational functions, 13-20
flush functions, 13-21
mark functions, 13-21
meta-attribute accessor functions, 13-22
miscellaneous functions, 13-22
naming scheme, 13-20
pin/unpin/free functions, 13-20
OCI process
initializing for objects, 10-9
OCI program. See OCI application
OCI relational functions
connect, authorize, and initialize, 15-4
guide to reference entries, 19-2
Streams Advanced Queuing and publish-subscribe, 16-114
OCI_ATTR_ACTION, 8-21, A-16
OCI_ATTR_AGENT_ADDRESS, A-54
OCI_ATTR_AGENT_NAME, A-54
OCI_ATTR_AGENT_PROTOCOL, A-55
OCI_ATTR_ALLOC_DURATION
environment handle attribute, A-8
OCI_ATTR_APPCTX_ATTR, 8-22, A-17
OCI_ATTR_APPCTX_LIST, 8-22, A-17
OCI_ATTR_APPCTX_NAME, 8-22
OCI_ATTR_APPCTX_SIZE, 8-22, A-17
OCI_ATTR_APPCTX_VALUE, 8-22, A-18
OCI_ATTR_ATTEMPTS, A-49
OCI_ATTR_AUTOCOMMIT_DDL
attribute, 6-21
OCI_ATTR_BIND_DN, A-3
OCI_ATTR_BUF_ADDR, A-70
OCI_ATTR_BUF_SIZE, A-60, A-70
OCI_ATTR_CACHE
attribute, 6-15
OCI_ATTR_CACHE_ARRAYFLUSH, 13-11
environment handle attribute, A-4
OCI_ATTR_CACHE_MAX_SIZE, 13-5
environment handle attribute, A-4
OCI_ATTR_CACHE_OPT_SIZE, 13-5
environment handle attribute, A-4
OCI_ATTR_CALL_TIME, 8-20, A-18
OCI_ATTR_CATALOG_LOCATION
attribute, 6-20
OCI_ATTR_CERTIFICATE, A-18
OCI_ATTR_CERTIFICATE_TYPE, A-18
OCI_ATTR_CHAR_COUNT
bind handle attribute, A-36
define handle attribute, A-39
OCI_ATTR_CHAR_SIZE, 6-15
attribute, 6-23
OCI_ATTR_CHAR_USED, 6-15
attribute, 6-24
OCI_ATTR_CHARSET_FORM, 5-31, 6-18
attribute, 6-11, 6-14, 6-16
bind handle attribute, A-36
define handle attribute, A-39
OCI_ATTR_CHARSET_ID, 5-31, A-61, A-74
attribute, 6-11, 6-14, 6-16, 6-18, 6-20
bind handle attribute, A-36
define handle attribute, A-40
OCI_ATTR_CLIENT_IDENTIFIER, 8-16, A-19
OCI_ATTR_CLIENT_INFO, 8-21, A-19
OCI_ATTR_CLUSTERED
attribute, 6-7
OCI_ATTR_COL_COUNT, A-69
OCI_ATTR_COLLECT_CALL_TIME, 8-20, A-19
OCI_ATTR_COLLECTION_ELEMENT
attribute, 6-9
OCI_ATTR_COLLECTION_TYPECODE
attribute, 6-9
OCI_ATTR_COMMENT
attribute, 6-21, 6-22
OCI_ATTR_COMPLEXOBJECT_ COLL_OUTOFLINE
COR handle attribute, A-43
OCI_ATTR_COMPLEXOBJECT_LEVEL
COR handle attribute, A-43
OCI_ATTR_COMPLEXOBJECTCOMP _TYPE_LEVEL
COR descriptor attribute, A-44
OCI_ATTR_COMPLEXOBJECTCOMP_TYPE
COR descriptor attribute, A-43
OCI_ATTR_CONDITION
attribute, 6-21
OCI_ATTR_CONN_BUSY_COUNT, A-23
OCI_ATTR_CONN_INCR, A-24
OCI_ATTR_CONN_MAX, A-24
OCI_ATTR_CONN_MIN, A-23
OCI_ATTR_CONN_NOWAIT, A-22, A-23
OCI_ATTR_CONN_OPEN_COUNT, A-23
OCI_ATTR_CONN_TIMEOUT, A-22
OCI_ATTR_CONSUMER_NAME, A-45
OCI_ATTR_CORRELATION, A-46, A-50
OCI_ATTR_CURRENT_POSITION
attribute, 4-19, A-28
OCI_ATTR_CURSOR_COMMIT_ BEHAVIOR
attribute, 6-20
OCI_ATTR_DATA_SIZE, 6-15, 6-23, A-74
attribute, 6-10, 6-13, 6-16, 6-17
OCI_ATTR_DATA_TYPE, A-74
attribute, 6-10, 6-13, 6-16, 6-17
OCI_ATTR_DATE_FORMAT, A-61
OCI_ATTR_DATEFORMAT, A-75
OCI_ATTR_DBA
attribute, 6-7
OCI_ATTR_DELAY, A-50
OCI_ATTR_DEQ_MODE, A-46
OCI_ATTR_DEQ_MSGID, A-47
OCI_ATTR_DESC_PUBLIC, 15-104
OCI_ATTR_DIRPATH_DCACHE_DISABLE, 12-16, A-61
OCI_ATTR_DIRPATH_DCACHE_HITS, 12-16, A-62
OCI_ATTR_DIRPATH_DCACHE_MISSES, 12-16, A-62
OCI_ATTR_DIRPATH_DCACHE_NUM, 12-16, A-62
OCI_ATTR_DIRPATH_DCACHE_SIZE, 12-16, A-63
OCI_ATTR_DIRPATH_EXPR_TYPE direct path function attribute, A-67
OCI_ATTR_DIRPATH_EXPR_TYPE function context attribute, 12-37
OCI_ATTR_DIRPATH_INDEX_MAINT_METHOD, A-63
OCI_ATTR_DIRPATH_MODE, A-63
OCI_ATTR_DIRPATH_NOLOG, A-64
OCI_ATTR_DIRPATH_OBJ_CONSTR, 12-36, A-64
OCI_ATTR_DIRPATH_OBJ_CONSTR direct path context attribute, 12-35
OCI_ATTR_DIRPATH_OID, A-75
OCI_ATTR_DIRPATH_PARALLEL, 12-3, A-64
OCI_ATTR_DIRPATH_SID column array attribute, 12-43
OCI_ATTR_DIRPATH_SKIPINDEX_METHOD, A-65
OCI_ATTR_DISTINGUISHED_NAME, 8-15, A-20
OCI_ATTR_DML_ROW_OFFSET
error handle attribute, A-10
OCI_ATTR_DN_COUNT, A-55
OCI_ATTR_DURATION
attribute, 6-7
OCI_ATTR_ENCAPSULATION
attribute, 6-12
OCI_ATTR_ENQ_TIME, A-51
OCI_ATTR_ENV, A-28
server handle attribute, A-13
service context handle attribute, A-11
OCI_ATTR_ENV_CHARSET_ID, 2-40
environment handle attribute, A-5
OCI_ATTR_ENV_NCHARSET_ID, 2-40
environment handle attribute, A-5
OCI_ATTR_ENV_UTF16
environment handle attribute, A-5
OCI_ATTR_EVAL_CONTEXT_NAME
attribute, 6-21, 6-22
OCI_ATTR_EVAL_CONTEXT_OWNER
attribute, 6-21, 6-22
OCI_ATTR_EVALUATION_FUNCTION
attribute, 6-22
OCI_ATTR_EXCEPTION_QUEUE, A-51
OCI_ATTR_EXPIRATION, A-51
OCI_ATTR_EXTERNAL_NAME, 8-7
server handle attribute, A-13
OCI_ATTR_FOCBK
server handle attribute, A-14
OCI_ATTR_FSPRECISION
attribute, 6-11
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_HEAPALLOC
environment handle attribute, A-9
OCI_ATTR_HW_MARK
attribute, 6-15
OCI_ATTR_IN_V8_MODE
server handle attribute, A-14
service context handle attribute, A-11
OCI_ATTR_INCR
attribute, 6-15
OCI_ATTR_INDEX_ONLY
attribute, 6-7
OCI_ATTR_INITIAL_CLIENT_ROLES, 8-16, A-20
OCI_ATTR_INTERNAL_NAME, 8-7
server handle attribute, A-14
OCI_ATTR_IOMODE
attribute, 6-18
OCI_ATTR_IS_CONSTRUCTOR
attribute, 6-12
OCI_ATTR_IS_DESTRUCTOR
attribute, 6-12
OCI_ATTR_IS_FINAL_METHOD
attribute, 6-12
OCI_ATTR_IS_FINAL_TYPE
attribute, 6-10
OCI_ATTR_IS_INCOMPLETE_TYPE
attribute, 6-9
OCI_ATTR_IS_INSTANTIABLE_METHOD
attribute, 6-12
OCI_ATTR_IS_INSTANTIABLE_TYPE
attribute, 6-10
OCI_ATTR_IS_INVOKER_RIGHTS
attribute, 6-8, 6-10
OCI_ATTR_IS_MAP
attribute, 6-12
OCI_ATTR_IS_NULL
attribute, 6-16, 6-18
OCI_ATTR_IS_OPERATOR
attribute, 6-12
OCI_ATTR_IS_ORDER
attribute, 6-12
OCI_ATTR_IS_OVERRIDING_METHOD
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_SUBTYPE
attribute, 6-10
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_LDAP_AUTH, A-6
OCI_ATTR_LDAP_CRED, A-6
OCI_ATTR_LDAP_CTX, A-7
OCI_ATTR_LDAP_HOST, A-7
OCI_ATTR_LDAP_PORT, A-7
OCI_ATTR_LEVEL
attribute, 6-17
OCI_ATTR_LFPRECISION
attribute, 6-11
OCI_ATTR_LINK
attribute, 6-14, 6-18
OCI_ATTR_LIST_ACTION_CONTEXT
attribute, 6-21
OCI_ATTR_LIST_ARGUMENTS
attribute, 6-8, 6-12
OCI_ATTR_LIST_COLUMNS, A-65
attribute, 6-7
OCI_ATTR_LIST_COLUMNS direct path function context attribute, A-67
OCI_ATTR_LIST_OBJECTS
attribute, 6-20
OCI_ATTR_LIST_RULES
attribute, 6-22
OCI_ATTR_LIST_SCHEMAS
attribute, 6-20
OCI_ATTR_LIST_SUBPROGRAMS
attribute, 6-8
OCI_ATTR_LIST_TABLE_ALIASES
attribute, 6-22
OCI_ATTR_LIST_TYPE
attribute, 6-19
OCI_ATTR_LIST_TYPE_ATTRS
attribute, 6-9
OCI_ATTR_LIST_TYPE_METHODS
attribute, 6-9
OCI_ATTR_LIST_VARIABLE_TYPES
attribute, 6-22
OCI_ATTR_LOBEMPTY
LOB locator attribute, A-42
OCI_ATTR_LOCKING_MODE
attribute, 6-21
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-20
OCI_ATTR_MAX_PROC_NAMELEN
attribute, 6-20
OCI_ATTR_MAXCHAR_SIZE, A-37, A-40
attribute, 5-33
OCI_ATTR_MAXCHAR_SIZE attribute, 5-33
OCI_ATTR_MAXDATA_SIZE
attribute, 5-33
bind handle attribute, A-37
use with binding, 5-33
OCI_ATTR_MEMPOOL_APPNAME, A-77
OCI_ATTR_MEMPOOL_HOMENAME, A-78
OCI_ATTR_MEMPOOL_INSTNAME, A-78
OCI_ATTR_MEMPOOL_SIZE, A-78
OCI_ATTR_MIGSESSION
user session handle attribute, A-20
OCI_ATTR_MIN
attribute, 6-14
OCI_ATTR_MODULE, 8-21, A-21
OCI_ATTR_MSG_STATE, A-52
OCI_ATTR_NAME, A-65, A-76
attribute, 6-8, 6-10, 6-12, 6-13, 6-14, 6-16, 6-17, 6-22, 6-23
OCI_ATTR_NAME column array attribute, 12-41
OCI_ATTR_NAME direct path function context attribute, A-68
OCI_ATTR_NAME function context attribute, 12-36
OCI_ATTR_NAVIGATION, A-47
OCI_ATTR_NCHARSET_ID
attribute, 6-20
OCI_ATTR_NONBLOCKING_MODE
server handle attribute, 2-35, A-15
OCI_ATTR_NOWAIT_SUPORT
attribute, 6-21
OCI_ATTR_NUM_COLS, A-66, A-69
attribute, 6-7
OCI_ATTR_NUM_COLS direct path function context attribute, 12-38, A-68
OCI_ATTR_NUM_DML_ERRORS, A-29
OCI_ATTR_NUM_ELEMENTS
attribute, 6-13
OCI_ATTR_NUM_HANDLES attribute, 6-19
OCI_ATTR_NUM_PARAMS
attribute, 6-6
OCI_ATTR_NUM_ROWS, A-69
OCI_ATTR_NUM_ROWS attribute, 12-44
OCI_ATTR_NUM_ROWS direct path context attribute, A-66
OCI_ATTR_NUM_ROWS direct path function context attribute, A-69
OCI_ATTR_NUM_ROWS function context attribute, 12-40
OCI_ATTR_NUM_TYPE_ATTRS
attribute, 6-9
OCI_ATTR_NUM_TYPE_METHODS
attribute, 6-9
OCI_ATTR_OBJ_ID
attribute, 6-6
OCI_ATTR_OBJ_NAME
attribute, 6-6
OCI_ATTR_OBJ_SCHEMA
attribute, 6-6
OCI_ATTR_OBJECT
environment handle attribute, A-7
OCI_ATTR_OBJECT_DETECTCHANGE, 13-15
environment handle attribute, 13-14, A-9
OCI_ATTR_OBJECT_NEWNOTNULL, 17-48
environment handle attribute, A-9
OCI_ATTR_OBJID
attribute, 6-7, 6-14
OCI_ATTR_ORDER
attribute, 6-15
OCI_ATTR_ORDER_METHOD
attribute, 6-10
OCI_ATTR_ORIGINAL_MSGID, A-54
OCI_ATTR_OVERLOAD
attribute, 6-8
OCI_ATTR_PARAM
describe handle attribute, A-41
use when an attribute is itself a descriptor, 15-50
OCI_ATTR_PARAM_COUNT
describe handle attribute, A-42
OCI_ATTR_PARAM_COUNT statement handle attribute, A-29
OCI_ATTR_PARSE_ERROR_OFFSET statement handle attribute, A-30
OCI_ATTR_PARTITIONED
attribute, 6-7
OCI_ATTR_PASSWORD, 8-17
user session handle attribute, A-21
OCI_ATTR_PDPRC, A-38, A-40
OCI_ATTR_PDSCL
bind handle attribute, A-38, A-41
OCI_ATTR_PIN_DURATION
environment handle attribute, A-8
OCI_ATTR_PINOPTION
environment handle attribute, A-8
OCI_ATTR_POSITION
attribute, 6-17
OCI_ATTR_PRECISION, A-76
attribute, 6-5, 6-11, 6-13, 6-16, 6-17
OCI_ATTR_PREFETCH_MEMORY statement handle attribute, A-30
OCI_ATTR_PREFETCH_ROWS
statement handle attribute, A-31
OCI_ATTR_PRIORITY, A-52
OCI_ATTR_PROC_MODE, A-79
OCI_ATTR_PROXY_CREDENTIALS, 8-15, A-21
OCI_ATTR_PTYPE
attribute, 6-6
OCI_ATTR_RADIX
attribute, 6-18
OCI_ATTR_RECIPIENT_LIST, A-53
OCI_ATTR_REF_TDO
attribute, 6-7, 6-9, 6-11, 6-14, 6-16, 6-18
OCI_ATTR_RELATIVE_MSGID, A-44
OCI_ATTR_ROW_COUNT, 4-19, A-31, A-70, A-71
OCI_ATTR_ROWID
statement handle attribute, A-31
OCI_ATTR_ROWS_FETCHED, 4-19, A-32
OCI_ATTR_ROWS_RETURNED
bind handle attribute, A-38
use with callbacks, 5-30
OCI_ATTR_SAVEPOINT_SUPPORT
attribute, 6-20
OCI_ATTR_SCALE, A-76
attribute, 6-11, 6-13, 6-16, 6-17
OCI_ATTR_SCHEMA_NAME, A-66
attribute, 6-10, 6-11, 6-13, 6-14, 6-16, 6-18
OCI_ATTR_SENDER_ID, A-53
OCI_ATTR_SEQ
attributes, 6-14
OCI_ATTR_SEQUENCE_DEVIATION, A-44
OCI_ATTR_SERVER
service context handle attribute, A-12
OCI_ATTR_SERVER_DN, A-55
OCI_ATTR_SERVER_DNS, A-56
OCI_ATTR_SERVER_GROUP
server handle attribute, A-15
OCI_ATTR_SERVER_STATUS, 2-26
server handle attribute, A-15
OCI_ATTR_SESSION
service context handle attribute, A-12
OCI_ATTR_SHARED_HEAP_ALLOC
environment handle attribute, A-10
OCI_ATTR_SPOOL_BUSY_COUNT, A-24
OCI_ATTR_SPOOL_GETMODE, A-25
OCI_ATTR_SPOOL_INCR, A-25
OCI_ATTR_SPOOL_MAX, A-26
OCI_ATTR_SPOOL_MIN, A-26
OCI_ATTR_SPOOL_OPEN_COUNT, A-26
OCI_ATTR_SPOOL_STMTCACHESIZE, A-27
OCI_ATTR_SPOOL_TIMEOUT, A-26
OCI_ATTR_SQLFNCODE
statement handle attribute, A-32
OCI_ATTR_STATEMENT statement handle attribute, A-34
OCI_ATTR_STMT_STATE, A-35
OCI_ATTR_STMT_TYPE
statement handle attribute, A-35
OCI_ATTR_STMTCACHESIZE, 9-30, 15-37, A-12
OCI_ATTR_STREAM_OFFSET, A-71
OCI_ATTR_SUB_NAME, A-67
attribute, 6-18
OCI_ATTR_SUBSCR_CALLBACK, A-56
OCI_ATTR_SUBSCR_CTX, A-57
OCI_ATTR_SUBSCR_NAME, A-57
OCI_ATTR_SUBSCR_NAMESPACE, A-58
OCI_ATTR_SUBSCR_PAYLOAD, A-58
OCI_ATTR_SUBSCR_RECPT, A-58
OCI_ATTR_SUBSCR_RECPTPRES, A-59
OCI_ATTR_SUBSCR_RECPTPROTO, A-59
OCI_ATTR_SUBSCR_SERVER_DN descriptor handle, 9-60
OCI_ATTR_SUPERTYPE_NAME
attribute, 6-10
OCI_ATTR_SUPERTYPE_SCHEMA_NAME
attribute, 6-10
OCI_ATTR_TABLE_NAME
attribute, 6-22
OCI_ATTR_TABLESPACE
attribute, 6-7
OCI_ATTR_TIMESTAMP
attribute, 6-6
OCI_ATTR_TRANS
service context handle attribute, A-13
OCI_ATTR_TRANS_NAME, 8-4
transaction handle attribute, A-27
OCI_ATTR_TRANS_TIMEOUT
transaction handle attribute, A-27
OCI_ATTR_TRANSACTION_NO, A-53
OCI_ATTR_TYPE_NAME
attribute, 6-11, 6-13, 6-16, 6-18
OCI_ATTR_TYPECODE
attribute, 6-9, 6-10, 6-13, 6-17
OCI_ATTR_USERNAME
user session handle attribute, A-22
OCI_ATTR_VALUE
attribute, 6-23
OCI_ATTR_VERSION
attribute, 6-20
OCI_ATTR_VISIBILITY, A-45, A-48
OCI_ATTR_WAIT, A-49
OCI_ATTR_WALL_LOC, A-10
OCI_ATTR_XID, 8-4
transaction handle attribute, A-28
OCI_BIND_SOFT, 15-74, 15-79
OCI_CONTINUE, 2-27
OCI_CPOOL_REINITIALIZE, 15-6
OCI_CRED_EXT, 15-31
OCI_CRED_PROXY, 8-14
OCI_CRED_RDBMS, 8-14, 15-31
OCI_DATA_AT_EXEC, 15-74, 15-79
OCI_DEFAULT, 9-3, 15-6
OCI_DEFINE_SOFT, 15-94
OCI_DIRPATH_DATASAVE_FINISH, 16-160
OCI_DIRPATH_DATASAVE_SAVEONLY, 16-160
OCI_DIRPATH_EXPR_OBJ_CONSTR, 12-36, 12-37
OCI_DIRPATH_EXPR_REF_TBLNAME, 12-27, 12-38
OCI_DIRPATH_EXPR_SQL, 12-37, 12-38
OCI_DIRPATH_OID column array attribute, 12-43
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_DATE, 2-13
OCI_DTYPE_FILE, 2-13
OCI_DTYPE_INTERVAL_DS, 2-14
OCI_DTYPE_INTERVAL_YM, 2-13
OCI_DTYPE_LOB, 2-13
OCI_DTYPE_PARAM, 2-13, 15-49, 15-64
when used, 15-50
OCI_DTYPE_ROWID, 2-13
OCI_DTYPE_SNAP, 2-13
OCI_DTYPE_SRVDN, 2-14
OCI_DTYPE_TIMESTAMP, 2-13
OCI_DTYPE_TIMESTAMP_LTZ, 2-13
OCI_DTYPE_TIMESTAMP_TZ, 2-13
OCI_DURATION_SESSION, 13-8, 16-26, 19-12, 20-7, 20-21, 20-27, 20-38
OCI_DURATION_STATEMENT, 16-26, 19-12, 20-7, 20-21, 20-27, 20-38
OCI_DURATION_TRANS, 13-8
OCI_DYNAMIC_FETCH, 15-94
OCI_ERROR, 2-26, 8-7
OCI_EVENTS
mode for receiving notifications, 9-57
OCI_EXT_CRED, 8-14
OCI_HTYPE_AUTHINFO, 2-5, 9-20
OCI_HTYPE_BIND, 2-5
OCI_HTYPE_COMPLEXOBJECT, 2-5
OCI_HTYPE_COR, 15-64
OCI_HTYPE_CPOOL, 2-5, 9-13
OCI_HTYPE_DEFINE, 2-5
OCI_HTYPE_DESCRIBE, 2-5
OCI_HTYPE_DIRPATH_COLUMN_ARRAY, 2-5
OCI_HTYPE_DIRPATH_CTX, 2-5
OCI_HTYPE_DIRPATH_FN_CTX, 2-5
OCI_HTYPE_DIRPATH_STREAM, 2-5
OCI_HTYPE_ENV, 2-5
OCI_HTYPE_ERROR, 2-5
OCI_HTYPE_PROC, 2-5
OCI_HTYPE_SERVER, 2-5
OCI_HTYPE_SESSION, 2-5
OCI_HTYPE_SPOOL, 2-5
OCI_HTYPE_STMT, 2-5, 15-49, 15-64
OCI_HTYPE_SUBSCRIPTION, 2-5
OCI_HTYPE_SVCCTX, 2-5
OCI_HTYPE_TRANS, 2-5
OCI_INVALID_HANDLE, 2-26
OCI_LOCK_NONE, 13-13
OCI_LOCK_X, 13-13
OCI_LOCK_X_NOWAIT, 13-13, 13-14
parameter usage, 13-14
OCI_LTYPE_ARG_FUNC list attribute, 6-19
OCI_LTYPE_ARG_PROC list attribute, 6-19
OCI_LTYPE_DB_SCH list attribute, 6-19
OCI_LTYPE_SCH_OBJ list attribute, 6-19
OCI_LTYPE_SUBPRG list attribute, 6-19
OCI_LTYPE_TYPE_ARG_FUNC list attribute, 6-19
OCI_LTYPE_TYPE_ARG_PROC list attribute, 6-19
OCI_LTYPE_TYPE_ATTR list attribute, 6-19
OCI_LTYPE_TYPE_METHOD list attribute, 6-19
OCI_MIGRATE, 8-10
OCI_NEED_DATA, 2-27
OCI_NEW_LENGTH_SEMANTICS, 15-10
OCI_NLS_MAXBUFSZ, 21-7
OCI_NO_DATA, 2-26
OCI_NO_MUTEX, 9-3
OCI_PIN_ANY, 13-7
OCI_PIN_LATEST, 13-7
OCI_PIN_RECENT, 13-7
OCI_PTYPE_ARG
attributes, 6-17
OCI_PTYPE_COL
attributes, 6-15
OCI_PTYPE_COLL
attributes, 6-12
OCI_PTYPE_DATABASE
attributes, 6-20
OCI_PTYPE_EVALUATION CONTEXT
attributes, 6-22
OCI_PTYPE_FUNC
attributes, 6-8
OCI_PTYPE_LIST
attributes, 6-19
OCI_PTYPE_NAME_VALUE
attributes, 6-23
OCI_PTYPE_PKG
attributes, 6-8
OCI_PTYPE_PROC
attributes, 6-8
OCI_PTYPE_RULE_SET
attributes, 6-21
OCI_PTYPE_RULES
attributes, 6-21
OCI_PTYPE_SCHEMA
attributes, 6-19
OCI_PTYPE_SYN
attributes, 6-14
OCI_PTYPE_TABLE
attributes, 6-7
OCI_PTYPE_TABLE_ALIAS
attributes, 6-22
OCI_PTYPE_TYPE
attributes, 6-8
OCI_PTYPE_TYPE_ATTR
attributes, 6-10
OCI_PTYPE_TYPE_FUNC
attributes, 6-11
OCI_PTYPE_TYPE_PROC
attributes, 6-11
OCI_PTYPE_VARIABLE_TYPE
attributes, 6-23
OCI_PTYPE_VIEW
attributes, 6-7
OCI_SESSRLS_RETAG, 15-45, 15-46
OCI_STILL_EXECUTING, 2-27, 2-35
OCI_STMT_SCROLLABLE_READONLY
attribute, 4-19
OCI_SUBSCR_PROTO_HTTP, A-60
OCI_SUBSCR_PROTO_MAIL, A-60
OCI_SUBSCR_PROTO_OCI, A-59
OCI_SUBSCR_PROTO_SERVER, A-60
OCI_SUCCESS, 2-26, 8-7
OCI_SUCCESS_WITH_INFO, 2-26
OCI_THREADED, 9-3
OCI_TRANS_LOOSE, 8-5
OCI_TRANS_READONLY, 8-3, 8-10
OCI_TRANS_RESUME, 8-9
OCI_TRANS_SERIALIZABLE, 8-3
OCI_TRANS_TIGHT, 8-5
OCI_TRANS_TWOPHASE, 8-9
OCI_TYPECODE
values, 3-33, 3-35
OCI_TYPECODE_NCHAR, 11-31
OCI_UTF16ID, 2-39
OCIAnyDataAccess(), 20-12
OCIAnyDataAttrGet(), 20-14
OCIAnyDataAttrSet(), 20-17
OCIAnyDataBeginCreate(), 20-20
OCIAnyDataCollAddElem(), 20-22
OCIAnyDataCollGetElem(), 20-24
OCIAnyDataConvert(), 20-26
OCIAnyDataDestroy(), 20-29
OCIAnyDataEndCreate(), 20-30
OCIAnyDataGetCurrAttrNum(), 20-31
OCIAnyDataGetType(), 20-32
OCIAnyDataIsNull(), 20-33
OCIAnyDataSetAddInstance(), 20-36
OCIAnyDataSetBeginCreate(), 20-38
OCIAnyDataSetDestroy(), 20-40
OCIAnyDataSetEndCreate(), 20-41
OCIAnyDataSetGetCount(), 20-42
OCIAnyDataSetGetInstance(), 20-43
OCIAnyDataSetGetType(), 20-44
OCIAnyDataTypeCodeToSqlt(), 11-31, 20-34
OCIAQAgent
descriptor attributes, A-54
OCIAQDeq(), 16-115
OCIAQDeqArray(), 16-118
OCIAQDeqOptions
descriptor attributes, A-45
OCIAQEnq(), 16-121
OCIAQEnqArray(), 16-134
OCIAQEnqOptions
descriptor attributes, A-44
OCIAQListen(), 16-136
OCIAQMsgProperties
descriptor attributes, A-49
OCIArray, 11-17
binding and defining, 11-17, 11-38
OCIArray manipulation
code example, 11-19
OCIAttrGet(), 15-49
used for describing, 4-12
OCIAttrSet(), 15-52
OCIAuthInfo definition, 9-20
OCIAuthInfo handle attributes, A-16
OCIBindArrayOfStruct(), 15-69
OCIBindByName(), 15-71
OCIBindByPos(), 15-77
OCIBindDynamic(), 15-82
OCIBindObject(), 15-87
OCIBreak(), 16-216
use of, 2-32, 2-36
OCICacheFlush(), 17-9
OCICacheFree(), 17-53
OCICacheRefresh(), 17-11
OCICacheUnmark(), 17-18
OCICacheUnpin(), 17-54
OCICharSetConversionIsReplacementUsed(), 21-66
OCICharSetToUnicode(), 21-67
OCIColl, 11-17
binding and defining, 11-17
OCICollAppend(), 18-6
OCICollAssign(), 18-8
OCICollAssignElem(), 18-10
OCICollGetElem(), 18-12
OCICollGetElemArray(), 18-15
OCICollIsLocator(), 18-17
OCICollMax(), 18-18
OCICollSize(), 18-19
OCICollTrim(), 18-21
OCIComplexObject
use of, 10-24
OCIComplexObjectComp
use of, 10-24
OCIConnectionPoolCreate(), 15-5
OCIConnectionPoolDestroy(), 15-8
OCIContextClearValue(), 19-23
OCIContextGenerateKey(), 19-24
OCIContextGetValue(), 19-22
OCIContextSetValue(), 19-20
OCIDate, 11-6
binding and defining, 11-6, 11-38
OCIDate manipulation
code example, 11-6
OCIDateAddDays(), 18-36
OCIDateAddMonths(), 18-37
OCIDateAssign(), 18-38
OCIDateCheck(), 18-39
OCIDateCompare(), 18-41
OCIDateDaysBetween(), 18-42
OCIDateFromText(), 18-43
OCIDateGetDate(), 18-45
OCIDateGetTime(), 18-46
OCIDateLastDay(), 18-47
OCIDateNextDay(), 18-48
OCIDateSetDate(), 18-50
OCIDateSetTime(), 18-51
OCIDateSysDate(), 18-52
OCIDateTimeAssign(), 18-55
OCIDateTimeCheck(), 18-57
OCIDateTimeCompare(), 18-59
OCIDateTimeConstruct(), 18-61
OCIDateTimeConvert(), 18-63
OCIDateTimeFromArray(), 18-65
OCIDateTimeFromText(), 18-67
OCIDateTimeGetDate(), 18-69
OCIDateTimeGetTime, 18-71
OCIDateTimeGetTime(), 18-71
OCIDateTimeGetTimeZoneName(), 18-73
OCIDateTimeGetTimeZoneOffset(), 18-75
OCIDateTimeIntervalAdd(), 18-77
OCIDateTimeIntervalSub(), 18-79
OCIDateTimeSubtract(), 18-81
OCIDateTimeSysTimeStamp(), 18-82
OCIDateTimeToArray(), 18-83
OCIDateToText(), 18-53
OCIDateZoneToZone(), 18-87
OCIDefineArrayOfStruct(), 15-90
OCIDefineByPos(), 15-92
OCIDefineDynamic(), 15-97
OCIDefineObject(), 15-100
OCIDescribeAny(), 15-102
usage examples, 6-25
using, 6-2
OCIDescriptorAlloc(), 15-54
OCIDescriptorFree(), 15-57
OCIDirPathAbort(), 16-150
OCIDirPathColArray context, 12-5
OCIDirPathColArrayEntryGet(), 16-151
OCIDirPathColArrayEntrySet(), 16-153
OCIDirPathColArrayReset(), 16-157
OCIDirPathColArrayRowGet(), 16-155
OCIDirPathColArrayToStream(), 16-158
OCIDirPathCtx context, 12-5
OCIDirPathDataSave(), 16-160
OCIDirPathFinish(), 16-161
OCIDirPathFlushRow(), 16-162
OCIDirPathFuncCtx, 12-5
OCIDirPathPrepare(), 16-165
OCIDirPathStream context, 12-5
OCIDirPathStreamLoad(), 16-163
OCIDirPathStreamReset(), 16-167
OCIDuration
use of, 13-8, 13-15
OCIDurationBegin(), 16-26, 19-12
OCIDurationEnd(), 16-28, 19-14
OCIEnvCreate(), 15-9
OCIEnvInit(), 15-12
OCIEnvNlsCreate(), 2-39, 5-32, 15-14
OCIErrorGet(), 16-217
OCIExtProcAllocCallMemory(), 19-5
OCIExtProcGetEnv(), 19-9
OCIExtProcRaiseExcp(), 19-6
OCIExtProcRaiseExcpWithMsg(), 19-7
OCIExtractFromFile(), 19-32
OCIExtractFromList(), 19-40
OCIExtractFromStr(), 19-33
OCIExtractInit(), 19-26
OCIExtractReset(), 19-28
OCIExtractSetKey(), 19-30
OCIExtractSetNumKeys(), 19-29
OCIExtractTerm(), 19-27
OCIExtractToBool(), 19-35
OCIExtractToInt(), 19-34
OCIExtractToList(), 19-39
OCIExtractToOCINum(), 19-38
OCIFileClose(), 19-47
OCIFileExists(), 19-53
OCIFileInit(), 19-43
OCIFileRead(), 19-48
OCIFileSeek(), 19-51
OCIFileTerm(), 19-44
OCIFileWrite(), 19-50
OCIFormatInit(), 19-57
OCIFormatString(), 19-59
OCIFormatTerm(), 19-58
OCIHandleAlloc(), 15-59
OCIHandleFree(), 15-62
OCIInd
use of, 10-30
OCIInitialize(), 15-18
OCIIntervalAssign(), 18-91
OCIIntervalCheck(), 18-92
OCIIntervalCompare(), 18-94
OCIIntervalDivide(), 18-96
OCIIntervalFromNumber(), 18-97
OCIIntervalFromText(), 18-98
OCIIntervalFromTZ(), 18-100
OCIIntervalGetDaySecond(), 18-102
OCIIntervalGetYearMonth(), 18-104
OCIIntervalMultiply(), 18-105
OCIIntervalSetDaySecond(), 18-107
OCIIntervalSetYearMonth(), 18-109
OCIIntervalToText(), 18-114
OCIIter, 11-17
binding and defining, 11-17
usage example, 11-19
OCIIterCreate(), 18-22
OCIIterDelete(), 18-24
OCIIterGetCurrent(), 18-25
OCIIterInit(), 18-27
OCIIterNext(), 18-29
OCIIterPrev(), 18-31
OCILdaToSvcCtx(), 16-220
oci.lib, D-4
OCILobAppend(), 16-29
OCILobAssign(), 16-31
OCILobCharSet(), 16-33, 16-34
OCILobClose(), 16-35
OCILobCopy(), 16-37
OCILobCopy2(), 16-40
OCILobCreateTemporary(), 16-41
OCILobDisableBuffering(), 16-43
OCILobEnableBuffering(), 16-44
OCILobErase(), 16-45
OCILobErase2(), 16-47
OCILobFileClose(), 16-48
OCILobFileCloseAll(), 16-49
OCILobFileExists(), 16-50
OCILobFileGetName(), 16-51
OCILobFileIsOpen(), 16-53
OCILobFileOpen(), 16-55
OCILobFileSetName(), 16-57
OCILobFlushBuffer(), 16-59
OCILobFreeTemporary(), 16-61
OCILobGetChunkSize(), 16-62
OCILobGetLength(), 16-64
OCILobGetLength2(), 16-66
OCILobGetStorageLimit(), 16-67
OCILobIsEqual(), 16-68
OCILobIsOpen(), 16-69
OCILobIsTemporary(), 16-71
OCILobLoadFromFile(), 16-72
OCILobLoadFromFile2(), 16-74
OCILobLocatorAssign(), 16-75
OCILobLocatorIsInit(), 16-77
OCILobOpen(), 16-79
OCILobRead(), 16-81
OCILobRead2(), 16-87
OCILobTrim(), 16-92
OCILobTrim2(), 16-94
OCILobWrite(), 16-95
OCILobWrite2(), 16-101
OCILobWriteAppend(), 16-106
OCILobWriteAppend2(), 16-110
OCILockOpt
possible values, 17-30, 17-60
OCILogoff(), 15-21
OCILogon(), 15-22
using, 2-21
OCILogon2(), 15-24
OCIMemoryAlloc(), 19-15
OCIMemoryFree(), 19-18
OCIMemoryResize(), 19-17
OCIMessageClose(), 21-74
OCIMessageGet(), 21-75
OCIMessageOpen(), 21-76
OCIMultiByteInSizeToWideChar(), 21-19
OCIMultiByteStrCaseConversion(), 21-21
OCIMultiByteStrCat(), 21-22
OCIMultiByteStrcmp(), 21-23
OCIMultiByteStrcpy(), 21-25
OCIMultiByteStrlen(), 21-26
OCIMultiByteStrncat(), 21-27
OCIMultiByteStrncmp(), 21-28
OCIMultiByteStrncpy(), 21-30
OCIMultiByteStrnDisplayLength(), 21-31
OCIMultiByteToWideChar(), 21-32
OCIMultiTransPrepare(), 16-204
OCINlsCharSetConvert(), 21-69
OCINlsCharSetIdToName(), 21-5
OCINlsCharSetNameTold(), 21-6
OCINlsEnvironmentVariableGet(), 2-39, 5-32, 21-7
OCINlsGetInfo(), 2-40, 21-9
OCINlsNameMap(), 21-14
OCINlsNumericInfoGet(), 21-12
OCINumber, 11-13
bind example, 11-39
binding and defining, 11-13, 11-38
define example, 11-39
OCINumber manipulation
code example, 11-13
OCINumberAbs(), 18-118
OCINumberAdd(), 18-119
OCINumberArcCos(), 18-120
OCINumberArcSin(), 18-121
OCINumberArcTan(), 18-122
OCINumberArcTan2(), 18-123
OCINumberAssign(), 18-124
OCINumberCeil(), 18-125
OCINumberCompare(), 18-126
OCINumberCos(), 18-127
OCINumberDec(), 18-128
OCINumberDiv(), 18-129
OCINumberExp(), 18-130
OCINumberFloor(), 18-131
OCINumberFromInt(), 18-132
OCINumberFromReal(), 18-134
OCINumberFromText(), 18-135
OCINumberHypCos(), 18-137
OCINumberHypSin(), 18-138
OCINumberHypTan(), 18-139
OCINumberInc(), 18-140
OCINumberIntPower(), 18-141
OCINumberIsInt(), 18-142
OCINumberIsZero(), 18-143
OCINumberLn(), 18-144
OCINumberLog(), 18-145
OCINumberMod(), 18-146
OCINumberMul(), 18-147
OCINumberNeg(), 18-148
OCINumberPower(), 18-149
OCINumberPrec(), 18-150
OCINumberRound(), 18-151
OCINumberSetPi(), 18-152
OCINumberSetZero(), 18-153
OCINumberShift(), 18-154
OCINumberSign(), 18-155
OCINumberSin(), 18-156
OCINumberSqrt(), 18-157
OCINumberSub(), 18-158
OCINumberTan(), 18-159
OCINumberToInt(), 18-160
OCINumberToReal(), 18-162
OCINumberToRealArray(), 18-163
OCINumberToText(), 18-165
OCINumberTrunc(), 18-167
OCIObjectArrayPin(), 17-55
OCIObjectCopy(), 17-35
OCIObjectExists(), 17-27
OCIObjectFlush(), 17-13
OCIObjectFree(), 17-57
OCIObjectGetAttr(), 17-38
OCIObjectGetInd(), 17-40
example of use, 10-32
OCIObjectGetObjectRef(), 17-41
OCIObjectGetTypeRef(), 17-42
OCIObjectIsDirty(), 17-32
OCIObjectIsLocked(), 17-33
OCIObjectLifetime
possible values, 17-29
OCIObjectLock(), 17-43
OCIObjectLockNoWait(), 17-44
OCIObjectMarkDelete(), 17-19
OCIObjectMarkDeleteByRef(), 17-21
OCIObjectMarkStatus
possible values, 17-30
OCIObjectMarkUpdate(), 17-22
OCIObjectNew(), 17-46
OCIObjectPin(), 17-59
OCIObjectPinCountReset(), 17-62
OCIObjectPinTable(), 17-64
OCIObjectRefresh(), 17-15
OCIObjectSetAttr(), 17-50
OCIObjectUnmark(), 17-24
OCIObjectUnmarkByRef(), 17-25
OCIObjectUnpin(), 17-66
OCIParamGet(), 15-64
used for describing, 4-12
OCIParamSet(), 15-66
OCIPasswordChange(), 16-222
OCIPinOpt
use of, 13-7
OCIRaw, 11-16
binding and defining, 11-16, 11-38
OCIRaw manipulation
code example, 11-17
OCIRawAllocSize(), 18-169
OCIRawAssignBytes(), 18-170
OCIRawAssignRaw(), 18-171
OCIRawPtr(), 18-172
OCIRawResize(), 18-173
OCIRawSize(), 18-175
OCIRef, 11-24
binding and defining, 11-24
usage example, 11-24
OCIRefAssign(), 18-177
OCIRefClear(), 18-178
OCIRefFromHex(), 18-179
OCIRefHexSize(), 18-181
OCIRefIsEqual(), 18-182
OCIRefIsNull(), 18-183
OCIRefToHex(), 18-184
OCIReset(), 16-225
use of, 2-36
OCIRowid ROWID descriptor, 2-16
OCIRowidToChar(), 16-226
OCIServerAttach(), 15-27
shadow processes, 15-28
OCIServerDetach(), 15-30
OCIServerDNs descriptor attributes, A-55
OCIServerVersion(), 16-227
OCISessionBegin(), 2-22, 2-41, 15-31
OCISessionEnd(), 15-35
OCISessionGet(), 15-36
OCISessionPoolCreate(), 15-40
OCISessionPoolDestroy(), 15-44
OCISessionRelease(), 15-45
OCIStmtExecute(), 16-5
prefetch during, 4-7
use of iters parameter, 4-7
OCIStmtFetch(), 16-9
OCIStmtFetch2(), 4-19, 16-11
OCIStmtGetBindInfo(), 15-105
OCIStmtGetPieceInfo(), 16-14
OCIStmtPrepare(), 16-16
preparing SQL statements, 4-4
OCIStmtPrepare2(), 16-18
OCIStmtRelease(), 16-20
OCIStmtSetPieceInfo(), 16-21
OCIString, 11-15
binding and defining, 11-15, 11-38
OCIString manipulation
code example, 11-16
OCIStringAllocSize(), 18-187
OCIStringAssign(), 18-188
OCIStringAssignText(), 18-189
OCIStringGetEncoding(), 18-191
OCIStringPtr(), 18-191
OCIStringResize(), 18-192
OCIStringSize(), 18-194
OCISubscriptionDisable(), 16-138
OCISubscriptionEnable(), 16-140
OCISubscriptionPost(), 16-142
OCISubscriptionRegister(), 16-144
OCISubscriptionUnRegister(), 16-147
OCISvcCtxToLda(), 16-229
OCITable, 11-17
binding and defining, 11-17, 11-38
OCITableDelete(), 18-196
OCITableExists(), 18-198
OCITableFirst(), 18-199
OCITableLast(), 18-201
OCITableNext(), 18-202
OCITablePrev(), 18-204
OCITableSize(), 18-206
OCITerminate(), 15-47
OCIThread package, 9-4
OCIThreadClose(), 16-170
OCIThreadCreate(), 16-171
OCIThreadHandleGet(), 16-173
OCIThreadHndDestroy(), 16-174
OCIThreadHndInit(), 16-175
OCIThreadIdDestroy(), 16-176
OCIThreadIdGet(), 16-177
OCIThreadIdInit(), 16-178
OCIThreadIdNull(), 16-179
OCIThreadIdSame(), 16-180
OCIThreadIdSet(), 16-181
OCIThreadIdSetNull(), 16-182
OCIThreadInit(), 16-183
OCIThreadIsMulti(), 16-184
OCIThreadJoin(), 16-185
OCIThreadKeyDestroy(), 16-186
OCIThreadKeyGet(), 16-187
OCIThreadKeyInit(), 16-188
OCIThreadKeySet(), 16-190
OCIThreadMutexAcquire(), 16-191
OCIThreadMutexDestroy(), 16-192
OCIThreadMutexInit(), 16-193
OCIThreadMutexRelease(), 16-194
OCIThreadProcessInit(), 16-195
OCIThreadTerm(), 16-196
OCITransCommit(), 16-198
OCITransDetach(), 16-201
OCITransForget(), 16-203
OCITransMultiPrepare(), 8-8
OCITransPrepare(), 16-205
OCITransRollback(), 16-206
OCITransStart(), 16-207
OCIType
description, 11-25
OCITypeAddAttr(), 20-5
OCITypeArrayByName(), 17-69
OCITypeArrayByRef(), 17-72
OCITypeBeginCreate(), 20-6
OCITypeByName(), 17-74
OCITypeByRef(), 17-77
OCITypeElem
description, 11-25
OCITypeEndCreate(), 20-8
OCITypeMethod
description, 11-25
OCITypeSetBuiltin(), 20-9
OCITypeSetCollection(), 20-10
OCIUnicodeToCharSet(), 21-71
OCIUserCallbackGet(), 16-231
OCIUserCallbackRegister(), 16-234
OCIWideCharInSizeToMultiByte(), 21-33
OCIWideCharIsAlnum(), 21-53
OCIWideCharIsAlpha(), 21-54
OCIWideCharIsCntrl(), 21-55
OCIWideCharIsDigit(), 21-56
OCIWideCharIsGraph(), 21-57
OCIWideCharIsLower(), 21-58
OCIWideCharIsPrint(), 21-59
OCIWideCharIsPunct(), 21-60
OCIWideCharIsSingleByte(), 21-61
OCIWideCharIsSpace(), 21-62
OCIWideCharIsUpper(), 21-63
OCIWideCharIsXdigit(), 21-64
OCIWideCharMultiByteLength(), 21-35
OCIWideCharStrCaseConversion(), 21-36
OCIWideCharStrcat(), 21-38
OCIWideCharStrchr(), 21-39
OCIWideCharStrcmp(), 21-40
OCIWideCharStrcpy(), 21-42
OCIWideCharStrlen(), 21-43
OCIWideCharStrncat(), 21-44
OCIWideCharStrncmp(), 21-45
OCIWideCharStrncpy(), 21-47
OCIWideCharStrrchr(), 21-48
OCIWideCharToLower(), 21-49
OCIWideCharToMultiByte(), 21-50
OCIWideCharToUpper(), 21-51
OCIXmlDbFreeXmlCtx(), 13-24, 22-5
ocixmldb.h header file, 13-24
OCIXmlDbInitXmlCtx(), 13-24, 22-6
OID. See object identifier
opaque, definition of, 1-2
optimistic locking
implementing, 13-14
Oracle Call Interface. See OCI
Oracle Call Interface. See OCI
Oracle datatypes, 3-2
mapping to C, 11-2
Oracle XA Library
additional documentation, D-7
compiling and linking an OCI program, D-5
dynamic registration, D-6
functions, D-5
overview, D-5
Oracle9i database
transaction processing monitor, D-5
orasb8 datatype, 7-5
oratypes.h
contents, 3-37
only supported means of supplying parameters to the OCI, 3-37
oraub8 datatype, 7-5
ORE. See object runtime environment
OTT
command line, 14-6
command line syntax, 14-27
creating types in the database, 14-5
datatypes mapping, 14-10
intype file, 14-34
outtype file, 14-21
overview, 14-2
parameters, 14-28
providing an intype file, 14-9
reference, 14-26
restriction, 14-42
using, 14-1
OTT (Object Type Translator), D-7
OTT initialization function
calling, 14-24
tasks of, 14-26
OTT parameter TRANSITIVE, 14-33
OTT parameter URL, 14-33
OTT parameters
CASE, 14-32
CODE, 14-30
CONFIG, 14-31
ERRTYPE, 14-31
HFILE, 14-31
INITFILE, 14-30
INITFUNC, 14-31
INTYPE, 14-29
OUTTYPE, 14-29
SCHEMA_NAMES, 14-33
USERID, 14-29
where they appear, 14-33
OTT. See object type translator
ottcfg.cfg, D-2
outtype file, 14-34
when running OTT, 14-21
OUTTYPE OTT parameter, 14-29

P

packages
attributes, 6-8
describing, 6-2
parameter descriptor, 2-16
attributes, 6-5, A-42
parameter descriptor object, 11-25
parameters
attributes, 6-5
buffer lengths, 15-3, 16-3
modes, 15-2, 16-2
passing strings, 2-29
string length, 15-3, 16-3
partitioned fine grained access control, 8-16
password management, 8-10, 8-12
PDO. See parameter descriptor object
persistent objects, 10-5
meta-attributes, 10-17
piecewise binds and defines for LOBs, 5-47
piecewise fetch, 5-45
piecewise operations, 5-42
fetch, 5-40, 5-46
in PL/SQL, 5-45
insert, 5-40
update, 5-40
valid datatypes, 5-41
pin count, 10-29
pin duration
example, 13-16
of objects, 13-15
pinning, 13-7
pinning objects, 13-7
PL/SQL, 1-9
binding and defining nested tables, 5-39
binding and defining REF cursors, 5-39
binding placeholders, 2-37
defining output variables, 5-22
piecewise operations, 5-45
uses in OCI applications, 2-37
using in OCI applications, 2-37
using in OCI programs, 5-7
positioned, 2-33
deletes, 2-33
prefetching
during OCIStmtExecute(), 4-7
setting prefetch memory size, 4-17
setting row count, 4-17
prepare multiple branches in a single message, 8-8
procedures
attributes, 6-8
process
handle attributes, A-77
proxy authentication, 8-17
publish-subscribe
_SYSTEM_TRIG_ENABLED parameter, 9-63
COMPATIBLE parameter, 9-56
example, 9-63
functions, 9-56
handle attributes, 9-57, A-56
LDAP registration, 9-59
notification callback, 9-61
notification feature, 9-54
subscription handle, 9-57
publish-subscribe functions, 16-114

Q

query
explicit describe, 4-15
query. See SQL query

R

RAW
external datatype, 3-16
REF
external datatype, 3-20
REF columns
direct path loading of, 12-25
REF cursors variables
binding and defining, 5-39
reference. See REFs
refreshing, 13-12
objects, 13-12
REFs
binding, 11-33
cursor variables, binding, 5-17
defining, 11-35
indicator variables for, 2-29, 2-31
retrieving from server, 10-10
registering
user callbacks, 9-31
registry
REGEDT32, D-6
relational functions, C-8
server round trips, C-2
required support files, D-2
reserved namespaces, 2-34
reserved words, 2-33
result set, 4-18
resuming branches, 8-6
return values
navigational functions, 17-5
RETURNING clause
binding with, 5-27
error handling, 5-28
initializing variables, 5-27
using with OCI
with REFs, 5-28
rollback, 2-24
in object applications, 13-15
round trips
See server round trips
ROWID
external datatype, 3-21
logical, 3-6
Universal ROWID, 3-6
used for positioned updates and deletes, 2-33
ROWID descriptor, 2-16
RSFs, D-2
running OCI applications, D-5

S

sample programs, B-1, D-3
samples directory, D-2
sb1
definition, 3-37
sb2
definition, 3-37
sb4
definition, 3-37
SCHEMA_NAMES OTT parameter, 14-33
usage, 14-38
SCHEMA.QUEUE, 16-146
SCHEMA.QUEUE:CONSUMER_NAME, 16-146
schemas
attributes, 6-19, 6-21, 6-22, 6-23
describing, 6-2
scrollable cursor
example, 4-20
scrollable cursors, 4-18
secondary memory
of object, 13-17
select-list
describing, 4-11
sequences
attributes, 6-14
describing, 6-2
server handle
attributes, A-13
description, 2-9
setting in service context, 2-9
server round trips
cache functions, C-5
datatype mapping and manipulation functions, C-7
describe operation, C-6
LOB functions, C-3
object functions, C-5
relational functions, C-8
servers compatibility, 1-16
service context handle
attributes, A-11
description, 2-8
elements of, 2-8
session
migration, 8-10, 15-32
session management, 8-10, 8-12
session pool handle
attributes, A-24
session pooling, 9-17, 9-23
tagging, 9-18
session pooling example, 9-23
session pooling, functionality, 9-18
signal handler, 9-2
skip parameters
for arrays of structures, 5-23
for standard arrays, 5-24
snapshot descriptor, 2-15
snapshots
executing against, 4-8
SQL query
binding placeholders. See bind operation
defining output variables, 4-16, 5-17, 11-35
defining output variables. See define operation
fetching results, 4-16
statement type, 1-8
SQL statements, 1-6
binding placeholders in, 4-5, 5-2, 11-32
determining type prepared, 4-4
executing, 4-7
preparing for execution, 4-4
processing, 4-2
types
control statements, 1-7
data definition language, 1-7
data manipulation language, 1-7
embedded SQL, 1-10
PL/SQL, 1-9
queries, 1-8
SQLCS_IMPLICIT, 5-31, 16-33, 16-41, 16-84, 16-89, 16-98, 16-104, 16-108, 16-112
SQLCS_NCHAR, 5-31, 16-33, 16-41, 16-84, 16-89, 16-98, 16-104, 16-108, 16-112
SQLT typecodes, 3-35
SQLT_BDOUBLE, 3-26
SQLT_BFLOAT, 3-26
SQLT_IBDOUBLE, 3-7, 6-15
SQLT_IBFLOAT, 3-7, 6-15
SQLT_NTY
bind example, 11-44
define example, 11-46
description, 3-20
preallocating object memory, 11-37
SQLT_REF
definition, 3-20
description, 3-20
stateful sessions, 9-11
stateless sessions, 9-11
statement caching, 9-27
code example, 9-30
statement handle
attributes, A-28
description, 2-10
stored functions
describing, 6-2
stored procedures
describing, 6-2
Streams Advanced Queuing
dequeue function, 16-115
description, 9-48
enqueue function, 16-121
examples, 16-122
functions, 16-114
OCI and, 9-48
OCI descriptors for, 9-49
OCI functions for, 9-48
OCI versus PL/SQL, 9-50
STRING
external datatype, 3-13
strings
passing as parameters, 2-29
structures
arrays of, 5-23
subscription handle, 2-11
attributes, A-56
Supporting UTF-16 Unicode in the OCI, 2-39, 2-40, 2-41, 2-43, 2-44, 2-45
supporting UTF-16 Unicode in the OCI, 2-41
sword
definition, 3-37
synonyms
attributes, 6-14
describing, 6-2

T

tables
attributes, 6-7
describing, 6-2
limitations on OCIDescribe() and OCIStmtExecute(), 6-4
tagging
session pooling, 9-18, 15-39, 15-45
TDO
definition, 11-33
description, 11-25
in the object cache, 13-23
obtaining, 11-25
type descriptor object. See TDO.
TDO. See type descriptor object
terminology
navigational functions, 17-3
used in this manual, 1-10
thread management functions, 16-168
thread safety, 9-2
advantages of, 9-2
and three-tier architectures, 9-3
basic concepts, 9-2
implementing with OCI, 9-3
mixing 7.x and 8.0 calls, 9-4
required OCI calls, 9-3
threads package, 9-4
three-tier architectures
and thread safety, 9-3
TIMESTAMP datatype, 3-24
TIMESTAMP WITH LOCAL TIME ZONEdatatype, 3-25
TIMESTAMP WITH TIME ZONEdatatype, 3-25
top-level memory
of object, 13-17
transaction handle
attributes, A-27
description, 2-9
transaction identifier, 8-3
transaction processing monitor
additional documentation, D-7
interacting with Oracle9i database, D-5
types, D-5
transactional complexity
levels in OCI, 8-2
transactions
committing, 2-24
functions, 16-197
global, 8-3
branch states, 8-6
branches, 8-4
one-phase commit, 8-7
transactions identifier, 8-3
two-phase commit, 8-7
global examples, 8-8
initialization parameters, 8-8
local, 8-3
OCI functions for
transactions, 8-2
read-only, 8-3
rolling back, 2-24
serializable, 8-3
transient objects, 10-6
LOBs
attributes, 7-4
meta-attributes, 10-20
TRANSITIVE OTT parameter, 14-10, 14-16, 14-33
type attributes
attributes, 6-10
type descriptor object, 10-8, 11-25
type evolution, 10-41
object cache, 13-23
type functions
attributes, 6-11
type inheritance
OTT support, 14-17
type procedures
attributes, 6-11
type reference, 10-35
typecodes, 3-33
types
attributes, 6-8
describing, 6-2

U

ub1
definition, 3-37
ub2
definition, 3-37
ub4
definition, 3-37
Unicode
character set ID, A-40
character set Id, A-36
OCILobRead(), 16-85
OCILobWrite(), 16-99, 16-105
Universal ROWID, 3-6
unmarking, 13-10
objects, 13-10
unpinning, 10-29, 13-9
objects, 13-9
UNSIGNED
external datatype, 3-17
updates, 2-33
piecewise, 5-40, 5-42
positioned, 2-33
upgrading
7.x to 8.0, 1-20
7.x to 8.0 OCI, 1-21
upgrading OCI, 1-16
URL OTT parameter, 14-33
UROWID
Universal ROWID, 3-6
user memory
allocating, 2-18
user session handle
attributes, A-16
description, 2-9
setting in service context, 2-9
user-defined callback functions, 9-30
registering, 9-31
USERID OTT parameter, 14-29
utext
Unicode datatype, 5-38
UTF-16 data, sample code, 5-37

V

values, 10-5
in object applications, 10-7
VARCHAR
external datatype, 3-15
VARCHAR2
external datatype, 3-10
VARNUM
external datatype, 3-14
VARRAW
external datatype, 3-17
views
attributes, 6-7
describing, 6-2

W

with_context
argument to external procedure functions, 19-3

X

X.509 vertificate, 8-16
XA. See Oracle XA Library
XA specification, 8-4
XID. See transaction identifier
XML DB functions, 13-24
XML support in OCI, 13-23
xtramem_sz parameter
using, 2-18
Go to previous page
Previous
 Oracle
Copyright © 1996, 2003 Oracle Corporation
All Rights Reserved.
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Master Index
Master Index		 Go to Feedback page
Feedback