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

ADT. See object type

advantages

OCI, 1.1.1

allocation duration

example, 13.1.9.1

of objects, 13.1.9

AnyData, 11.13

AnyDataSet, 11.13

AnyType, 11.13

application context, 8.6

application initialization, 2.8.3

AQ. See Streams Advanced Queuing.

argument attributes, 6.2.11

arrays

binds, 11.14.3.1

defines, 11.15.3.1

DML, maximum rows, 5.1.2

skip parameter for, 5.5.1.1

arrays of structures, 5.5

indicator variables, 5.5.3

OCI calls used, 5.5.2

skip parameters, 5.5.1

atomic NULLs, 10.3.14

attribute descriptor object, 11.12.1

attributes

of handles, 2.5.12

of objects, 10.3.9

of parameter descriptors, 6.2

of parameters, 6.2

authentication

by Distinguished Name, 8.4.1.3

by X.509 Certificate, 8.4.1.4

management, 8.3.1

authentication information handle attributes, A.5.2

authorize functions, 15.1.10

B

batch error mode, 4.4.2.1, 4.4.2.1

batch jobs, authenticating users in, 8.3.3

BFILE

datatype, 3.3.21.1, 3.3.21.1

maximum size, 7.6

bin directory, D.2

BINARY_DOUBLE, 3.2.4

BINARY_FLOAT, 3.2.4

bind functions, 15.1.10

bind handle

attributes, A.11

description, 2.5.5

bind operation, 4.3, 5.1, 11.14

associations made, 5.1

example, 5.1.4

initializing variables, 5.1

LOBs, 5.2.1

named datatypes, 11.14.1

named versus positional, 5.1.1

OCI array interface, 5.1.2

OCI_DATA_AT_EXEC mode, 5.2.2

PL/SQL, 5.1.3

positional versus named, 5.1.1

REF CURSOR variables, 5.2.3

REFs, 11.14.2

steps used, 5.1.4

binding

arrays, 11.14.3.1

buffer expansion, 5.7.5

OCINumber, 11.16.1

PL/SQL placeholders, 2.13

summary, 5.2

BLOB

datatype, 3.3.21.2

BLOBs (binary large objects)

datatype, 3.3.21.2

blocking modes, 2.12.7

branches

detaching, 8.2.2.5

resuming, 8.2.2.5

buffer expansion during binding, 5.7.5

buffered messaging, 9.10.4

buffering LOB operations, 7.7.2

building OCI applications on Unix, B

C

C datatypes

manipulating with OCI, 11.3

cache functions

server round trips, C.4

callbacks

dynamic registrations, 9.7.1.6

for LOB operations, 7.7.4

for reading LOBs, 7.7.4.2

for writing LOBs, 7.7.4.3

from external procedures, 9.7.2

LOB streaming interface, 7.7.4.1

parameter modes, 15.1.10

registration for Transparent Application Failover, 9.8.3

restrictions, 9.7.1.11

Transparent Application Failover, 9.8

user-defined functions, 9.7

canceling OCI calls, 2.12.4

cancelling a cursor, 16.1.10

cartridge functions, 19

CASE OTT parameter, 14.8.2.10

change notification, database, 9.12

CHAR

external datatype, 3.3.16

character length semantics, 5.7.5.1, 5.7.5.3, 5.7.6.1, 6.3

character set conversion of Unicode, 2.14.12

character set form, 5.7.1

character set ID, 5.7.1

Unicode, A.11, A.12

CHARZ

external datatype, 3.3.17

checkerr() listing, 16.1.10

CHUNK size, 7.6

CLIENTCONTEXT namespace, 8.6.1

CLOB

datatype, 3.3.21.3, 3.3.21.3

code

example programs, B

list of demonstration programs, B

CODE OTT parameter, 14.8.2.4

coding guidelines

reserved words, 2.12.6

coherency

of object cache, 13.1.1

collections

attributes, 6.2.7

data manipulation functions, 11.9.2

describing, 6.1

description, 11.9

functions for manipulating, 11.9.1

multi level, 11.10

scanning functions, 11.9.3

column objects

direct path loading of, 12.2.2

columns

attributes, 6.1.2.3, 6.2.10

commit, 2.9

in object applications, 13.1.8

one-phase for global transactions, 8.2.2.7

two-phase for global transactions, 8.2.2.7

compiling

OCI applications, D.4

OCI with Oracle XA, D.7.1

XA Library, D.7

complex object retrieval, 10.3.10

implementing, 10.3.10.2

navigational prefetching, 10.3.11

complex object retrieval (COR) descriptor, 2.6.6

attributes, A.16.2

complex object retrieval (COR) handle, 2.5.7

attributes, A.16.1

CONFIG OTT parameter, 14.8.2.8

configuration files, D.2

location, D.2

connect functions, 15.1.10

connection, 2.8.3

connection mode

nonblocking, 2.12.7

connection pooling, 9.3, 9.5

code example, 9.3.3

connection pools and TAF, 9.3.1.4

consistency

of object cache, 13.1.1

copying

objects, 10.3.15

COR, see complex object retrieval

creating

objects, 10.3.15

cursor cancellation, 16.1.10

D

data cartridges

OCI functions, 2.1, 19

data definition language

SQL statements, 1.1.6.1

data manipulation language

SQL statements, 1.1.6.3

data structures

new for 8.0, 2.4

database connection

for object applications, 10.3.3

databases

attributes, 6.2.14

describing, 6.1

datatypes

ANSI DATE, 3.3.22.1

BFILE, 3.3.21.1

binding and defining, 11.16

BLOBs (binary large objects), 3.3.21.2

CLOB, 3.3.21.3

conversions, 3.4

direct path loading, 12.1.1, A.19.5.1

external, 3.1.1, 3.3

FILE, 3.3.21.1

for piecewise operations, 5.9.1

internal, 3.2

internal codes, 3.2

INTERVAL DAY TO SECOND, 3.3.22.6

INTERVAL YEAR TO MONTH, 3.3.22.5

manipulating with OCI, 11.3

mapping and manipulation functions, C.6

mapping from Oracle to C, 11.2

mapping, Oracle methodology, 11.2.1

mapping, OTT, 14.5

NCLOB, 3.3.21.4

Oracle, 3.1

TIMESTAMP, 3.3.22.2

TIMESTAMP WITH LOCAL TIME ZONE, 3.3.22.4

TIMESTAMP WITH TIME ZONE, 3.3.22.3

DATE

external datatype, 3.3.9

date cache, 12.1.6

DATE, ANSI

datatype, 3.3.22.1

datetime

avoiding unexpected results, 3.3.22.7

datetime and date

migration rules, 3.4.3

DDL. See data definition language

default file name extensions

OTT, 14.8.7

default name mapping

OTT, 14.8.7

define

arrays, 11.15.3.1

return and error codes, 2.11.1

define functions, 15.1.10

define handle

attributes, A.12

description, 2.5.5

define operation, 4.6, 5.3, 11.15

example, 5.3.1

LOBs, 5.4.1

named datatypes, 11.15.1

piecewise fetch, 5.4.3

PL/SQL output variables, 5.4.2

REFs, 11.15.2

steps used, 5.3.1

defining

OCINumber, 11.16.1

deletes

positioned, 2.12.5

demonstration files location, 2.2

demonstration programs, B, D.3

list, B

describe

explicit, 4.5.2

explicit and implicit, 6.1.2.3

implicit, 4.5.1

of collections, 6.1

of databases, 6.1

of packages, 6.1

of schemas, 6.1

of sequences, 6.1

of stored functions, 6.1

of stored procedures, 6.1

of synonyms, 6.1

of tables, 6.1

of types, 6.1

of views, 6.1

select-list, 4.5

describe functions, 15.1.10

describe handle

attributes, A.13

description, 2.5.6

describe operation

server round trips, C.5

describe, explicit, 4.5

describe, implicit, 4.5

descriptor, 2.6

allocating, 2.8.2

complex object retrieval, 2.6.6

objects, 11.12.1

parameter, 2.6.3

ROWID, 2.6.4

snapshot, 2.6.1

descriptor functions, 15.1.10

descriptor objects, 11.12.1

detaching branches, 8.2.2.5

direct path

of date columns, 12.1.6

direct path function context, 12.1.2.2

direct path handles, 2.5.10

direct path loading, 12.1

column array handle attributes, A.19.3

column parameter attributes, A.19.5

context handle attributes, A.19.1

datatypes of columns, 12.1.1, A.19.5.1

direct path column array handle, 12.1.2.3

direct path context handle, 12.1.2.1

direct path stream handle, 12.1.2.4

example, 12.1.5

functions, 12.1.3, 16.1.10

handle attributes, A.19

handles, 12.1.2

in pieces, 12.3

limitations, 12.1.4

stream handle attributes, A.19.4

directory structures, D.2

DML. See data manipulation language

duration

example, 13.1.9.1

of objects, 13.1.9

dynamic registration

Oracle XA Library, D.7.2

dynamically-linked applications, 1.2.2

E

embedded objects

fetching, 10.3.8

embedded SQL, 1.1.6.6

mixing with OCI calls, 1.1.6.6

enhanced DML array, 4.4.2.1

enhanced DML array feature, 4.4.2.1

environment handle

attributes, A.2

description, 2.5.2

error checking example, 16.1.10

error codes

define calls, 2.11.1

navigational functions, 17.1.12

error handle

attributes, A.3

description, 2.5.3

errors

handling, 2.11

handling in object applications, 10.3.19

ERRTYPE OTT parameter, 14.8.2.9

event callback, 9.9.4

example

demonstration programs, B

executing SQL statements, 4.4

execution

against multiple servers, 4.2.1

modes, 4.4.2

execution snapshots, 4.4.1

explicit describe, 4.5

extensions

OTT default file name, 14.8.7

external datatypes, 3.1.1, 3.3

CHAR, 3.3.16

CHARZ, 3.3.17

conversions, 3.4

DATE, 3.3.9

FLOAT, 3.3.4

INTEGER, 3.3.3

LOBs, 3.3.21

LONG, 3.3.7

LONG RAW, 3.3.12

LONG VARCHAR, 3.3.14

LONG VARRAW, 3.3.15

named datatypes, 3.3.18

NUMBER, 3.3.2

RAW, 3.3.10

REF, 3.3.19

ROWID, 3.3.20

SQLT_BLOB, 3.3.21

SQLT_CLOB, 3.3.21

SQLT_NCLOB, 3.3.21

SQLT_NTY, 3.3.18

SQLT_REF, 3.3.19

STRING, 3.3.5

UNSIGNED, 3.3.13

VARCHAR, 3.3.8

VARCHAR2, 3.3.1

VARNUM, 3.3.6

VARRAW, 3.3.11

external procedure functions

return codes, 19.1.8

with_context type, 19.1.9

external procedures

OCI callbacks, 9.7.2

Externally Initialized Context, 8.5

F

failover

callback example, 9.8.4

failover callbacks, 9.8

failover callbacks structure and parameters, 9.8.2

fetch

piecewise, 5.9, 5.9.5

fetch operation, 4.7

LOB data, 4.7.1

setting prefetch count, 4.7.2

FILE

associating with OS file, 7.3

datatype, 3.3.21.1

FLOAT

external datatype, 3.3.4

flushing, 13.1.6.1

object changes, 10.3.7

objects, 13.1.6.1

freeing

objects, 10.3.15, 13.1.4.3

functions

attributes, 6.2.2

G

generic documentation references

compiling and linking OCI applications, D.4, D.5

demonstration programs, D.3

invoking OTT from the command line, D.8

XA linking file names, D.7

global transactions, 8.2.2

globalization support, 2.14

OCI functions, 2.1

GTRID. See transaction identifier

H

HA event notification, 9.9

handle attributes, 2.5.12

reading, 2.5.12

setting, 2.5.12

handle functions, 15.1.10

handles, 2.5, 2.5

advantages of, 2.5.1

allocating, 2.5.1, 2.8.2

bind handle, 2.5.5

C datatypes, 2.5

child freed when parent freed, 2.5.1

define handle, 2.5.5

describe handle, 2.5.6

direct path, 2.5.10

environment handle, 2.5.2

error handle, 2.5.3

freeing, 2.5.1

process attributes, A.20

server handle, 2.5.4

service context handle, 2.5.4

statement handle, 2.5.5

subscription, 2.5.9, 9.11.1.1

transaction handle, 2.5.4

types, 2.5

user session handle, 2.5.4

header files

location of, 1.1.17, D.2, D.4

header files location, 2.2

HFILE OTT parameter, 14.8.2.7

I

implicit describe, 4.5

include directory, D.2

indicator variables, 2.12.3

arrays of structures, 5.5.3

for named datatypes, 2.12.2, 2.12.3.3

for REF, 2.12.2

for REFs, 2.12.3.3

named datatype defines, 11.15.3

PL/SQL OUT binds, 11.15.3

REF defines, 11.15.3

with named datatype bind, 11.14.3

with REF bind, 11.14.3

INITFILE OTT parameter, 14.8.2.5

INITFUNC OTT parameter, 14.8.2.6

initialize all buffers, 5.1.3

initialize functions, 15.1.10

inserts

piecewise, 5.9, 5.9.3

Instant Client feature, 1.3

Instant Client Light (English), 1.3.8

INTEGER

external datatype, 3.3.3

internal codes for datatypes

datatype codes, 3.2

internal datatypes, 3.2

conversions, 3.4

INTERVAL DAY TO SECOND datatype, 3.3.22.6

INTERVAL YEAR TO MONTH datatype, 3.3.22.5

intype file

providing when running OTT, 14.4

structure of, 14.8.4

INTYPE File Assistant, D.8

INTYPE OTT parameter, 14.8.2.2

K

key words, 2.12.6

L

LDAP registration of publish-subscribe notification, 9.11.1.3

libraries

oci.lib, D.5

linking

OCI applications, D.5

OCI with Oracle XA, D.7.1

XA Library, D.7

lists

attributes, 6.2.12

lmsgen utility, 2.14.16

LoadLibrary, D.5.2

LOB functions, 16.1.10

server round trips, C.3

LOB locator, 2.6.2

attributes, A.15

LOBs

amount and offset parameters, 16.1.10

attributes of transient objects, 7.4.2

binding, 5.2.1

buffering, 7.7.2

callbacks, 7.7.4

character sets, 16.1.10

creating, 7.2

creating temporary, 7.8.1

defining, 5.4.1

duration of temporary, 7.8.2

example of temporary, 7.8.5

external datatypes, 3.3.21

failover does not work, 9.8.5

fetching data, 4.7.1

fixed-width character sets, 16.1.10

freeing temporary, 7.8.1

greater than 4GB, 7.6

locator, 2.6.2

modifying, 7.2

OCI functions, 7.7

size maximum, 7.6

temporary, 7.8

varying-width character sets, 16.1.10

locator, 2.6

for LOB datatype, 2.6.2

locking, 13.1.7.2

objects, 13.1.7.2

optimistic model, 13.1.7.4

LONG

external datatype, 3.3.7

LONG RAW

external datatype, 3.3.12

LONG VARCHAR

external datatype, 3.3.14

LONG VARRAW

external datatype, 3.3.15

M

make.bat, D.3

Makefile (Unix), B

marking

objects, 13.1.5.1

meta-attributes

of objects, 10.3.9

of persistent objects, 10.3.9.1

of transient objects, 10.3.9.3

method descriptor object, 11.12.1

migration

7.x to 8.0, 1.2.5

session, 8.3.1, 15.1.10

miscellaneous functions, 16.1.10

multiple servers

executing statement against, 4.2.1

multithreaded development

basic concepts, 9.1

multithreading, 9.1

mutexes, 9.1

N

named datatypes

binding, 11.14.1

binding and defining, 11.16

defining, 11.15.1

definition, 3.3.18

external datatypes, 3.3.18

indicator variables, 2.12.3.3

indicator variables for, 2.12.2

native double, 3.3.23

native float, 3.3.23

navigation, 13.2

navigational functions

error codes, 17.1.12

return values, 17.1.10

terminology, 17.1.2

NCHAR

issues, 5.7

NCLOB

datatype, 3.3.21.4, 3.3.21.4

nested table

element ordering, 11.9.5.1

functions for manipulating, 11.9.5

nested tables

direct path loading of, 12.2.1

new release, re-linking, 1.2.2

NLS_LANG, 2.14.1

NLS_NCHAR, 2.14.1

nonblocking mode, 2.12.7

non-final object tables

direct path loading of, 12.2.7

no-op

definition, 17.1.12

NULL indicator

setting for an object attribute, 10.3.14

NULL indicator struct, 10.3.14

generated by OTT, 10.3.1

nullness

of objects, 10.3.14

NULLs

atomic, 10.3.14

inserting, 2.12.3.1

inserting into database, 2.12.2

inserting using indicator variables, 2.12.2

NUMBER

external datatype, 3.3.2

O

object

view, 10.3.9.1

object applications

commit, 13.1.8

database connection, 10.3.3

rollback, 13.1.8

object cache, 13.1

coherency, 13.1.1

consistency, 13.1.1

initializing, 10.3.2

loading objects, 13.1.4

memory parameters, 13.1.2

operations on, 13.1.3

removing objects, 13.1.4

setting the size of, 13.1.2

object functions

server round trips, C.4

object identifier

for persistent objects, 10.2.2

object reference, 10.3.17

object reference. See REFs

object runtime environment

initializing, 10.3.2

object tables

direct path loading of, 12.2.6

object type

representing in C applications, 10.3.1

object type translator

sample output, 10.3.1

use with OCI, 10.3.1

Object Type Translator (OTT), D.8

objects

accessing with OCI, 14.7.1

allocation duration, 13.1.9

array pin, 10.3.5.1

attributes, 10.3.9

manipulating, 10.3.6

client-side cache, 13.1

copying, 10.3.15

creating, 10.3.15

duration, 13.1.9

flushing, 13.1.6.1

flushing changes, 10.3.7

freeing, 10.3.15, 13.1.4.3

lifetime, 17.1.1

LOB attributes of transient objects, 7.4.2

locking, 13.1.7.2

manipulating with OCI, 14.7.1

marking, 10.3.7, 13.1.5.1

memory layout of instance, 13.1.10

memory management, 13.1

meta-attributes, 10.3.9

navigation, 13.2

simple, 13.2.1

NCHAR and NVARCHAR2 attribute of, 11.2

NULLs, 10.3.14

OCI object application structure, 10.2.1

persistent, 10.2.2, 10.2.2.1

pin count, 10.3.13

pin duration, 13.1.9

pinning, 10.3.5, 13.1.4.1

refreshing, 13.1.6.2

secondary memory, 13.1.10

terminology, 17.1.1

top-level memory, 13.1.10

transient, 10.2.2, 10.2.2.2

types, 10.2.2, 17.1.1

unmarking, 13.1.5.2

unpinning, 10.3.13, 13.1.4.2

use with OCI, 10.1

OCI

aborting calls, 2.12.4

accessing and manipulating objects, 14.7.1

advantages, 1.1.1

object support, 1.1.5

Oracle XA Library, D.7.1

overview, 1.1

parts of, 1.1.3

sample programs, D.3

OCI application

compiling, 1.1.2

general structure, 2.3

initialization example, 2.8.3.4

linking, 1.1.2

steps, 2.7

structure, 2.3

structure using objects, 10.2.1

terminating, 2.10

using the OTT with, 14.7

with objects

initializing, 10.3.2

OCI applications

compiling, D.4

linking, D.5

running, D.6

oci directory, D.2

OCI environment

initializing for objects, 10.3.2

OCI functions

canceling calls, 2.12.4

data cartridges, 2.1

globalization, 2.1

not supported, 1.2.4

obsolescent, 1.2.3

return codes, 2.11, 2.11.2

OCI navigational functions, 13.3

flush functions, 13.3.2

mark functions, 13.3.3

meta-attribute accessor functions, 13.3.4

miscellaneous functions, 13.3.5

naming scheme, 13.3

pin/unpin/free functions, 13.3.1

OCI process

initializing for objects, 10.3.2

OCI program. See OCI application

OCI relational functions

connect, authorize, and initialize, 15.1.10

guide to reference entries, 19.1.1

Streams Advanced Queuing and publish-subscribe, 16.1.10

OCI_ATTR_ACTION, 8.4.3.3, A.5.2

OCI_ATTR_ADMIN_PFILE, A.6

OCI_ATTR_AGENT_ADDRESS, A.17.4

OCI_ATTR_AGENT_NAME, A.17.4

OCI_ATTR_AGENT_PROTOCOL, A.17.4

OCI_ATTR_ALLOC_DURATION

environment handle attribute, A.2

OCI_ATTR_APPCTX_ATTR, 8.5.1.3, A.5.2

OCI_ATTR_APPCTX_LIST, 8.5.1.2, A.5.2

OCI_ATTR_APPCTX_NAME, 8.5.1.3

OCI_ATTR_APPCTX_SIZE, 8.5.1.1, A.5.2

OCI_ATTR_APPCTX_VALUE, 8.5.1.3, A.5.2

OCI_ATTR_ATTEMPTS, A.17.3

OCI_ATTR_AUTOCOMMIT_DDL

attribute, 6.2.14

OCI_ATTR_BIND_COUNT, A.10

OCI_ATTR_BIND_DN, A.2

OCI_ATTR_BUF_ADDR, A.19.4

OCI_ATTR_BUF_SIZE, A.19.1, A.19.4

OCI_ATTR_CACHE

attribute, 6.2.9

OCI_ATTR_CACHE_ARRAYFLUSH, 13.1.6.1

environment handle attribute, A.2

OCI_ATTR_CACHE_MAX_SIZE, 13.1.2

environment handle attribute, A.2

OCI_ATTR_CACHE_OPT_SIZE, 13.1.2

environment handle attribute, A.2

OCI_ATTR_CALL_TIME, 8.4.3.2, A.5.2

OCI_ATTR_CATALOG_LOCATION

attribute, 6.2.14

OCI_ATTR_CERTIFICATE, A.5.2

OCI_ATTR_CHAR_COUNT

bind handle attribute, A.11

define handle attribute, A.12

OCI_ATTR_CHAR_SIZE, 6.2.10

attribute, 6.3

OCI_ATTR_CHAR_USED, 6.2.10

attribute, 6.3

OCI_ATTR_CHARSET_FORM, 5.7.1.1, 6.2.11

attribute, 6.2.5, 6.2.7, 6.2.10

bind handle attribute, A.11

define handle attribute, A.12

OCI_ATTR_CHARSET_ID, 5.7.1.1, A.19.1, A.19.5.1

attribute, 6.2.5, 6.2.7, 6.2.10, 6.2.11, 6.2.14

bind handle attribute, A.11

define handle attribute, A.12

OCI_ATTR_CHDES_DBNAME, 9.12.3, A.18.2

OCI_ATTR_CHDES_NFTYPE, 9.12.3, A.18.2

OCI_ATTR_CHDES_ROW_OPFLAGS, 9.12.3, A.18.2

OCI_ATTR_CHDES_ROW_ROWID, 9.12.3, A.18.2

OCI_ATTR_CHDES_TABLE_CHANGES, A.18.2

OCI_ATTR_CHDES_TABLE_NAME, 9.12.3, A.18.2

OCI_ATTR_CHDES_TABLE_OPFLAGS, 9.12.3, A.18.2

OCI_ATTR_CHDES_TABLE_ROW_CHANGES, 9.12.3, A.18.2

OCI_ATTR_CHNF_CHANGELAG, 9.12.2, A.18.1

OCI_ATTR_CHNF_OPERATIONS, 9.12.2, A.18.1

OCI_ATTR_CHNF_ROWIDS, 9.12.2, A.18.1

OCI_ATTR_CHNF_TABLENAMES, 9.12.2, A.18.1

OCI_ATTR_CLIENT_IDENTIFIER, 8.4.1.6, A.5.2

OCI_ATTR_CLIENT_INFO, 8.4.3.3, A.5.2

OCI_ATTR_CLUSTERED

attribute, 6.2.1

OCI_ATTR_COL_COUNT, A.19.3

OCI_ATTR_COLLECT_CALL_TIME, 8.4.3.1, A.5.2

OCI_ATTR_COLLECTION_ELEMENT

attribute, 6.2.4

OCI_ATTR_COLLECTION_TYPECODE

attribute, 6.2.4

OCI_ATTR_COMMENT

attribute, 6.2.15, 6.2.16, 6.2.17

OCI_ATTR_COMPLEXOBJECT_ COLL_OUTOFLINE

COR handle attribute, A.16.1

OCI_ATTR_COMPLEXOBJECT_LEVEL

COR handle attribute, A.16.1

OCI_ATTR_COMPLEXOBJECTCOMP _TYPE_LEVEL

COR descriptor attribute, A.16.2

OCI_ATTR_COMPLEXOBJECTCOMP_TYPE

COR descriptor attribute, A.16.2

OCI_ATTR_CONDITION

attribute, 6.2.15

OCI_ATTR_CONN_BUSY_COUNT, A.7

OCI_ATTR_CONN_INCR, A.7

OCI_ATTR_CONN_MAX, A.7

OCI_ATTR_CONN_MIN, A.7

OCI_ATTR_CONN_NOWAIT, A.7, A.7

OCI_ATTR_CONN_OPEN_COUNT, A.7

OCI_ATTR_CONN_TIMEOUT, 9.3.2.2, A.7

OCI_ATTR_CONSUMER_NAME, A.17.2

OCI_ATTR_CORRELATION, A.17.2, A.17.3

OCI_ATTR_CURRENT_POSITION

attribute, 4.8, A.10

OCI_ATTR_CURRENT_SCHEMA, A.5.2

OCI_ATTR_CURSOR_COMMIT_ BEHAVIOR

attribute, 6.2.14

OCI_ATTR_DATA_SIZE, 6.2.10, 6.3, A.19.5.1

attribute, 6.2.5, 6.2.7, 6.2.10, 6.2.11

OCI_ATTR_DATA_TYPE, A.19.5.1

attribute, 6.2.5, 6.2.7, 6.2.10, 6.2.11

OCI_ATTR_DATE_FORMAT, A.19.1

OCI_ATTR_DATEFORMAT, A.19.5.1

OCI_ATTR_DBA

attribute, 6.2.1

OCI_ATTR_DBDOMAIN, A.21

OCI_ATTR_DBNAME, A.21

OCI_ATTR_DELAY, A.17.3

OCI_ATTR_DEQ_MODE, A.17.2

OCI_ATTR_DEQ_MSGID, A.17.2

OCI_ATTR_DESC_PUBLIC, 15.1.10

OCI_ATTR_DIRPATH_DCACHE_DISABLE, 12.1.6.5, A.19.1

OCI_ATTR_DIRPATH_DCACHE_HITS, 12.1.6.4, A.19.1

OCI_ATTR_DIRPATH_DCACHE_MISSES, 12.1.6.3, A.19.1

OCI_ATTR_DIRPATH_DCACHE_NUM, 12.1.6.2, A.19.1

OCI_ATTR_DIRPATH_DCACHE_SIZE, 12.1.6.1, A.19.1

OCI_ATTR_DIRPATH_EXPR_TYPE direct path function attribute, A.19.2

OCI_ATTR_DIRPATH_EXPR_TYPE function context attribute, 12.4.2.3

OCI_ATTR_DIRPATH_INDEX_MAINT_METHOD, A.19.1

OCI_ATTR_DIRPATH_MODE, A.19.1

OCI_ATTR_DIRPATH_NOLOG, A.19.1

OCI_ATTR_DIRPATH_OBJ_CONSTR, 12.4.2.1, A.19.1

OCI_ATTR_DIRPATH_OBJ_CONSTR direct path context attribute, 12.4.1.1

OCI_ATTR_DIRPATH_OID, A.19.5.1

OCI_ATTR_DIRPATH_PARALLEL, 12.1, A.19.1

OCI_ATTR_DIRPATH_SID column array attribute, 12.4.3.2

OCI_ATTR_DIRPATH_SKIPINDEX_METHOD, A.19.1

OCI_ATTR_DISTINGUISHED_NAME, 8.4.1.3, 8.4.1.4, A.5.2

OCI_ATTR_DML_ROW_OFFSET

error handle attribute, A.3

OCI_ATTR_DN_COUNT, A.17.5

OCI_ATTR_DURATION

attribute, 6.2.1

OCI_ATTR_ENCAPSULATION

attribute, 6.2.6

OCI_ATTR_ENQ_TIME, A.17.3

OCI_ATTR_ENV, A.10

server handle attribute, A.5

service context handle attribute, A.4

OCI_ATTR_ENV_CHARSET_ID, 2.14.3

environment handle attribute, A.2

OCI_ATTR_ENV_NCHARSET_ID, 2.14.3

environment handle attribute, A.2

OCI_ATTR_ENV_UTF16

environment handle attribute, A.2

OCI_ATTR_EVAL_CONTEXT_NAME

attribute, 6.2.15, 6.2.16

OCI_ATTR_EVAL_CONTEXT_OWNER

attribute, 6.2.15, 6.2.16

OCI_ATTR_EVALUATION_FUNCTION

attribute, 6.2.17

OCI_ATTR_EVENTTYPE, A.21

OCI_ATTR_EVTCBK, 9.9.4

environment handle attribute, A.2

OCI_ATTR_EVTCTX, 9.9.4

environment handle attribute, A.2

OCI_ATTR_EXCEPTION_QUEUE, A.17.3

OCI_ATTR_EXPIRATION, A.17.3

OCI_ATTR_EXTERNAL_NAME, 8.2.2.6

server handle attribute, A.5

OCI_ATTR_FOCBK

server handle attribute, A.5

OCI_ATTR_FSPRECISION

attribute, 6.2.5

OCI_ATTR_HA_SOURCE, A.21

OCI_ATTR_HA_SRVFIRST, A.21

OCI_ATTR_HA_SRVNEXT, A.21

OCI_ATTR_HA_STATUS, A.21

OCI_ATTR_HA_SVRFIRST, 9.9.4

OCI_ATTR_HA_SVRNEXT, 9.9.4

OCI_ATTR_HA_TIMESTAMP, A.21

OCI_ATTR_HAS_DEFAULT

attribute, 6.2.11

OCI_ATTR_HAS_FILE

attribute, 6.2.4

OCI_ATTR_HAS_LOB

attribute, 6.2.4

OCI_ATTR_HAS_NESTED_TABLE

attribute, 6.2.4

OCI_ATTR_HEAPALLOC

environment handle attribute, A.2

OCI_ATTR_HOSTNAME, A.21

OCI_ATTR_HW_MARK

attribute, 6.2.9

OCI_ATTR_IN_V8_MODE

server handle attribute, A.5

service context handle attribute, A.4

OCI_ATTR_INCR

attribute, 6.2.9

OCI_ATTR_INDEX_ONLY

attribute, 6.2.1

OCI_ATTR_INITIAL_CLIENT_ROLES, 8.4.1.5, A.5.2

OCI_ATTR_INSTNAME, A.21

OCI_ATTR_INTERNAL_NAME, 8.2.2.6

server handle attribute, A.5

OCI_ATTR_IOMODE

attribute, 6.2.11

OCI_ATTR_IS_CONSTRUCTOR

attribute, 6.2.6

OCI_ATTR_IS_DESTRUCTOR

attribute, 6.2.6

OCI_ATTR_IS_FINAL_METHOD

attribute, 6.2.6

OCI_ATTR_IS_FINAL_TYPE

attribute, 6.2.4

OCI_ATTR_IS_INCOMPLETE_TYPE

attribute, 6.2.4

OCI_ATTR_IS_INSTANTIABLE_METHOD

attribute, 6.2.6

OCI_ATTR_IS_INSTANTIABLE_TYPE

attribute, 6.2.4

OCI_ATTR_IS_INVOKER_RIGHTS

attribute, 6.2.2, 6.2.3, 6.2.4

OCI_ATTR_IS_MAP

attribute, 6.2.6

OCI_ATTR_IS_NULL

attribute, 6.2.10, 6.2.11

OCI_ATTR_IS_OPERATOR

attribute, 6.2.6

OCI_ATTR_IS_ORDER

attribute, 6.2.6

OCI_ATTR_IS_OVERRIDING_METHOD

attribute, 6.2.6

OCI_ATTR_IS_PREDEFINED_TYPE

attribute, 6.2.4

OCI_ATTR_IS_RNDS

attribute, 6.2.6

OCI_ATTR_IS_RNPS

attribute, 6.2.6

OCI_ATTR_IS_SELFISH

attribute, 6.2.6

OCI_ATTR_IS_SUBTYPE

attribute, 6.2.4

OCI_ATTR_IS_SYSTEM_GENERATED_TYPE

attribute, 6.2.4

OCI_ATTR_IS_SYSTEM_TYPE

attribute, 6.2.4

OCI_ATTR_IS_TEMPORARY

attribute, 6.2.1

OCI_ATTR_IS_TRANSIENT_TYPE

attribute, 6.2.4

OCI_ATTR_IS_WNDS

attribute, 6.2.6

OCI_ATTR_IS_WNPS

attribute, 6.2.6

OCI_ATTR_LDAP_AUTH, A.2

OCI_ATTR_LDAP_CRED, A.2

OCI_ATTR_LDAP_CTX, A.2

OCI_ATTR_LDAP_HOST, A.2

OCI_ATTR_LDAP_PORT, A.2

OCI_ATTR_LEVEL

attribute, 6.2.11

OCI_ATTR_LFPRECISION

attribute, 6.2.5

OCI_ATTR_LINK

attribute, 6.2.8, 6.2.11

OCI_ATTR_LIST_ACTION_CONTEXT

attribute, 6.2.15

OCI_ATTR_LIST_ARGUMENTS

attribute, 6.2.2, 6.2.6

OCI_ATTR_LIST_COLUMNS, A.19.1

attribute, 6.2.1

OCI_ATTR_LIST_COLUMNS direct path function context attribute, A.19.2

OCI_ATTR_LIST_OBJECTS

attribute, 6.2.13

OCI_ATTR_LIST_RULES

attribute, 6.2.16

OCI_ATTR_LIST_SCHEMAS

attribute, 6.2.14

OCI_ATTR_LIST_SUBPROGRAMS

attribute, 6.2.3

OCI_ATTR_LIST_TABLE_ALIASES

attribute, 6.2.17

OCI_ATTR_LIST_TYPE

attribute, 6.2.12

OCI_ATTR_LIST_TYPE_ATTRS

attribute, 6.2.4

OCI_ATTR_LIST_TYPE_METHODS

attribute, 6.2.4

OCI_ATTR_LIST_VARIABLE_TYPES

attribute, 6.2.17

OCI_ATTR_LOBEMPTY

LOB locator attribute, A.15

OCI_ATTR_LOCKING_MODE

attribute, 6.2.14

OCI_ATTR_MAP_METHOD

attribute, 6.2.4

OCI_ATTR_MAX

attribute, 6.2.9

OCI_ATTR_MAX_CATALOG_ NAMELEN

attribute, 6.2.14

OCI_ATTR_MAX_COLUMN_ NAMELEN

attribute, 6.2.14

OCI_ATTR_MAX_PROC_NAMELEN

attribute, 6.2.14

OCI_ATTR_MAXCHAR_SIZE, A.11, A.12

attribute, 5.7.3

OCI_ATTR_MAXCHAR_SIZE attribute, 5.7.4

OCI_ATTR_MAXDATA_SIZE

attribute, 5.7.3

bind handle attribute, A.11

use with binding, 5.7.3

OCI_ATTR_MEMPOOL_APPNAME, A.20

OCI_ATTR_MEMPOOL_HOMENAME, A.20

OCI_ATTR_MEMPOOL_INSTNAME, A.20

OCI_ATTR_MEMPOOL_SIZE, A.20

OCI_ATTR_MIGSESSION

user session handle attribute, A.5.2

OCI_ATTR_MIN

attribute, 6.2.9

OCI_ATTR_MODULE, 8.4.3.3

OCI_ATTR_MSG_DELIVERY_MODE, 16.1.10, 16.1.10, A.17.1, A.17.2, A.17.3

OCI_ATTR_MSG_STATE, A.17.3

OCI_ATTR_NAME, A.19.1, A.19.5.1

attribute, 6.2.2, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8, 6.2.10, 6.2.11, 6.2.18, 6.2.20

OCI_ATTR_NAME column array attribute, 12.4.3.1

OCI_ATTR_NAME direct path function context attribute, A.19.2

OCI_ATTR_NAME function context attribute, 12.4.2.2

OCI_ATTR_NAVIGATION, A.17.2

OCI_ATTR_NCHARSET_ID

attribute, 6.2.14

OCI_ATTR_NONBLOCKING_MODE

server handle attribute, 2.12.8, A.5

OCI_ATTR_NOWAIT_SUPORT

attribute, 6.2.14

OCI_ATTR_NUM_COLS, A.19.1, A.19.3

attribute, 6.2.1

OCI_ATTR_NUM_COLS direct path function context attribute, 12.4.2.4, A.19.2

OCI_ATTR_NUM_DML_ERRORS, A.10

OCI_ATTR_NUM_ELEMENTS

attribute, 6.2.7

OCI_ATTR_NUM_HANDLES attribute, 6.2.12

OCI_ATTR_NUM_PARAMS

attribute, 6.2

OCI_ATTR_NUM_ROWS, A.19.3

OCI_ATTR_NUM_ROWS attribute, 12.4.4.1

OCI_ATTR_NUM_ROWS direct path context attribute, A.19.1

OCI_ATTR_NUM_ROWS direct path function context attribute, A.19.2

OCI_ATTR_NUM_ROWS function context attribute, 12.4.2.5

OCI_ATTR_NUM_TYPE_ATTRS

attribute, 6.2.4

OCI_ATTR_NUM_TYPE_METHODS

attribute, 6.2.4

OCI_ATTR_OBJ_ID

attribute, 6.2

OCI_ATTR_OBJ_NAME

attribute, 6.2

OCI_ATTR_OBJ_SCHEMA

attribute, 6.2

OCI_ATTR_OBJECT

environment handle attribute, A.2

OCI_ATTR_OBJECT_DETECTCHANGE, 13.1.7.4

environment handle attribute, 13.1.7.4, A.2

OCI_ATTR_OBJECT_NEWNOTNULL, 17.1.12

environment handle attribute, A.2

OCI_ATTR_OBJID

attribute, 6.2.1, 6.2.8, 6.2.9

OCI_ATTR_ORDER

attribute, 6.2.9

OCI_ATTR_ORDER_METHOD

attribute, 6.2.4

OCI_ATTR_ORIGINAL_MSGID, A.17.3

OCI_ATTR_OVERLOAD

attribute, 6.2.2

OCI_ATTR_PARAM

describe handle attribute, A.13

use when an attribute is itself a descriptor, 15.1.10

OCI_ATTR_PARAM_COUNT

describe handle attribute, A.13

OCI_ATTR_PARAM_COUNT statement handle attribute, A.10

OCI_ATTR_PARSE_ERROR_OFFSET statement handle attribute, A.10

OCI_ATTR_PARTITIONED

attribute, 6.2.1

OCI_ATTR_PASSWORD, 8.4.1.7, 8.4.1.7

user session handle attribute, A.5.2

OCI_ATTR_PDPRC, A.11, A.12

OCI_ATTR_PDSCL

bind handle attribute, A.11, A.12

OCI_ATTR_PIN_DURATION

environment handle attribute, A.2

OCI_ATTR_PINOPTION

environment handle attribute, A.2

OCI_ATTR_POSITION

attribute, 6.2.11

OCI_ATTR_PRECISION, A.19.5.1

attribute, 6.1.2.3, 6.2.5, 6.2.7, 6.2.10, 6.2.11

OCI_ATTR_PREFETCH_MEMORY statement handle attribute, A.10

OCI_ATTR_PREFETCH_ROWS

statement handle attribute, A.10

OCI_ATTR_PRIORITY, A.17.3

OCI_ATTR_PROC_MODE, A.20

OCI_ATTR_PROXY_CLIENT, 2.8.3.2, A.5.2

OCI_ATTR_PROXY_CREDENTIALS, 8.4.1.2, A.5.2

OCI_ATTR_PTYPE

attribute, 6.2

OCI_ATTR_RADIX

attribute, 6.2.11

OCI_ATTR_RECIPIENT_LIST, A.17.3

OCI_ATTR_REF_TDO

attribute, 6.2.1, 6.2.4, 6.2.5, 6.2.7, 6.2.10, 6.2.11

OCI_ATTR_RELATIVE_MSGID, A.17.1

OCI_ATTR_RELATIVE_MSGID enqueue option, 9.10.3

OCI_ATTR_ROW_COUNT, 4.8, 4.8, A.10, A.19.3, A.19.4

OCI_ATTR_ROWID

statement handle attribute, A.10

OCI_ATTR_ROWS_FETCHED, 4.8, A.10

OCI_ATTR_ROWS_RETURNED

bind handle attribute, A.11

use with callbacks, 5.6.5

OCI_ATTR_SAVEPOINT_SUPPORT

attribute, 6.2.14

OCI_ATTR_SCALE, A.19.5.1

attribute, 6.2.5, 6.2.7, 6.2.10, 6.2.11

OCI_ATTR_SCHEMA_NAME, A.19.1

attribute, 6.2.4, 6.2.5, 6.2.7, 6.2.8, 6.2.10, 6.2.11

OCI_ATTR_SENDER_ID, A.17.3

OCI_ATTR_SEQ

attributes, 6.2.9

OCI_ATTR_SEQUENCE enqueue option, 9.10.3

OCI_ATTR_SEQUENCE_DEVIATION, A.17.1

OCI_ATTR_SERVER

service context handle attribute, A.4

OCI_ATTR_SERVER_DN, A.17.5

OCI_ATTR_SERVER_DNS, A.18

OCI_ATTR_SERVER_GROUP

server handle attribute, A.5

OCI_ATTR_SERVER_STATUS, 2.11

server handle attribute, A.5

OCI_ATTR_SERVICENAME, A.21

OCI_ATTR_SESSION

service context handle attribute, A.4

OCI_ATTR_SHARED_HEAP_ALLOC

environment handle attribute, A.2

OCI_ATTR_SPOOL_BUSY_COUNT, A.8, A.8

OCI_ATTR_SPOOL_GETMODE, A.8

OCI_ATTR_SPOOL_INCR, A.8

OCI_ATTR_SPOOL_MAX, A.8

OCI_ATTR_SPOOL_MIN, A.8

OCI_ATTR_SPOOL_OPEN_COUNT, A.8

OCI_ATTR_SPOOL_STMTCACHESIZE, A.8

OCI_ATTR_SPOOL_TIMEOUT, A.8

OCI_ATTR_SQLFNCODE

statement handle attribute, A.10

OCI_ATTR_STATEMENT statement handle attribute, A.10

OCI_ATTR_STMT_STATE, A.10

OCI_ATTR_STMT_TYPE

statement handle attribute, A.10

OCI_ATTR_STMTCACHESIZE, 9.6.3, 15.1.10, A.4

OCI_ATTR_STREAM_OFFSET, A.19.4

OCI_ATTR_SUB_NAME, A.19.1

attribute, 6.2.11

OCI_ATTR_SUBSCR_CALLBACK, A.18

OCI_ATTR_SUBSCR_CTX, A.18

OCI_ATTR_SUBSCR_NAME, A.18

OCI_ATTR_SUBSCR_NAMESPACE, A.18

OCI_ATTR_SUBSCR_PAYLOAD, A.18

OCI_ATTR_SUBSCR_PORTNO, A.18

OCI_ATTR_SUBSCR_QOSFLAGS, A.18

OCI_ATTR_SUBSCR_RECPT, A.18

OCI_ATTR_SUBSCR_RECPTPRES, A.18

OCI_ATTR_SUBSCR_RECPTPROTO, A.18

OCI_ATTR_SUBSCR_SERVER_DN descriptor handle, 9.11.1.3

OCI_ATTR_SUBSCR_TIMEOUT, 9.11.1.1, 9.11.1.3, A.18

OCI_ATTR_SUPERTYPE_NAME

attribute, 6.2.4

OCI_ATTR_SUPERTYPE_SCHEMA_NAME

attribute, 6.2.4

OCI_ATTR_TABLE_NAME

attribute, 6.2.18

OCI_ATTR_TABLESPACE

attribute, 6.2.1

OCI_ATTR_TAF_ENABLED, 9.9.7, A.5

OCI_ATTR_TIMESTAMP

attribute, 6.2

OCI_ATTR_TRANS

service context handle attribute, A.4

OCI_ATTR_TRANS_NAME, 8.2.2.1

transaction handle attribute, A.9

OCI_ATTR_TRANS_TIMEOUT

transaction handle attribute, A.9, A.9

OCI_ATTR_TRANSACTION_NO, A.17.3

OCI_ATTR_TYPE_NAME

attribute, 6.2.5, 6.2.7, 6.2.10, 6.2.11

OCI_ATTR_TYPECODE

attribute, 6.2.4, 6.2.5, 6.2.7, 6.2.11

OCI_ATTR_USER_MEMORY, 9.9.5

server handle attribute, A.5

OCI_ATTR_USERNAME, 2.8.3.2

user session handle attribute, A.5.2

OCI_ATTR_VALUE

attribute, 6.2.20

OCI_ATTR_VERSION

attribute, 6.2.14

OCI_ATTR_VISIBILITY, A.17.1, A.17.2

OCI_ATTR_WAIT, A.17.2

OCI_ATTR_WALL_LOC, A.2

OCI_ATTR_XID, 8.2.2.1

transaction handle attribute, A.9

OCI_BIND_SOFT, 15.1.10, 15.1.10

OCI_CONTINUE, 2.11

OCI_CPOOL_REINITIALIZE, 15.1.10

OCI_CRED_EXT, 15.1.10

OCI_CRED_PROXY, 8.4.1.1

OCI_CRED_RDBMS, 8.4.1.1, 15.1.10

OCI_DATA_AT_EXEC, 15.1.10, 15.1.10

OCI_DEFAULT, 9.1.3, 15.1.10

OCI_DEFINE_SOFT, 15.1.10

OCI_DESCRIBE_ONLY, 16.1.10

OCI_DIRPATH_COL_ERROR, 12.2.2.4

OCI_DIRPATH_DATASAVE_FINISH, 16.1.10

OCI_DIRPATH_DATASAVE_SAVEONLY, 16.1.10

OCI_DIRPATH_EXPR_OBJ_CONSTR, 12.4.2.2, 12.4.2.3

OCI_DIRPATH_EXPR_REF_TBLNAME, 12.2.4.1, 12.4.2.3

OCI_DIRPATH_EXPR_SQL, 12.4.2.2, 12.4.2.3

OCI_DIRPATH_OID column array attribute, 12.4.3.3

OCI_DTYPE_AQAGENT, 2.6

OCI_DTYPE_AQDEQ_OPTIONS, 2.6

OCI_DTYPE_AQENQ_OPTIONS, 2.6

OCI_DTYPE_AQLIS_MSG_PROPERTIES, 2.6

OCI_DTYPE_AQLIS_OPTIONS, 2.6

OCI_DTYPE_AQMSG_PROPERTIES, 2.6

OCI_DTYPE_AQNFY, 2.6

OCI_DTYPE_COMPLEXOBJECTCOMP, 2.6

OCI_DTYPE_DATE, 2.6

OCI_DTYPE_FILE, 2.6

OCI_DTYPE_INTERVAL_DS, 2.6

OCI_DTYPE_INTERVAL_YM, 2.6

OCI_DTYPE_LOB, 2.6

OCI_DTYPE_PARAM, 2.6, 15.1.10, 15.1.10

when used, 15.1.10

OCI_DTYPE_ROWID, 2.6

OCI_DTYPE_SNAP, 2.6

OCI_DTYPE_SRVDN, 2.6

OCI_DTYPE_TIMESTAMP, 2.6

OCI_DTYPE_TIMESTAMP_LTZ, 2.6

OCI_DTYPE_TIMESTAMP_TZ, 2.6

OCI_DURATION_SESSION, 13.1.4.1, 16.1.10, 19.1.9, 20.1.6, 20.1.6, 20.1.6, 20.1.6

OCI_DURATION_STATEMENT, 16.1.10, 19.1.9, 20.1.6, 20.1.6, 20.1.6, 20.1.6

OCI_DURATION_TRANS, 13.1.4.1

OCI_DYNAMIC_FETCH, 15.1.10

OCI_ERROR, 2.11, 8.2.2.7

OCI_EVENTS

mode for receiving notifications, 9.11.1.1

OCI_EXT_CRED, 8.4.1.1

OCI_HTYPE_ADMIN, 2.5

OCI_HTYPE_AUTHINFO, 2.5, 9.4.4.2

OCI_HTYPE_BIND, 2.5

OCI_HTYPE_COMPLEXOBJECT, 2.5

OCI_HTYPE_COR, 15.1.10

OCI_HTYPE_CPOOL, 2.5, 9.3.2.1

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.1.10, 15.1.10

OCI_HTYPE_SUBSCRIPTION, 2.5

OCI_HTYPE_SVCCTX, 2.5

OCI_HTYPE_TRANS, 2.5

OCI_IND_NULL, 10.3.14, 15.1.10, 20.1.6

OCI_INVALID_HANDLE, 2.11

OCI_LOCK_NONE, 13.1.7.1

OCI_LOCK_X, 13.1.7.1

OCI_LOCK_X_NOWAIT, 13.1.7.1, 13.1.7.3

parameter usage, 13.1.7.3

OCI_LOGON2_STMTCACHE, 9.6.2

OCI_LTYPE_ARG_FUNC list attribute, 6.2.12

OCI_LTYPE_ARG_PROC list attribute, 6.2.12

OCI_LTYPE_DB_SCH list attribute, 6.2.12

OCI_LTYPE_SCH_OBJ list attribute, 6.2.12

OCI_LTYPE_SUBPRG list attribute, 6.2.12

OCI_LTYPE_TYPE_ARG_FUNC list attribute, 6.2.12

OCI_LTYPE_TYPE_ARG_PROC list attribute, 6.2.12

OCI_LTYPE_TYPE_ATTR list attribute, 6.2.12

OCI_LTYPE_TYPE_METHOD list attribute, 6.2.12

OCI_MAJOR_VERSION, client library version, 16.1.10

OCI_MIGRATE, 8.3.1

OCI_MINOR_VERSION, client library version, 16.1.10

OCI_NCHAR_LITERAL_REPLACE_OFF, 15.1.10, 15.1.10

OCI_NCHAR_LITERAL_REPLACE_ON, 15.1.10, 15.1.10

OCI_NEED_DATA, 2.11

OCI_NEW_LENGTH_SEMANTICS, 15.1.10

OCI_NLS_MAXBUFSZ, 21.1.7

OCI_NO_DATA, 2.11

OCI_NO_MUTEX, 9.1.3, 15.1.10, 15.1.10

OCI_PIN_ANY, 13.1.4.1

OCI_PIN_LATEST, 13.1.4.1

OCI_PIN_RECENT, 13.1.4.1

OCI_PTYPE_ARG

attributes, 6.2.11

OCI_PTYPE_COL

attributes, 6.2.10

OCI_PTYPE_COLL

attributes, 6.2.7

OCI_PTYPE_DATABASE

attributes, 6.2.14

OCI_PTYPE_EVALUATION CONTEXT

attributes, 6.2.17

OCI_PTYPE_FUNC

attributes, 6.2.2

OCI_PTYPE_LIST

attributes, 6.2.12

OCI_PTYPE_NAME_VALUE

attributes, 6.2.20

OCI_PTYPE_PKG

attributes, 6.2.3

OCI_PTYPE_PROC

attributes, 6.2.2

OCI_PTYPE_RULE_SET

attributes, 6.2.16

OCI_PTYPE_RULES

attributes, 6.2.15

OCI_PTYPE_SCHEMA

attributes, 6.2.13

OCI_PTYPE_SYN

attributes, 6.2.8

OCI_PTYPE_TABLE

attributes, 6.2.1

OCI_PTYPE_TABLE_ALIAS

attributes, 6.2.18

OCI_PTYPE_TYPE

attributes, 6.2.4

OCI_PTYPE_TYPE_ATTR

attributes, 6.2.5

OCI_PTYPE_TYPE_FUNC

attributes, 6.2.6

OCI_PTYPE_TYPE_PROC

attributes, 6.2.6

OCI_PTYPE_VARIABLE_TYPE

attributes, 6.2.19

OCI_PTYPE_VIEW

attributes, 6.2.1

OCI_SESSGET_STMTCACHE, 9.6.2

OCI_SESSRLS_RETAG, 15.1.10, 15.1.10

OCI_STILL_EXECUTING, 2.11, 2.12.7

OCI_STMT_SCROLLABLE_READONLY

attribute, 4.8

OCI_SUBSCR_NAMESPACE_ANONYMOUS, A.18

OCI_SUBSCR_NAMESPACE_AQ, A.18

OCI_SUBSCR_NAMESPACE_DBCHANGE, A.18

OCI_SUBSCR_PROTO_HTTP, A.18

OCI_SUBSCR_PROTO_MAIL, A.18

OCI_SUBSCR_PROTO_OCI, A.18

OCI_SUBSCR_PROTO_SERVER, A.18

OCI_SUBSCR_QOS_PURGE_ON_NTFN, 9.11.1.4

OCI_SUBSCR_QOS_RELIABLE, 9.11.1.4

OCI_SUCCESS, 2.11, 8.2.2.7

OCI_SUCCESS_WITH_INFO, 2.11

OCI_THREADED, 9.1.3

OCI_TRANS_LOOSE, 8.2.2.3

OCI_TRANS_READONLY, 8.2.1.1, 8.2.4.3

OCI_TRANS_READWRITE, 8.2.1.1

OCI_TRANS_RESUME, 8.2.4.2

OCI_TRANS_SERIALIZABLE, 8.2.1.1

OCI_TRANS_TIGHT, 8.2.2.3

OCI_TRANS_TWOPHASE, 8.2.4.2

OCI_TYPECODE

values, 3.5, 3.5, 3.5.1

OCI_TYPECODE_NCHAR, 11.13.3, 11.13.3

OCI_UTF16ID, 2.14.1

OCIAnyDataAccess(), 20.1.6

OCIAnyDataAttrGet(), 20.1.6

OCIAnyDataAttrSet(), 20.1.6

OCIAnyDataBeginCreate(), 20.1.6

OCIAnyDataCollAddElem(), 20.1.6

OCIAnyDataCollGetElem(), 20.1.6

OCIAnyDataConvert(), 20.1.6

OCIAnyDataDestroy(), 20.1.6

OCIAnyDataEndCreate(), 20.1.6

OCIAnyDataGetCurrAttrNum(), 20.1.6

OCIAnyDataGetType(), 20.1.6

OCIAnyDataIsNull(), 20.1.6

OCIAnyDataSetAddInstance(), 20.1.6

OCIAnyDataSetBeginCreate(), 20.1.6

OCIAnyDataSetDestroy(), 20.1.6

OCIAnyDataSetEndCreate(), 20.1.6

OCIAnyDataSetGetCount(), 20.1.6

OCIAnyDataSetGetInstance(), 20.1.6

OCIAnyDataSetGetType(), 20.1.6

OCIAnyDataTypeCodeToSqlt(), 11.13.3, 20.1.6

OCIAppCtxClearAll(), 8.6.2, 15.1.10

OCIAppCtxSet(), 8.6.1, 15.1.10

OCIAQAgent

descriptor attributes, A.17.4

OCIAQDeq(), 16.1.10

OCIAQDeqArray(), 16.1.10

OCIAQDeqOptions

descriptor attributes, A.17.2

OCIAQEnq(), 16.1.10

OCIAQEnqArray(), 16.1.10

OCIAQEnqOptions

descriptor attributes, A.17.1

OCIAQListen(), 16.1.10

OCIAQListen2(), 16.1.10

OCIAQMsgProperties

descriptor attributes, A.17.3

OCIArray, 11.9

binding and defining, 11.9, 11.16

OCIArray manipulation

code example, 11.9.4

OCIAttrGet(), 15.1.10

used for describing, 4.5.1

OCIAttrSet(), 15.1.10

OCIAuthInfo definition, 9.4.4.2

OCIAuthInfo handle attributes, A.5.2

OCIBindArrayOfStruct(), 15.1.10

OCIBindByName(), 15.1.10

OCIBindByPos(), 15.1.10

OCIBindDynamic(), 15.1.10

OCIBindObject(), 15.1.10

OCIBreak(), 16.1.10

use of, 2.12.4, 2.12.9

OCICacheFlush(), 17.1.12

OCICacheFree(), 17.1.12

OCICacheRefresh(), 17.1.12

OCICacheUnmark(), 17.1.12

OCICacheUnpin(), 17.1.12

OCICharSetConversionIsReplacementUsed(), 21.1.7

OCICharSetToUnicode(), 21.1.7

OCIClientVersion(), 16.1.10

OCIColl, 11.9

binding and defining, 11.9

OCICollAppend(), 18.1.11

OCICollAssign(), 18.1.11

OCICollAssignElem(), 18.1.11

OCICollGetElem(), 18.1.11

OCICollGetElemArray(), 18.1.11

OCICollIsLocator(), 18.1.11

OCICollMax(), 18.1.11

OCICollSize(), 18.1.11

OCICollTrim(), 18.1.11

OCIComplexObject

use of, 10.3.10.2

OCIComplexObjectComp

use of, 10.3.10.2

OCIConnectionPoolCreate(), 15.1.10

OCIConnectionPoolDestroy(), 15.1.10

OCIContextClearValue(), 19.1.9

OCIContextGenerateKey(), 19.1.9

OCIContextGetValue(), 19.1.9

OCIContextSetValue(), 19.1.9

OCIDate, 11.4

binding and defining, 11.4, 11.16

OCIDate manipulation

code example, 11.4.1

OCIDateAddDays(), 18.1.11

OCIDateAddMonths(), 18.1.11

OCIDateAssign(), 18.1.11

OCIDateCheck(), 18.1.11

OCIDateCompare(), 18.1.11

OCIDateDaysBetween(), 18.1.11

OCIDateFromText(), 18.1.11

OCIDateGetDate(), 18.1.11

OCIDateGetTime(), 18.1.11

OCIDateLastDay(), 18.1.11

OCIDateNextDay(), 18.1.11

OCIDateSetDate(), 18.1.11

OCIDateSetTime(), 18.1.11

OCIDateSysDate(), 18.1.11

OCIDateTimeAssign(), 18.1.11

OCIDateTimeCheck(), 18.1.11

OCIDateTimeCompare(), 18.1.11

OCIDateTimeConstruct(), 18.1.11

OCIDateTimeConvert(), 18.1.11

OCIDateTimeFromArray(), 18.1.11

OCIDateTimeFromText(), 18.1.11

OCIDateTimeGetDate(), 18.1.11

OCIDateTimeGetTime(), 18.1.11

OCIDateTimeGetTimeZoneName(), 18.1.11

OCIDateTimeGetTimeZoneOffset(), 18.1.11

OCIDateTimeIntervalAdd(), 18.1.11

OCIDateTimeIntervalSub(), 18.1.11

OCIDateTimeSubtract(), 18.1.11

OCIDateTimeSysTimeStamp(), 18.1.11

OCIDateTimeToArray(), 18.1.11

OCIDateToText(), 18.1.11

OCIDateZoneToZone(), 18.1.11

OCIDBShutdown(), 15.1.10

OCIDBStartup(), 15.1.10

OCIDefineArrayOfStruct(), 15.1.10

OCIDefineByPos(), 15.1.10

OCIDefineDynamic(), 15.1.10

OCIDefineObject(), 15.1.10

OCIDescribeAny(), 15.1.10

usage examples, 6.4

using, 6.1

OCIDescriptorAlloc(), 15.1.10

OCIDescriptorFree(), 15.1.10

OCIDirPathAbort(), 16.1.10

OCIDirPathColArray context, 12.1.2.1

OCIDirPathColArrayEntryGet(), 16.1.10

OCIDirPathColArrayEntrySet(), 16.1.10

OCIDirPathColArrayReset(), 16.1.10

OCIDirPathColArrayRowGet(), 16.1.10

OCIDirPathColArrayToStream(), 16.1.10

OCIDirPathCtx context, 12.1.2.1

OCIDirPathDataSave(), 16.1.10

OCIDirPathFinish(), 16.1.10

OCIDirPathFlushRow(), 16.1.10

OCIDirPathPrepare(), 16.1.10

OCIDirPathStream context, 12.1.2.1

OCIDirPathStreamLoad(), 16.1.10

OCIDirPathStreamReset(), 16.1.10

OCIDuration

use of, 13.1.4.1, 13.1.9

OCIDurationBegin(), 16.1.10, 19.1.9

OCIDurationEnd(), 16.1.10, 19.1.9

OCIEnvCreate(), 15.1.10

OCIEnvInit(), 15.1.10

OCIEnvNlsCreate(), 2.14.1, 5.7.2, 15.1.10

OCIErrorGet(), 16.1.10

OCIEvent handle, 9.9.1

OCIEventCallback datatype, 9.9.4

OCIExtProcAllocCallMemory(), 19.1.9

OCIExtProcGetEnv(), 19.1.9

OCIExtProcRaiseExcp(), 19.1.9

OCIExtProcRaiseExcpWithMsg(), 19.1.9

OCIExtractFromFile(), 19.1.9, 19.1.9, 19.1.9

OCIExtractFromList(), 19.1.9

OCIExtractFromStr(), 19.1.9

OCIExtractInit(), 19.1.9

OCIExtractReset(), 19.1.9

OCIExtractSetKey(), 19.1.9

OCIExtractSetNumKeys(), 19.1.9

OCIExtractTerm(), 19.1.9

OCIExtractToBool(), 19.1.9

OCIExtractToInt(), 19.1.9

OCIExtractToList(), 19.1.9

OCIExtractToOCINum(), 19.1.9

OCIFileClose(), 19.1.9

OCIFileExists(), 19.1.9

OCIFileInit(), 19.1.9

OCIFileRead(), 19.1.9

OCIFileSeek(), 19.1.9

OCIFileTerm(), 19.1.9

OCIFileWrite(), 19.1.9

OCIFormatInit(), 19.1.9

OCIFormatString(), 19.1.9

OCIFormatTerm(), 19.1.9

OCIHandleAlloc(), 15.1.10

OCIHandleFree(), 15.1.10

OCIInd

use of, 10.3.14

OCIInitialize(), 15.1.10

OCIIntervalAssign(), 18.1.11

OCIIntervalCheck(), 18.1.11

OCIIntervalCompare(), 18.1.11

OCIIntervalDivide(), 18.1.11

OCIIntervalFromNumber(), 18.1.11

OCIIntervalFromText(), 18.1.11

OCIIntervalFromTZ(), 18.1.11

OCIIntervalGetDaySecond(), 18.1.11

OCIIntervalGetYearMonth(), 18.1.11

OCIIntervalMultiply(), 18.1.11

OCIIntervalSetDaySecond(), 18.1.11

OCIIntervalSetYearMonth(), 18.1.11

OCIIntervalToText(), 18.1.11

OCIIter, 11.9

binding and defining, 11.9

usage example, 11.9.4

OCIIterCreate(), 18.1.11

OCIIterDelete(), 18.1.11

OCIIterGetCurrent(), 18.1.11

OCIIterInit(), 18.1.11

OCIIterNext(), 18.1.11

OCIIterPrev(), 18.1.11

OCILdaToSvcCtx(), 16.1.10

oci.lib, D.5

OCILobAppend(), 16.1.10

OCILobArrayRead(), 16.1.10

OCILobArrayWrite(), 16.1.10

OCILobAssign(), 16.1.10

OCILobCharSet(), 16.1.10, 16.1.10

OCILobClose(), 16.1.10

OCILobCopy(), 16.1.10

OCILobCopy2(), 16.1.10

OCILobCreateTemporary(), 16.1.10

OCILobDisableBuffering(), 16.1.10

OCILobEnableBuffering(), 16.1.10

OCILobErase(), 16.1.10

OCILobErase2(), 16.1.10

OCILobFileClose(), 16.1.10

OCILobFileCloseAll(), 16.1.10

OCILobFileExists(), 16.1.10

OCILobFileGetName(), 16.1.10

OCILobFileIsOpen(), 16.1.10

OCILobFileOpen(), 16.1.10

OCILobFileSetName(), 16.1.10

OCILobFlushBuffer(), 16.1.10

OCILobFreeTemporary(), 16.1.10

OCILobGetChunkSize(), 7.6, 16.1.10

OCILobGetLength(), 16.1.10

OCILobGetLength2(), 16.1.10

OCILobGetStorageLimit(), 16.1.10

OCILobIsEqual(), 16.1.10

OCILobIsOpen(), 16.1.10

OCILobIsTemporary(), 16.1.10

OCILobLoadFromFile(), 16.1.10

OCILobLoadFromFile2(), 16.1.10

OCILobLocatorAssign(), 16.1.10

OCILobLocatorIsInit(), 16.1.10

OCILobOpen(), 16.1.10

OCILobRead(), 16.1.10

OCILobRead2(), 16.1.10

OCILobTrim(), 16.1.10

OCILobTrim2(), 16.1.10

OCILobWrite(), 16.1.10

OCILobWrite2(), 16.1.10

OCILobWriteAppend(), 16.1.10

OCILobWriteAppend2(), 16.1.10

OCILockOpt

possible values, 17.1.12, 17.1.12

OCILogoff(), 15.1.10

OCILogon(), 15.1.10

using, 2.8.3.1

OCILogon2(), 15.1.10

OCIMemoryAlloc(), 19.1.9

OCIMemoryFree(), 19.1.9

OCIMemoryResize(), 19.1.9

OCIMessageClose(), 21.1.7

OCIMessageGet(), 21.1.7

OCIMessageOpen(), 21.1.7

OCIMultiByteInSizeToWideChar(), 21.1.7

OCIMultiByteStrCaseConversion(), 21.1.7

OCIMultiByteStrcat(), 21.1.7

OCIMultiByteStrcmp(), 21.1.7

OCIMultiByteStrcpy(), 21.1.7

OCIMultiByteStrlen(), 21.1.7

OCIMultiByteStrncat(), 21.1.7

OCIMultiByteStrncmp(), 21.1.7

OCIMultiByteStrncpy(), 21.1.7

OCIMultiByteStrnDisplayLength(), 21.1.7

OCIMultiByteToWideChar(), 21.1.7

OCIMultiTransPrepare(), 16.1.10

OCINlsCharSetConvert(), 21.1.7

OCINlsCharSetIdToName(), 21.1.7, 21.1.7, 21.1.7, 21.1.7, 21.1.7

OCINlsCharSetNameTold(), 21.1.7

OCINlsEnvironmentVariableGet(), 2.14.1, 5.7.2, 21.1.7

OCINlsGetInfo(), 2.14.3, 21.1.7

OCINlsNameMap(), 21.1.7

OCINlsNumericInfoGet(), 21.1.7

OCINumber, 11.6

bind example, 11.16.1

binding and defining, 11.6, 11.16

code examples, 11.6.1

define example, 11.16.1

OCINumberAbs(), 18.1.11

OCINumberAdd(), 18.1.11

OCINumberArcCos(), 18.1.11

OCINumberArcSin(), 18.1.11

OCINumberArcTan(), 18.1.11

OCINumberArcTan2(), 18.1.11

OCINumberAssign(), 18.1.11

OCINumberCeil(), 18.1.11

OCINumberCompare(), 18.1.11

OCINumberCos(), 18.1.11

OCINumberDec(), 18.1.11

OCINumberDiv(), 18.1.11

OCINumberExp(), 18.1.11

OCINumberFloor(), 18.1.11

OCINumberFromInt(), 18.1.11

OCINumberFromReal(), 18.1.11

OCINumberFromText(), 18.1.11

OCINumberHypCos(), 18.1.11

OCINumberHypSin(), 18.1.11

OCINumberHypTan(), 18.1.11

OCINumberInc(), 18.1.11

OCINumberIntPower(), 18.1.11

OCINumberIsInt(), 18.1.11

OCINumberIsZero(), 18.1.11

OCINumberLn(), 18.1.11

OCINumberLog(), 18.1.11

OCINumberMod(), 18.1.11

OCINumberMul(), 18.1.11

OCINumberNeg(), 18.1.11

OCINumberPower(), 18.1.11

OCINumberPrec(), 18.1.11

OCINumberRound(), 18.1.11

OCINumberSetPi(), 18.1.11

OCINumberSetZero(), 18.1.11

OCINumberShift(), 18.1.11

OCINumberSign(), 18.1.11

OCINumberSin(), 18.1.11

OCINumberSqrt(), 18.1.11

OCINumberSub(), 18.1.11

OCINumberTan(), 18.1.11

OCINumberToInt(), 18.1.11

OCINumberToReal(), 18.1.11

OCINumberToRealArray(), 18.1.11

OCINumberToText(), 18.1.11

OCINumberTrunc(), 18.1.11

OCIObjectArrayPin(), 17.1.12

OCIObjectCopy(), 17.1.12

OCIObjectExists(), 17.1.12

OCIObjectFlush(), 17.1.12

OCIObjectFree(), 17.1.12

OCIObjectGetAttr(), 17.1.12

OCIObjectGetInd(), 17.1.12

example of use, 10.3.14

OCIObjectGetObjectRef(), 17.1.12

OCIObjectGetTypeRef(), 17.1.12

OCIObjectIsDirty(), 17.1.12

OCIObjectIsLocked(), 17.1.12

OCIObjectLifetime

possible values, 17.1.12

OCIObjectLock(), 17.1.12

OCIObjectLockNoWait(), 17.1.12

OCIObjectMarkDelete(), 17.1.12

OCIObjectMarkDeleteByRef(), 17.1.12

OCIObjectMarkStatus

possible values, 17.1.12

OCIObjectMarkUpdate(), 17.1.12

OCIObjectNew(), 17.1.12

OCIObjectPin(), 17.1.12

OCIObjectPinCountReset(), 17.1.12

OCIObjectPinTable(), 17.1.12

OCIObjectRefresh(), 17.1.12

OCIObjectSetAttr(), 17.1.12

OCIObjectUnmark(), 17.1.12

OCIObjectUnmarkByRef(), 17.1.12

OCIObjectUnpin(), 17.1.12

OCIParamGet(), 15.1.10

used for describing, 4.5.1

OCIParamSet(), 15.1.10

OCIPasswordChange(), 16.1.10

OCIPing(), 16.1.10

OCIPinOpt

use of, 13.1.4.1

OCIRaw, 11.8

binding and defining, 11.8, 11.16

OCIRaw manipulation

code example, 11.8.2

OCIRawAllocSize(), 18.1.11

OCIRawAssignBytes(), 18.1.11

OCIRawAssignRaw(), 18.1.11

OCIRawPtr(), 18.1.11

OCIRawResize(), 18.1.11

OCIRawSize(), 18.1.11

OCIRef, 11.11

binding and defining, 11.11

usage example, 11.11.2

OCIRefAssign(), 18.1.11

OCIRefClear(), 18.1.11

OCIRefFromHex(), 18.1.11

OCIRefHexSize(), 18.1.11

OCIRefIsEqual(), 18.1.11

OCIRefIsNull(), 18.1.11

OCIRefToHex(), 18.1.11

OCIReset(), 16.1.10

use of, 2.12.9

OCIRowid ROWID descriptor, 2.6.4

OCIRowidToChar(), 16.1.10

OCIServerAttach(), 15.1.10

shadow processes, 15.1.10

OCIServerDetach(), 15.1.10

OCIServerDNs descriptor attributes, A.17.5

OCIServerVersion(), 16.1.10

OCISessionBegin(), 2.8.3.3, 2.14.6, 15.1.10

OCISessionEnd(), 15.1.10

OCISessionGet(), 15.1.10

OCISessionPoolCreate(), 15.1.10

OCISessionPoolDestroy(), 15.1.10

OCISessionRelease(), 15.1.10

OCIStmtExecute(), 16.1.10

prefetch during, 4.4

use of iters parameter, 4.4

OCIStmtFetch(), 16.1.10

OCIStmtFetch2(), 4.8, 16.1.10

OCIStmtGetBindInfo(), 15.1.10

OCIStmtGetPieceInfo(), 16.1.10

OCIStmtPrepare(), 16.1.10

preparing SQL statements, 4.2

OCIStmtPrepare2(), 16.1.10

OCIStmtRelease(), 16.1.10

OCIStmtSetPieceInfo(), 16.1.10

OCIString, 11.7

binding and defining, 11.7, 11.16

OCIString manipulation

code example, 11.7.2

OCIStringAllocSize(), 18.1.11

OCIStringAssign(), 18.1.11

OCIStringAssignText(), 18.1.11

OCIStringGetEncoding(), 18.1.11

OCIStringPtr(), 18.1.11

OCIStringResize(), 18.1.11

OCIStringSize(), 18.1.11

OCISubscriptionDisable(), 16.1.10

OCISubscriptionEnable(), 16.1.10

OCISubscriptionPost(), 16.1.10

OCISubscriptionRegister(), 16.1.10

OCISubscriptionUnRegister(), 16.1.10

OCISvcCtxToLda(), 16.1.10

OCITable, 11.9

binding and defining, 11.9, 11.16

OCITableDelete(), 18.1.11

OCITableExists(), 18.1.11

OCITableFirst(), 18.1.11

OCITableLast(), 18.1.11

OCITableNext(), 18.1.11

OCITablePrev(), 18.1.11

OCITableSize(), 18.1.11

OCITerminate(), 15.1.10

OCIThread package, 9.2

OCIThreadClose(), 16.1.10

OCIThreadCreate(), 16.1.10

OCIThreadHandleGet(), 16.1.10

OCIThreadHndDestroy(), 16.1.10

OCIThreadHndInit(), 16.1.10

OCIThreadIdDestroy(), 16.1.10

OCIThreadIdGet(), 16.1.10

OCIThreadIdInit(), 16.1.10

OCIThreadIdNull(), 16.1.10

OCIThreadIdSame(), 16.1.10

OCIThreadIdSet(), 16.1.10

OCIThreadIdSetNull(), 16.1.10

OCIThreadInit(), 16.1.10

OCIThreadIsMulti(), 16.1.10

OCIThreadJoin(), 16.1.10

OCIThreadKeyDestroy(), 16.1.10

OCIThreadKeyGet(), 16.1.10

OCIThreadKeyInit(), 16.1.10

OCIThreadKeySet(), 16.1.10

OCIThreadMutexAcquire(), 16.1.10

OCIThreadMutexDestroy(), 16.1.10

OCIThreadMutexInit(), 16.1.10

OCIThreadMutexRelease(), 16.1.10

OCIThreadProcessInit(), 16.1.10

OCIThreadTerm(), 16.1.10

OCITransCommit(), 16.1.10

OCITransDetach(), 16.1.10

OCITransForget(), 16.1.10

OCITransMultiPrepare(), 8.2.2.8

OCITransPrepare(), 16.1.10

OCITransRollback(), 16.1.10

OCITransStart(), 16.1.10

OCIType

description, 11.12.1

OCITypeAddAttr(), 20.1.6

OCITypeArrayByName(), 17.1.12

OCITypeArrayByRef(), 17.1.12

OCITypeBeginCreate(), 20.1.6

OCITypeByName(), 17.1.12

OCITypeByRef(), 17.1.12

OCITypeElem

description, 11.12.1

OCITypeEndCreate(), 20.1.6

OCITypeMethod

description, 11.12.1

OCITypeSetBuiltin(), 20.1.6

OCITypeSetCollection(), 20.1.6

OCIUnicodeToCharSet(), 21.1.7

OCIUserCallbackGet(), 16.1.10

OCIUserCallbackRegister(), 16.1.10

OCIWchar datatype, 2.14.9

OCIWideCharInSizeToMultiByte(), 21.1.7

OCIWideCharIsAlnum(), 21.1.7

OCIWideCharIsAlpha(), 21.1.7

OCIWideCharIsCntrl(), 21.1.7

OCIWideCharIsDigit(), 21.1.7

OCIWideCharIsGraph(), 21.1.7

OCIWideCharIsLower(), 21.1.7

OCIWideCharIsPrint(), 21.1.7

OCIWideCharIsPunct(), 21.1.7

OCIWideCharIsSingleByte(), 21.1.7

OCIWideCharIsSpace(), 21.1.7

OCIWideCharIsUpper(), 21.1.7

OCIWideCharIsXdigit(), 21.1.7

OCIWideCharMultiByteLength(), 21.1.7

OCIWideCharStrCaseConversion(), 21.1.7

OCIWideCharStrcat(), 21.1.7

OCIWideCharStrchr(), 21.1.7

OCIWideCharStrcmp(), 21.1.7

OCIWideCharStrcpy(), 21.1.7

OCIWideCharStrlen(), 21.1.7

OCIWideCharStrncat(), 21.1.7

OCIWideCharStrncmp(), 21.1.7

OCIWideCharStrncpy(), 21.1.7

OCIWideCharStrrchr(), 21.1.7

OCIWideCharToLower(), 21.1.7

OCIWideCharToMultiByte(), 21.1.7

OCIWideCharToUpper(), 21.1.7

OCIXmlDbFreeXmlCtx(), 13.5.3, 22.1.6

ocixmldb.h header file, 13.5.3

OCIXmlDbInitXmlCtx(), 13.5.3, 22.1.6

OID. See object identifier

opaque, definition of, 1.1

optimistic locking

implementing, 13.1.7.4

ORA_NCHAR_LITERAL_REPLACE, 15.1.10

ORA-25219 error during enqueue, 9.10.3

Oracle Call Interface. See OCI

Oracle datatypes, 3.1

mapping to C, 11.2

Oracle XA Library

additional documentation, D.7.3

compiling and linking an OCI program, D.7.1

dynamic registration, D.7.2

Oracle9i database

transaction processing monitor, D.7

orasb8 datatype, 7.6

oratypes.h

contents, 3.6

only supported means of supplying parameters to the OCI, 3.6

oraub8 datatype, 7.6

ORE. See object runtime environment

OTT

command line, 14.3

command line syntax, 14.8.1

creating types in the database, 14.2.1

datatypes mapping, 14.5

intype file, 14.8.4

outtype file, 14.6

overview, 14.1

parameters, 14.8.2

providing an intype file, 14.4

reference, 14.8

restriction, 14.8.8

using, 14, 14.2

OTT (Object Type Translator), D.8

OTT initialization function

calling, 14.7.2

tasks of, 14.7.3

OTT parameter TRANSITIVE, 14.8.2.12

OTT parameter URL, 14.8.2.13

OTT parameters

CASE, 14.8.2.10

CODE, 14.8.2.4

CONFIG, 14.8.2.8

ERRTYPE, 14.8.2.9

HFILE, 14.8.2.7

INITFILE, 14.8.2.5

INITFUNC, 14.8.2.6

INTYPE, 14.8.2.2

OUTTYPE, 14.8.2.3

SCHEMA_NAMES, 14.8.2.11

USERID, 14.8.2.1

where they appear, 14.8.3

OTT. See object type translator

ottcfg.cfg, D.2

outtype file, 14.8.4

when running OTT, 14.6

OUTTYPE OTT parameter, 14.8.2.3

P

packages

attributes, 6.2.3

describing, 6.1

parameter descriptor, 2.6.3

attributes, 6.2, A.14

parameter descriptor object, 11.12.1

parameters

attributes, 6.2

buffer lengths, 15.1.9, 16.1.9

modes, 15.1.4, 16.1.4

passing strings, 2.12.1.3

string length, 15.1.9, 16.1.9

password management, 8.3, 8.3.2

persistent objects, 10.2.2.1

meta-attributes, 10.3.9.1

piecewise binds and defines for LOBs, 5.9.6

piecewise fetch, 5.9.5

piecewise operations, 5.9.3

fetch, 5.9, 5.9.5.1

in PL/SQL, 5.9.4

insert, 5.9

update, 5.9

valid datatypes, 5.9.1

pin count, 10.3.13

pin duration

example, 13.1.9.1

of objects, 13.1.9

pinning, 13.1.4.1

pinning objects, 13.1.4.1

PL/SQL, 1.1.6.5

binding and defining nested tables, 5.8

binding and defining REF CURSORS, 5.8

binding placeholders, 2.13

defining output variables, 5.4.2

piecewise operations, 5.9.4

uses in OCI applications, 2.13

using in OCI applications, 2.13

using in OCI programs, 5.1.5

positioned, 2.12.5

deletes, 2.12.5

prefetching

during OCIStmtExecute(), 4.4

setting prefetch memory size, 4.7.2

setting row count, 4.7.2

prepare multiple branches in a single message, 8.2.2.8

procedures

attributes, 6.2.2

process

handle attributes, A.20

proxy access, 2.8.3.2

proxy authentication, 2.8.3.2, 8.4.1.7, 8.4.1.7

publish-subscribe

_SYSTEM_TRIG_ENABLED parameter, 9.11.4

COMPATIBLE parameter, 9.11.1.1

example, 9.11.4

functions, 9.11.1

handle attributes, 9.11.1.1, A.18

LDAP registration, 9.11.1.3

notification callback, 9.11.2

subscription handle, 9.11.1.1

publish-subscribe functions, 16.1.10

Q

query

explicit describe, 4.5.2

query. See SQL query

R

RAW

external datatype, 3.3.10

REF

external datatype, 3.3.19

REF columns

direct path loading of, 12.2.4

REF CURSOR variables

binding and defining, 5.8

reference. See REFs

refreshing, 13.1.6.2

objects, 13.1.6.2

REFs

binding, 11.14.2

CURSORvariables, binding, 5.2.3

defining, 11.15.2

indicator variables for, 2.12.2, 2.12.3.3

retrieving from server, 10.3.4

registering

user callbacks, 9.7.1

registry

REGEDT32, D.7.2.3

relational functions, C.8

server round trips, C.2

re-linking, need for, 1.2.2

required support files, D.1

reserved namespaces, 2.12.6.1

reserved words, 2.12.6

result set, 4.8

resuming branches, 8.2.2.5

return values

navigational functions, 17.1.10

RETURNING clause

binding with, 5.6.2

error handling, 5.6.3

initializing variables, 5.6.2

using with OCI, 5.6

with REFs, 5.6.4

rollback, 2.9

in object applications, 13.1.8

ROWID

external datatype, 3.3.20

logical, 3.2.3

Universal ROWID, 3.2.3

used for positioned updates and deletes, 2.12.5

ROWID descriptor, 2.6.4

RSFs, D.1

running OCI applications, D.6

S

sample programs, B, D.3

samples directory, D.2

sb1

definition, 3.6

sb2

definition, 3.6

sb4

definition, 3.6

SCHEMA_NAMES OTT parameter, 14.8.2.11

usage, 14.8.6

SCHEMA.QUEUE, 16.1.10

SCHEMA.QUEUE:CONSUMER_NAME, 16.1.10

schemas

attributes, 6.2.13, 6.2.15, 6.2.16, 6.2.17, 6.2.18, 6.2.19, 6.2.20

describing, 6.1

scripts, authenticating users in, 8.3.3

scrollable cursor

example, 4.8.2

scrollable cursors, 4.8

SDK for Instant Client Light, 1.3.9

secondary memory

of object, 13.1.10

select-list

describing, 4.5

sequences

attributes, 6.2.9

describing, 6.1

server handle

attributes, A.5

description, 2.5.4

setting in service context, 2.5.4

server round trips

cache functions, C.4

datatype mapping and manipulation functions, C.6

describe operation, C.5

LOB functions, C.3

object functions, C.4

relational functions, C.8

servers compatibility, 1.2

service context handle

attributes, A.4

description, 2.5.4

elements of, 2.5.4

session

migration, 8.3.1, 15.1.10

session creation, 2.8.3

session management, 8.3, 8.3.4

session pool handle

attributes, A.8

session pooling, 9.4, 9.5

tagging, 9.4

session pooling example, 9.4.7

session pooling, functionality, 9.4.1

shutdown database, 9.13

signal handler, 9.1

skip parameters

for arrays of structures, 5.5.1

for standard arrays, 5.5.1.1

snapshot descriptor, 2.6.1

snapshots

executing against, 4.4.1

SQL query

binding placeholders. See bind operation

defining output variables, 4.6, 5.3, 11.15

defining output variables. See define operation

fetching results, 4.7

statement type, 1.1.6.4

SQL statements, 1.1.6

binding placeholders in, 4.3, 5.1, 11.14

determining type prepared, 4.2

executing, 4.4

preparing for execution, 4.2

processing, 4.1

types

control statements, 1.1.6.2

data definition language, 1.1.6.1

data manipulation language, 1.1.6.3

embedded SQL, 1.1.6.6

PL/SQL, 1.1.6.5

queries, 1.1.6.4

SQLCS_IMPLICIT, 5.7.1.1, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10

SQLCS_NCHAR, 5.7.1.1, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10, 16.1.10

SQLT typecodes, 3.5.1

SQLT_BDOUBLE, 3.3.23

SQLT_BFLOAT, 3.3.23

SQLT_IBDOUBLE, 3.2.4, 6.2.10

SQLT_IBFLOAT, 3.2.4, 6.2.10

SQLT_NTY

bind example, 11.17.1

define example, 11.17.2

description, 3.3.18

preallocating object memory, 11.15.3

SQLT_REF

definition, 3.3.19

description, 3.3.19

startup database, 9.13

stateful sessions, 9.3.1.2

stateless sessions, 9.3.1.2

statement caching, 9.6

code example, 9.6.4

statement handle

attributes, A.10

description, 2.5.5

statically-linked applications, 1.2.2

stored functions

describing, 6.1

stored procedures

describing, 6.1

Streams Advanced Queuing

dequeue function, 16.1.10

description, 9.10

enqueue function, 16.1.10

functions, 16.1.10

OCI and, 9.10

OCI descriptors for, 9.10.2

OCI functions for, 9.10.1

OCI versus PL/SQL, 9.10.3

STRING

external datatype, 3.3.5

strings

passing as parameters, 2.12.1.3

structures

arrays of, 5.5

subscription handle, 2.5.9

attributes, A.18

Supporting UTF-16 Unicode in the OCI, 2.14.1, 2.14.2, 2.14.6, 2.14.9, 2.14.11, 2.14.12

supporting UTF-16 Unicode in the OCI, 2.14.6

sword

definition, 3.6

synonyms

attributes, 6.2.8

describing, 6.1

T

tables

attributes, 6.2.1

describing, 6.1

limitations on OCIDescribe() and OCIStmtExecute(), 6.1.1

TAF callbacks, 9.8

TAF in connection pools, 9.3.1.4

TAF-enabled connections, 9.9.7

tagging

custom pooling, 9.9.5

session pooling, 9.4, 15.1.10, 15.1.10

TDO

definition, 11.14.1

description, 11.12.1

in the object cache, 13.4

obtaining, 11.12.1

terminology

navigational functions, 17.1.2

used in this manual, 1.1.6.7

thread management functions, 16.1.10

thread safety, 9.1

advantages of, 9.1.1

and three-tier architectures, 9.1.2

basic concepts, 9.1

implementing with OCI, 9.1.3

mixing 7.x and 8.0 calls, 9.1.3.1

required OCI calls, 9.1.3

threads package, 9.2

three-tier architectures

and thread safety, 9.1.2

TIMESTAMP datatype, 3.3.22.2

TIMESTAMP WITH LOCAL TIME ZONEdatatype, 3.3.22.4

TIMESTAMP WITH TIME ZONEdatatype, 3.3.22.3

TNS_ADMIN, 1.3.6

tnsnames.ora file, 1.3.2

top-level memory

of object, 13.1.10

transaction handle

attributes, A.9

description, 2.5.4

transaction identifier, 8.2.2.1

transaction processing monitor

additional documentation, D.7.3

interacting with Oracle9i database, D.7

types, D.7

transactional complexity

levels in OCI, 8.2

transactions

committing, 2.9

functions, 16.1.10

global, 8.2.2

branch states, 8.2.2.4

branches, 8.2.2.3

one-phase commit, 8.2.2.7

transactions identifier, 8.2.2.1

two-phase commit, 8.2.2.7

global examples, 8.2.3

initialization parameters, 8.2.4

local, 8.2.1

OCI functions for

transactions, 8.1

read-only, 8.2.1.1

rolling back, 2.9

serializable, 8.2.1.1

transient objects, 10.2.2.2

LOBs

attributes, 7.4.2

meta-attributes, 10.3.9.3

TRANSITIVE OTT parameter, 14.4, 14.5.2, 14.8.2.12

Transparent Application Failover

callback registration, 9.8.3

OCI callbacks, 9.8

Transparent Application Failover in connection pools, 9.3.1.4

type attributes

attributes, 6.2.5

type descriptor object, 10.3.1, 11.12.1

type evolution, 10.5

object cache, 13.4

type functions

attributes, 6.2.6

type inheritance

OTT support, 14.5.4

type procedures

attributes, 6.2.6

type reference, 10.3.17

typecodes, 3.5

types

attributes, 6.2.4

describing, 6.1

U

ub1

definition, 3.6

ub2

definition, 3.6

ub4

definition, 3.6

Unicode

character set ID, A.12

character set Id, A.11, A.11

data buffer alignment, 2.14.12

OCILobRead(), 16.1.10

OCILobWrite(), 16.1.10, 16.1.10, 16.1.10

Universal ROWID, 3.2.3

unmarking, 13.1.5.2

objects, 13.1.5.2

unpinning, 10.3.13, 13.1.4.2

objects, 13.1.4.2

UNSIGNED

external datatype, 3.3.13

updates, 2.12.5

piecewise, 5.9, 5.9.3

positioned, 2.12.5

upgrading

7.x to 8.0, 1.2.5

7.x to 8.0 OCI, 1.2.6

upgrading OCI, 1.2

URL OTT parameter, 14.8.2.13

UROWID

Universal ROWID, 3.2.3

user memory

allocating, 2.6.8

user session handle

attributes, A.5.2

description, 2.5.4

setting in service context, 2.5.4

user-defined callback functions, 9.7

registering, 9.7.1

USERID OTT parameter, 14.8.2.1

utext

Unicode datatype, 5.7.2, 5.7.7.2

UTF-16 data, sample code, 5.7.7.2

V

values, 10.2.2

in object applications, 10.2.2.3

VARCHAR

external datatype, 3.3.8

VARCHAR2

external datatype, 3.3.1

VARNUM

external datatype, 3.3.6

VARRAW

external datatype, 3.3.11

VARRAY, 11.9

varray, 3.3.18

varray as object, 10.1

varray C mapping, 14.5.1

varray define calls, 11.15.1

varray iterator, 18.1.11

varray NULLs, 10.3.14

varray or collection Iterator example, 11.9.4

varray scan, 18.1.11

VARRAY, loading not supported, 12.1.4

views

attributes, 6.2.1

describing, 6.1

W

wchar_t datatype, 2.14.9, 5.7.7.2, 21.1.7

with_context

argument to external procedure functions, 19.1.9

X

XA Library

functions, D.7

overview, D.7

XA library support, 1.1.17

XA specification, 8.2.2.1

xa.h header, 1.1.17

XID. See transaction identifier

XML DB functions, 13.5.3

XML support in OCI, 13.5

xtramem_sz parameter

using, 2.6.8