79/79

Index

A  B  C  D  E  F  G  H  I  K  L  M  N  O  P  Q  R  S  T  U  V  W  X 

---

Numerics

64-bit integer support, 3.3.3

---

A

administration handle, 10.2

attributes, A.6

description, 10.2

ADR, 10.5

ADR base location, 10.5.1

ADR, controlling creation, 10.5.3

ADRCI command-line tool, 10.5.2

ADT

See object type

advanced queuing

agent descriptor, 2.3.1.13

dequeue options descriptor, 2.3.1.13

descriptor, 2.3.1.13.7

enqueue options descriptor, 2.3.1.13

listen options descriptor, 2.3.1.13

message properties descriptor, 2.3.1.13, 2.3.1.13

notification descriptor, 2.3.1.13

advantages

OCI, 1.1.1

allocation duration

example, 14.1.9.1

of objects, 14.1.9

ANSI DATE descriptor, 2.3.1.13

AnyData, 12.13

AnyDataSet, 12.13

AnyType, 12.13

application context, 8.6

application initialization, 2.4.1.3

AQ

See Oracle Streams Advanced Queuing.

argument attributes, 6.2.11

arrays

binds, 12.14.4

defines, 12.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, 11.3.14

attribute descriptor object, 12.12.1

attributes

administration handle, A.6

authentication information handle, A.5.2

bind handle, A.11

complex object retrieval (COR) descriptor, A.16.2

complex object retrieval (COR) handle, A.16.1

connection pool handle, A.7

continuous query notification, A.18.1

continuous query notification descriptor, A.18.2

define handle, A.12

description, A.12

describe handle, A.13

direct path loading

column array handle, A.19.3

column parameter, A.19.5

context handle, A.19.1

function context handle, A.19.2

handle, A.19

stream handle, A.19.4

environment handle, A.2

error handle, A.3

event handle, A.21

LOB locator, A.15

notification descriptor, A.18.3

OCIAQAgent descriptor, A.17.4

OCIAQDeqOptions descriptor, A.17.2

OCIAQEnqOptions descriptor, A.17.1

OCIAQMsgProperties descriptor, A.17.3

OCIServerDNs descriptor, A.17.5

of handles, 2.3.1.12

of objects, 11.3.9

of parameter descriptors, 6.2

of parameters, 6.2

parameter descriptor, A.14

process handle, A.20

server handle, A.5

service context handle, A.4

session pool handle, A.8

statement handle, A.10

subscription handle, A.18

transaction handle, A.9

user session handle, A.5.2

authentication

by Distinguished Name, 8.4.1.3

by X.509 Certificate, 8.4.1.4

management, 8.3.1

authentication information handle, 2.3.1

authorize functions, 16.1.10

Automatic Diagnostic Repository (ADR), 10.5

Automatic Workload Repository (AWR), 10.4.5

---

B

BASICFILE parameter, 7.10

batch error mode, 4.4.2.1, 4.4.2.1

batch jobs, authenticating users in, 8.3.3

BFILE

data type, 3.3.22.1, 3.3.22.1

maximum size, 7.6

BFILE data type locator descriptor, 2.3.1.13

bin directory, D.2

BINARY_DOUBLE data type, 3.2.4

BINARY_FLOAT data type, 3.2.4

bind and define in statement caching, 9.5.4

bind functions, 16.1.10

bind handle

attributes, A.11

description, 2.3.1.5

bind operations, 4.3, 5.1, 12.14

associations made, 5.1

example, 5.1.4

initializing variables, 5.1

LOBs, 5.2.1

named data types, 12.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, 12.14.2

steps used, 5.1.4

bind placeholders, 4.3.1

binding

arrays, 12.14.4

buffer expansion, 5.8.3.3

multiple buffers, 5.6

OCINumber, 12.16.1

PL/SQL placeholders, 2.7

summary, 5.2

BLOB data type, 3.3.22.2, 3.3.22.2

blocking modes, 2.6.9

branches

detaching, 8.2.3.5

preparing multiple, 8.2.3.8

resuming, 8.2.3.5

buffer expansion during binding, 5.8.3.3

buffered messaging, 9.9.4

buffering LOB operations, 7.7.2

building OCI applications, B

---

C

C data types

manipulating with OCI, 12.3

cache functions

server round-trips, C.4

cache, client result, 10.4

callbacks

dynamic registrations, 9.6.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.6.2

LOB streaming interface, 7.7.4.1

parameter modes, 16.1.10

registration for transparent application failover, 9.7.4

restrictions, 9.6.1.11

user-defined functions, 9.6

canceling a cursor, 17.1.1

canceling OCI calls, 2.6.5

cartridge functions, 20

CASE OTT parameter, 15.8.2.10

change notification descriptor, 2.3.1.13

CHAR

external data type, 3.3.17

character set conversion of Unicode, 2.8.8

character set form, 5.8.1

character set ID, 5.8.1

Unicode, A.11, A.12

character-length semantics, 5.8.3.3.1, 5.8.3.3.3, 5.8.3.4.1, 6.3

CHARZ

external data type, 3.3.18

checkerr() listing, 17.1.1

CHUNK size, 7.6

client result cache, 10.4

maximum size, 10.4.4

CLIENTCONTEXT namespace, 8.6.1

CLOB

data type, 3.3.22.3, 3.3.22.3

code

example programs, B

list of demonstration programs, B

CODE OTT parameter, 15.8.2.4

coding guidelines

reserved words, 2.6.7

coherency

of object cache, 14.1.1

collections

attributes, 6.2.7

data manipulation functions, 12.9.2

describing, 6.1

description, 12.9

functions for manipulating, 12.9.1

multilevel, 12.10

scanning functions, 12.9.3

column objects

direct path loading of, 13.2.2

columns

attributes, 6.1.2.3, 6.2.10

commit, 2.4.3

in object applications, 14.1.8

one-phase for global transactions, 8.2.3.7

two-phase for global transactions, 8.2.3.7

compatibility

of releases in OCI, 1.2

compiling

OCI application, D.4

OCI with Oracle XA, D.7.1

XA Library, D.7

complex object descriptor, 2.3.1.13

complex object retrieval, 11.3.10

descriptor attributes, A.16.2

handle, 2.3.1.7

handle attributes, A.16.1

implementing, 11.3.10.2

navigational prefetching, 11.3.11

complex object retrieval (COR) descriptor, 2.3.1.13.6

COMPRESS, 7.10

CONFIG OTT parameter, 15.8.2.8

configuration files, D.2

location, D.2

connect functions, 16.1.10

connection, 2.4.1.3

connection mode

nonblocking, 2.6.9

connection pool handle

attributes, A.7

description, 2.3.1.11

initializing, 9.1.2.2

connection pooling, 9.1, 9.4

code example, 9.1.3

creating, 9.1.2.2

database resident, 9.3

connection pools and TAF, 9.1.1.4

consistency

of object cache, 14.1.1

continuous query notification, 10.1

attributes, A.18.1

descriptor attributes, A.18.2

example, 10.1.6

copying

objects, 11.3.15

COR

See complex object retrieval

creating

objects, 11.3.15

cursor cancelation, 17.1.1

---

D

data cartridges

OCI functions, 2, 20

data definition language

SQL statements, 1.1.6.1

data manipulation language

SQL statements, 1.1.6.3

data structures, 2.3

See also descriptors

See also handles

data types

ANSI DATE, 3.3.23.1

BFILE, 3.3.22.1

binding and defining, 12.16

BLOBs (binary large objects), 3.3.22.2

CLOB, 3.3.22.3

conversions, 3.4

direct path loading, 13.1.1, A.19.5.1

external, 3.1.1, 3.3

FILE, 3.3.22.1

for piecewise operations, 5.10.1

internal, 3.2

internal codes, 3.2

INTERVAL DAY TO SECOND, 3.3.23.6

INTERVAL YEAR TO MONTH, 3.3.23.5

manipulating with OCI, 12.3

mapping and manipulation functions, C.6

mapping from Oracle to C, 12.2

mapping, Oracle methodology, 12.2.1

mapping, OTT utility, 15.5

NCLOB, 3.3.22.4

Oracle, 3.1

TIMESTAMP, 3.3.23.2

TIMESTAMP WITH LOCAL TIME ZONE, 3.3.23.4

TIMESTAMP WITH TIME ZONE, 3.3.23.3

database connection

for object applications, 11.3.3

database resident connection pooling, 9.3

database type attributes

type OCI_PTYPE_DATABASE, 6.2.14

databases

attributes, 6.2.14

describing, 6.1

shutting down, 10.2

starting up, 10.2

DATE

external data type, 3.3.10

date cache, 13.1.6

date descriptor, 2.3.1.13.5

DATE, ANSI

data type, 3.3.23.1

datetime

avoiding unexpected results, 3.3.23.7

datetime and date

migration rules, 3.4.3

datetime descriptor, 2.3.1.13.5

DDL

See data definition language

DEDUPLICATE, 7.10

default file name extensions

OTT utility, 15.8.7

default name mapping

OTT utility, 15.8.7

define

arrays, 12.15.3.1

return and error codes, 2.5.1

define functions, 16.1.10

define handle

attributes, A.12

description, 2.3.1.5

define operations, 4.6, 5.3, 12.15

example, 5.3.1

LOBs, 5.4.1

named data types, 12.15.1

piecewise fetch, 5.4.3

PL/SQL output variables, 5.4.2

REFs, 12.15.2

steps used, 5.3.1

defining

multiple buffers, 5.6

OCINumber, 12.16.1

deletes

positioned, 2.6.6

demonstration files location, 2.1

demonstration programs, B, D.3

list, B

describe

explicit, 4.5, 4.5.2

explicit and implicit, 6.1.2.3

implicit, 4.5, 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, 16.1.10

describe handle

attributes, A.13

description, 2.3.1.6

describe operation

server round-trips, C.5

describing the stored procedure

example, 6.4.2

descriptor, 2.3.1.13

advanced queuing

agent, 2.3.1.13

dequeue options, 2.3.1.13

enqueue options, 2.3.1.13

listen options, 2.3.1.13

message properties, 2.3.1.13, 2.3.1.13

notification, 2.3.1.13

allocating, 2.4.1.2

ANSI DATE, 2.3.1.13

BFILE data type locator, 2.3.1.13

change notification, 2.3.1.13

complex object, 2.3.1.13

complex object retrieval, 2.3.1.13.6

distinguished names of the database servers in a registration request, 2.3.1.13

functions, 16.1.10

INTERVAL DAY TO SECOND, 2.3.1.13

INTERVAL YEAR TO MONTH, 2.3.1.13

LOB data type locator, 2.3.1.13

objects, 12.12.1, 12.12.1

parameter, 2.3.1.13.3

read-only parameter, 2.3.1.13

result set, 2.3.1.13

row change, 2.3.1.13

ROWID, 2.3.1.13, 2.3.1.13.4

snapshot, 2.3.1.13, 2.3.1.13.1

table change, 2.3.1.13

TIMESTAMP, 2.3.1.13

TIMESTAMP WITH LOCAL TIME ZONE, 2.3.1.13

TIMESTAMP WITH TIME ZONE, 2.3.1.13

user callback, 2.3.1.13

detaching branches, 8.2.3.5

DIAG_ADR_ENABLED sqlnet.ora parameter, 10.5.3

DIAG_DDE_ENABLED sqlnet.ora parameter, 10.5.3

DIAG_RESTRICTED, 10.5.3

DIAG_SIGHANDLER_ENABLED, 10.5.3

direct path loading, 13.1

attribute

OCI_ATTR_DIRPATH_NO_INDEX_ERRORS, 13.4.2.4

column array handle attributes, A.19.3

column parameter attributes, A.19.5

context handle attributes, A.19.1

data types of columns, 13.1.1, A.19.5.1

direct path column array handle, 13.1.2.3

direct path context handle, 13.1.2.1

direct path function context, 13.1.2.2

direct path stream handle, 13.1.2.4

example, 13.1.5

function context handle attributes, A.19.2

functions, 13.1.3, 17.1.1

handle attributes, A.19

handles, 2.3.1.10, 13.1.2

in pieces, 13.3

limitations, 13.1.4

of date columns, 13.1.6

stream handle attributes, A.19.4

directory structures, D.2

distinguished names of the database servers in a registration request descriptor, 2.3.1.13

DML

See data manipulation language

DRCP (database resident connection pooling), 9.3

duration

example, 14.1.9.1

of objects, 14.1.9

dynamic registration

Oracle XA Library, D.7.2

dynamically linked applications, 1.2.1

---

E

edition-based redefinition, 8.7

editions, 8.7

embedded objects

fetching, 11.3.8

embedded SQL, 1.1.6.6

mixing with OCI calls, 1.1.6.6

empty LOB, inserting, 7.8.1

ENCRYPT, 7.10

enhanced DML array

feature, 4.4.2.1, 4.4.2.1

environment handle

attributes, A.2

description, 2.3.1.2

error checking example, 17.1.1

error codes

define calls, 2.5.1

navigational functions, 18.1.7

error handle

attributes, A.3

description, 2.3.1.3

errors

handling, 2.5

handling in object applications, 11.3.19

ERRTYPE OTT parameter, 15.8.2.9

evaluation context

attributes, 6.2.17

evaluation context attributes, 6.2.17

event callback, 9.8.4

event handle attributes, A.21

example

demonstration programs, B

executing SQL statements, 4.4

execution

against multiple servers, 4.2.1

modes, 4.4.2

snapshots, 4.4.1

explicit describe, 4.5, 6.3.2

extensions

OTT utility default file name, 15.8.7

external data types, 3.1.1, 3.3

CHAR, 3.3.17

CHARZ, 3.3.18

conversions, 3.4

DATE, 3.3.10

FLOAT, 3.3.5

INTEGER, 3.3.4

LOB, 3.3.22

LONG, 3.3.8

LONG RAW, 3.3.13

LONG VARCHAR, 3.3.15

LONG VARRAW, 3.3.16

named data types, 3.3.19

NUMBER, 3.3.2

RAW, 3.3.11

REF, 3.3.20

ROWID, 3.3.21

SQLT_BLOB, 3.3.22

SQLT_CLOB, 3.3.22

SQLT_NCLOB, 3.3.22

SQLT_NTY, 3.3.19

SQLT_REF, 3.3.20

STRING, 3.3.6

UNSIGNED, 3.3.14

VARCHAR, 3.3.9

VARCHAR2, 3.3.1

VARNUM, 3.3.7

VARRAW, 3.3.12

external procedure functions

return codes, 20.1.2

with_context type, 20.1.3

external procedures

OCI callbacks, 9.6.2

externally initialized context, 8.5

---

F

failover

callback example, 9.7.5

failover callbacks, 9.7

structure and parameters, 9.7.3

Fast Application Notification (FAN), 9.2.8

fault diagnosability, 10.5

read or write client driver layer name, A.5.2

fetch

piecewise, 5.10, 5.10.6

fetch operation, 4.7

LOB data, 4.7.1

setting prefetch count, 4.7.2

FILE

associating with operating system file, 7.3

data type, 3.3.22.1

FLOAT

external data type, 3.3.5

flushing, 14.1.6.1

object changes, 11.3.7

objects, 14.1.6.1

freeing

objects, 11.3.15, 14.1.4.3

functions

attributes, 6.2.2

---

G

generic documentation references

compiling and linking OCI application, 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.3

globalization support, 2.8

OCI functions, 2

GTRID. See transaction identifier

---

H

HA event notification, 9.8

handle attributes, 2.3.1.12

handle functions, 16.1.10

handle type constants, 2.3.1

handles, 2.3.1, 2.3.1

administration handle, 10.2, 10.2, A.6

advantages of, 2.3.1.1

allocating, 2.3.1.1, 2.4.1.2

bind handle, 2.3.1.5, A.11

C data types, 2.3.1

child freed when parent freed, 2.3.1.1

complex object retrieval handle, 2.3.1.7, A.16.1

connection pool handle, 2.3.1.11, 9.1.2.2, A.7

define handle, 2.3.1.5, A.12

describe handle, 2.3.1.6, A.13

direct path loading, 2.3.1.10

environment handle, 2.3.1.2, A.2

error handle, 2.3.1.3, A.3

freeing, 2.3.1.1

process attributes, A.20

server handle, 2.3.1.4, 2.3.1.4, A.5

service context handle, 2.3.1.4, A.4

statement handle, 2.3.1.5, A.10

subscription, 2.3.1.9, 9.10.1.1

transaction handle, 2.3.1.4, A.9

types, 2.3.1

user session handle, 2.3.1.4, 2.3.1.4, A.5.2

header files

location of, 1.1.12, 2.1, D.2, D.4

oratypes.h, 3.6

HFILE OTT parameter, 15.8.2.7

---

I

implicit describe, 4.5, 6.3.1

include directory, D.2

indicator variables, 2.6.4

arrays of structures, 5.5.3

for named data types, 2.6.3, 2.6.4.3

for REFs, 2.6.3, 2.6.4.3

named data type defines, 12.15.3

PL/SQL OUT binds, 12.15.3

REF defines, 12.15.3

with named data type bind, 12.14.3

with REF bind, 12.14.3

INITFILE OTT parameter, 15.8.2.5

INITFUNC OTT parameter, 15.8.2.6

initialize

all buffers, 5.1.3

functions, 16.1.10

init.ora security parameters, 8.8

inserting an empty LOB, 7.8.1

inserts

piecewise, 5.10, 5.10.3

Instant Client, 1.3

Instant Client Light (English), 1.3.8

INTEGER external data type, 3.3.4

internal codes for data types, 3.2

internal data types, 3.2

conversions, 3.4

INTERVAL DAY TO SECOND data type, 3.3.23.6

INTERVAL DAY TO SECOND descriptor, 2.3.1.13

interval descriptor, 2.3.1.13.5

INTERVAL YEAR TO MONTH data type, 3.3.23.5

INTERVAL YEAR TO MONTH descriptor, 2.3.1.13

intype file

providing when running OTT utility, 15.4

structure of, 15.8.4

INTYPE File Assistant, D.8

INTYPE OTT parameter, 15.8.2.2

IP address

IPv4, A.18

IPv6, A.18

IPv6 addressing, 9.10.1.1, A.18, A.18

---

K

KEEP_DUPLICATES, 7.10

key words, 2.6.7

---

L

LDAP registration of publish-subscribe notification, 9.10.1.3

libraries

oci.lib, D.5

linking

OCI application, D.5

OCI with Oracle XA, D.7.1

XA Library, D.7

list attributes

type OCI_PTYPE_LIST, 6.2.12

lists

attributes, 6.2.12

lmsgen utility, 2.8.10

LoadLibrary, D.5.2

LOB and LONG bind restrictions, 5.2.1.2.1

LOB data type locator descriptor, 2.3.1.13

LOB functions, 17.1.1

server round-trips, C.3

LOB locator, 2.3.1.13.2

attributes, A.15

LOBs

amount and offset parameters, 17.1.1

attributes of transient objects, 7.4.2

binding, 5.2.1

buffering, 7.7.2

callbacks, 7.7.4

character sets, 17.1.1

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 data types, 3.3.22

failover does not work, 9.7.6

fetching data, 4.7.1

fixed-width character sets, 17.1.1

freeing temporary, 7.8.1

greater than 4 GB, 7.6

locator, 2.3.1.13.2

modifying, 7.2

OCI functions, 7.7

prefetching, 7.9

size maximum, 7.6

temporary, 7.8

varying-width character sets, 17.1.1

locator, 2.3.1.13

for LOB data type, 2.3.1.13.2

locking, 14.1.7.2

objects, 14.1.7.2

optimistic model, 14.1.7.4

LONG

external data type, 3.3.8

LONG RAW

external data type, 3.3.13

LONG VARCHAR

external data type, 3.3.15

LONG VARRAW

external data type, 3.3.16

---

M

make.bat file, D.3

makefiles, 2.1, 2.1, B

marking objects, 14.1.5.1

meta-attributes

of objects, 11.3.9

of persistent objects, 11.3.9.1

of transient objects, 11.3.9.3

method descriptor object, 12.12.1

method results

type OCI_PTYPE_TYPE_RESULT, 6.2.11

migration

7.x to 8.0, 1.2.5

session, 8.3.1, 16.1.10

miscellaneous functions, 17.1.1

multiple servers

executing statement against, 4.2.1

multithreaded development

basic concepts, 8.9

multithreading, 8.9

mutexes, 8.9

---

N

named data types

binding, 12.14.1

binding and defining, 12.16

defining, 12.15.1

definition, 3.3.19

external data types, 3.3.19

indicator variables, 2.6.4.3

indicator variables for, 2.6.3

name-value pair attributes

type OCI_PTYPE_NAME_VALUE, 6.2.20

native double, 3.3.24

native float, 3.3.24

navigation, 14.2

navigational functions

error codes, 18.1.7

return values, 18.1.5

terminology, 18.1.2

NCHAR

issues, 5.8

NCLOB

data type, 3.3.22.4, 3.3.22.4

nested table

direct path loading of, 13.2.1

element ordering, 12.9.5.1

functions for manipulating, 12.9.5

new release, relinking, 1.2.1

NLS_LANG, 2.8.1

NLS_NCHAR, 2.8.1

NOCOMPRESS, 7.10

NOENCRYPT, 7.10

nonblocking mode, 2.6.9

non-deferred linkage no longer supported, 8.8.3

nonfinal object tables

direct path loading of, 13.2.7

notification descriptor attributes, A.18.3

NULL indicator

setting for an object attribute, 11.3.14

NULL indicator struct, 11.3.14

generated by OTT, 11.3.1

nullness

of objects, 11.3.14

NULLs

atomic, 11.3.14

inserting, 2.6.4.1

inserting into database, 2.6.3

inserting using indicator variables, 2.6.3

NUMBER

external data type, 3.3.2

---

O

object applications

commit, 14.1.8

database connection, 11.3.3

rollback, 14.1.8

object cache, 14.1

coherency, 14.1.1

consistency, 14.1.1

initializing, 11.3.2

loading objects, 14.1.4

memory parameters, 14.1.2

operations on, 14.1.3

removing objects, 14.1.4

setting the size of, 14.1.2

object functions

server round-trips, C.4

object identifiers, 11.3.17, 11.3.18

for persistent objects, 11.2.2

object references, 11.3.17

See REFs

object run-time environment

initializing, 11.3.2

object tables

direct path loading of, 13.2.6

object type

representing in C applications, 11.3.1

Object Type Translator utility

See OTT utility

object view, 11.3.9.1

objects

accessing with OCI, 15.7.1

allocation duration, 14.1.9

array pin, 11.3.5.1

attributes, 11.3.9

manipulating, 11.3.6

client-side cache, 14.1

copying, 11.3.15

creating, 11.3.15

duration, 14.1.9

flushing, 14.1.6.1

flushing changes, 11.3.7

freeing, 11.3.15, 14.1.4.3

lifetime, 18.1.1

LOB attributes of transient objects, 7.4.2

locking, 14.1.7.2

manipulating with OCI, 15.7.1

marking, 11.3.7, 14.1.5.1

memory layout of instance, 14.1.10

memory management, 14.1

meta-attributes, 11.3.9

navigation, 14.2

simple, 14.2.1

NCHAR and NVARCHAR2 attribute of, 12.2

NULL values, 11.3.14

OCI object application structure, 11.2.1

persistent, 11.2.2, 11.2.2.1

pin count, 11.3.13

pin duration, 14.1.9

pinning, 11.3.5, 14.1.4.1

refreshing, 14.1.6.2

secondary memory, 14.1.10

terminology, 11.2.2, 18.1.1

top-level memory, 14.1.10

transient, 11.2.2, 11.2.2.2

types, 11.2.2, 18.1.1

unmarking, 14.1.5.2

unpinning, 14.1.4.2

use with OCI, 11.1

OCI

aborting calls, 2.6.5

accessing and manipulating objects, 15.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 applications

compiling, 1.1.2, D.4

general structure, 2.2

initialization example, 2.4.1.3.3

linking, 1.1.2, D.5

running, D.6

steps, 2.4

structure, 2.2

structure using objects, 11.2.1

terminating, 2.4.4

using the OTT utility with, 15.7

with objects

initializing, 11.3.2

OCI directory, D.2

OCI environment

initializing for objects, 11.3.2

OCI functions

canceling calls, 2.6.5

data cartridges, 2

globalization, 2

not supported, 1.2.4

obsolescent, 1.2.3

return codes, 2.5, 2.5.2

OCI handle types, 2.3.1

OCI navigational functions, 14.3

flush functions, 14.3.2

mark functions, 14.3.3

meta-attribute accessor functions, 14.3.4

miscellaneous functions, 14.3.5

naming scheme, 14.3

pin/unpin/free functions, 14.3.1

OCI process

initializing for objects, 11.3.2

OCI program

See OCI applications

OCI relational functions

connect, authorize, and initialize, 16.1.10

guide to reference entries, 20.1.1

Oracle Streams Advanced Queuing and publish-subscribe, 17.1.1, E

OCI_ATTR_ACCESS_BANNER, 8.8.2

server handle attribute, A.5

OCI_ATTR_ACTION, 8.5.2.3, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_ADMIN_PFILE

administration handle attribute, A.6

OCI_ATTR_AGENT_ADDRESS

OCIAQAgent descriptor attribute, A.17.4

OCI_ATTR_AGENT_NAME

OCIAQAgent descriptor attribute, A.17.4

OCI_ATTR_AGENT_PROTOCOL

OCIAQAgent descriptor attribute, A.17.4

OCI_ATTR_ALLOC_DURATION

environment handle attribute, A.2

OCI_ATTR_APPCTX_ATTR, 8.5.1.3

user session handle attribute, A.5.2

OCI_ATTR_APPCTX_LIST, 8.5.1.2

user session handle attribute, A.5.2

OCI_ATTR_APPCTX_NAME, 8.5.1.3

user session handle attribute, A.5.2

OCI_ATTR_APPCTX_SIZE, 8.5.1.1, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_APPCTX_VALUE, 8.5.1.3

user session handle attribute, A.5.2

OCI_ATTR_AQ_NTFN_GROUPING_ MSGID_ARRAY

notification descriptor attribute, A.18.3

OCI_ATTR_AQ_NTFN_GROUPING_COUNT, 9.10.2

notification descriptor attribute, A.18.3

OCI_ATTR_AQ_NTFN_GROUPING_MSGID_ARRAY, 9.10.2

OCI_ATTR_ATTEMPTS

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_AUDIT_BANNER, 8.8.2

user session handle attribute, A.5.2

OCI_ATTR_AUTOCOMMIT_DDL

attribute, 6.2.14

OCI_ATTR_BIND_COUNT

statement handle attribute, A.10

OCI_ATTR_BIND_DN, 9.10.1.3

environment handle attribute, A.2

OCI_ATTR_BREAK_ON_NET_TIMEOUT

server handle attribute, A.5

OCI_ATTR_BUF_ADDR

direct path loading stream handle attribute, A.19.4

OCI_ATTR_BUF_SIZE

direct path loading

context handle attribute, A.19.1

stream handle attribute, A.19.4

OCI_ATTR_CACHE

attribute, 6.2.9

OCI_ATTR_CACHE_ARRAYFLUSH, 14.1.6.1

environment handle attribute, A.2

OCI_ATTR_CACHE_MAX_SIZE, 14.1.2

environment handle attribute, A.2

OCI_ATTR_CACHE_OPT_SIZE, 14.1.2

environment handle attribute, A.2

OCI_ATTR_CALL_TIME, 8.5.2.2

user session handle attribute, A.5.2

OCI_ATTR_CATALOG_LOCATION

attribute, 6.2.14

OCI_ATTR_CERTIFICATE, 8.4.1.4, 16.1.10

user session handle attribute, 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, 6.3.2

OCI_ATTR_CHAR_USED, 6.2.10

attribute, 6.3, 6.3.2

OCI_ATTR_CHARSET_FORM, 5.8.1.1

attribute, 6.2.5, 6.2.7, 6.2.10, 6.2.11

bind handle attribute, A.11

define handle attribute, A.12

OCI_ATTR_CHARSET_ID, 5.8.1.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

direct path loading

column parameter attribute, A.19.5.1

context handle attribute, A.19.1

OCI_ATTR_CHDES_DBNAME, 10.1.5.1

continuous query notification descriptor attribute, A.18.2

OCI_ATTR_CHDES_NFTYPE, 10.1.5.1

continuous query notification descriptor attribute, A.18.2

OCI_ATTR_CHDES_QUERIES, 10.1.5.1

OCI_ATTR_CHDES_ROW_OPFLAGS, 10.1.5.1.2

continuous query notification descriptor attribute, A.18.2

OCI_ATTR_CHDES_ROW_ROWID, 10.1.5.1.2

continuous query notification descriptor attribute, A.18.2

OCI_ATTR_CHDES_TABLE_CHANGES, 10.1.5.1

continuous query notification descriptor attribute, A.18.2

OCI_ATTR_CHDES_TABLE_NAME, 10.1.5.1.2

continuous query notification descriptor attribute, A.18.2

OCI_ATTR_CHDES_TABLE_OPFLAGS, 10.1.5.1.2

continuous query notification descriptor attribute, A.18.2

OCI_ATTR_CHDES_TABLE_ROW_CHANGES, 10.1.5.1.2

continuous query notification descriptor attribute, A.18.2

OCI_ATTR_CHDES_XID, 10.1.5.1

OCI_ATTR_CHNF_CHANGELAG, 10.1.3

continuous query notification attribute, A.18.1

OCI_ATTR_CHNF_OPERATIONS, 10.1.3

continuous query notification attribute, A.18.1

OCI_ATTR_CHNF_REGHANDLE

statement handle attribute, A.10

OCI_ATTR_CHNF_ROWIDS, 10.1.3

continuous query notification attribute, A.18.1

OCI_ATTR_CHNF_TABLENAMES, 10.1.3

continuous query notification attribute, A.18.1

OCI_ATTR_CLIENT_IDENTIFIER, 8.4.1.6, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_CLIENT_INFO, 8.5.2.3, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_CLUSTERED

attribute, 6.2.1

OCI_ATTR_COL_COUNT

direct path loading column array handle attribute, A.19.3

OCI_ATTR_COLLECT_CALL_TIME, 8.5.2.1, 16.1.10

user session handle attribute, 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

connection pool handle attribute, A.7

OCI_ATTR_CONN_INCR

connection pool handle attribute, A.7

OCI_ATTR_CONN_MAX

connection pool handle attribute, A.7

OCI_ATTR_CONN_MIN

connection pool handle attribute, A.7

OCI_ATTR_CONN_NOWAIT

connection pool handle attribute, A.7

OCI_ATTR_CONN_OPEN_COUNT

connection pool handle attribute, A.7

OCI_ATTR_CONN_TIMEOUT, 9.1.2.2

connection pool handle attribute, A.7

OCI_ATTR_CONNECTION_CLASS, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_CONSUMER_NAME, 9.10.2, A.17.2

notification descriptor attribute, A.18.3

OCI_ATTR_CORRELATION

OCIAQDeqOptions descriptor attribute, A.17.2

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_CQ_QUERYID, 10.1.4

statement handle attribute, A.10

OCI_ATTR_CQDES_OPERATION, 10.1.5.1.1

direct path loading handle attribute, A.18.4

OCI_ATTR_CQDES_QUERYID, 10.1.5.1.1

direct path loading handle attribute, A.18.4

OCI_ATTR_CQDES_TABLE_CHANGES, 10.1.5.1.1

direct path loading handle attribute, A.18.4

OCI_ATTR_CURRENT_POSITION

attribute, 4.8

statement handle attribute, A.10

OCI_ATTR_CURRENT_SCHEMA, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_CURSOR_COMMIT_ BEHAVIOR

attribute, 6.2.14

OCI_ATTR_DATA_SIZE, 6.2.10, 6.3

attribute, 6.2.5, 6.2.7, 6.2.10, 6.2.11, 6.3.2

direct path loading column parameter attribute, A.19.5.1

OCI_ATTR_DATA_TYPE

attribute, 6.1.2.1, 6.2.5, 6.2.7, 6.2.10, 6.2.11

direct path loading column parameter attribute, A.19.5.1

OCI_ATTR_DATEFORMAT

direct path loading

column parameter attribute, A.19.5.1

context handle attribute, A.19.1

OCI_ATTR_DBDOMAIN

event handle attribute, A.21

OCI_ATTR_DBNAME

event handle attribute, A.21

OCI_ATTR_DEFAULT_LOBPREFETCH_SIZE, 7.9, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_DELAY

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_DEQ_MODE

OCIAQDeqOptions descriptor attribute, A.17.2

OCI_ATTR_DEQ_MSGID

OCIAQDeqOptions descriptor attribute, A.17.2

OCI_ATTR_DEQCOND

OCIAQDeqOptions descriptor attribute, A.17.2

OCI_ATTR_DESC_PUBLIC, 16.1.10

OCI_ATTR_DIRPATH_DCACHE_DISABLE, 13.1.6.5

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_DCACHE_HITS, 13.1.6.4

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_DCACHE_MISSES, 13.1.6.3

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_DCACHE_NUM, 13.1.6.2

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_DCACHE_SIZE, 13.1.6.1

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_EXPR_TYPE

direct path function context handle attribute, A.19.2

function context attribute, 13.4.2.3

OCI_ATTR_DIRPATH_INDEX_MAINT_METHOD

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_MODE

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_NO_INDEX_ERRORS, 13.4.2.4

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_NOLOG

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_OBJ_CONSTR, 13.4.2.1

direct path context attribute, 13.4.1.1

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_OID

direct path loading column parameter attribute, A.19.5.1

OCI_ATTR_DIRPATH_PARALLEL, 13.1

direct path loading context handle attribute, A.19.1

OCI_ATTR_DIRPATH_SID

column array attribute, 13.4.3.2

direct path loading column parameter attribute, A.19.5.1

OCI_ATTR_DIRPATH_SKIPINDEX_METHOD

direct path loading context handle attribute, A.19.1

OCI_ATTR_DISTINGUISHED_NAME, 8.4.1.3, 8.4.1.4, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_DML_ROW_OFFSET

error handle attribute, A.3

OCI_ATTR_DN_COUNT

OCIServerDNs descriptor attribute, A.17.5

OCI_ATTR_DRIVER_NAME, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_DURATION

attribute, 6.2.1

OCI_ATTR_EDITION, 8.7, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_ENCAPSULATION

attribute, 6.2.6

OCI_ATTR_ENQ_TIME

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_ENV

server handle attribute, A.5

service context handle attribute, A.4

statement handle attribute, A.10

OCI_ATTR_ENV_CHARSET_ID, 2.8.2

environment handle attribute, A.2

OCI_ATTR_ENV_NCHARSET_ID, 2.8.2

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

event handle attribute, A.21

OCI_ATTR_EVTCBK, 9.8.4

environment handle attribute, A.2

OCI_ATTR_EVTCTX, 9.8.4

environment handle attribute, A.2

OCI_ATTR_EXCEPTION_QUEUE

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_EXPIRATION

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_EXTERNAL_NAME, 8.2.3.6

server handle attribute, A.5

OCI_ATTR_FETCH_ROWID, 10.3

statement handle attribute, A.10

OCI_ATTR_FOCBK

server handle attribute, A.5

OCI_ATTR_FSPRECISION

attribute, 6.2.5

OCI_ATTR_HA_SOURCE

event handle attribute, A.21

OCI_ATTR_HA_SRVFIRST, 9.8.4

event handle attribute, A.21

OCI_ATTR_HA_SRVNEXT, 9.8.4

event handle attribute, A.21

OCI_ATTR_HA_STATUS

event handle attribute, A.21

OCI_ATTR_HA_TIMESTAMP

event handle attribute, 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

event handle attribute, 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, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_INSTNAME

event handle attribute, A.21

OCI_ATTR_INSTSTARTTIME

event handle attribute, A.21

OCI_ATTR_INTERNAL_NAME, 8.2.3.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_TYPED

attribute, 6.2.1

OCI_ATTR_IS_WNDS

attribute, 6.2.6

OCI_ATTR_IS_WNPS

attribute, 6.2.6

OCI_ATTR_LDAP_AUTH, 9.10.1.3

environment handle attribute, A.2

OCI_ATTR_LDAP_CRED, 9.10.1.3

environment handle attribute, A.2

OCI_ATTR_LDAP_CTX, 9.10.1.3

environment handle attribute, A.2

OCI_ATTR_LDAP_HOST, 9.10.1.3

environment handle attribute, A.2

OCI_ATTR_LDAP_PORT, 9.10.1.3

environment handle attribute, 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.1.2.4, 6.2.2, 6.2.6, 6.2.11

OCI_ATTR_LIST_COLUMNS

attribute, 6.2.1

direct path loading

context handle attribute, A.19.1

function context handle 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_LOBPREFETCH_LENGTH, 7.9

define handle attribute, A.12

OCI_ATTR_LOBPREFETCH_SIZE, 7.9

define handle attribute, A.12

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_LEN

attribute, 6.2.14

OCI_ATTR_MAXCHAR_SIZE

attribute, 5.8.3, 5.8.3.2

bind handle attribute, A.11

define handle attribute, A.12

OCI_ATTR_MAXDATA_SIZE

attribute, 5.8.3

bind handle attribute, A.11

use with binding, 5.8.3.1

OCI_ATTR_MEMPOOL_APPNAME

process handle attribute, A.20

OCI_ATTR_MEMPOOL_HOMENAME

process handle attribute, A.20

OCI_ATTR_MEMPOOL_INSTNAME

process handle attribute, A.20

OCI_ATTR_MEMPOOL_SIZE

process handle attribute, A.20

OCI_ATTR_MIGSESSION

user session handle attribute, A.5.2

OCI_ATTR_MIN

attribute, 6.2.9

OCI_ATTR_MODULE, 8.5.2.3, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_MSG_DELIVERY_MODE, 17.1.1, 17.1.1

OCIAQDeqOptions descriptor attribute, A.17.2

OCIAQEnqOptions descriptor attribute, A.17.1

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_MSG_PROP, 9.10.2

notification descriptor attribute, A.18.3

OCI_ATTR_MSG_STATE

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_NAME

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.19, 6.2.20

column array attribute, 13.4.3.1

direct path loading

column parameter attribute, A.19.5.1

context handle attribute, A.19.1

function context attribute, 13.4.2.2

function context handle attribute, A.19.2

OCI_ATTR_NAVIGATION

OCIAQDeqOptions descriptor attribute, A.17.2

OCI_ATTR_NCHARSET_ID

attribute, 6.2.14

OCI_ATTR_NFY_FLAGS, 9.10.2

notification descriptor attribute, A.18.3

OCI_ATTR_NFY_MSGID, 9.10.2

notification descriptor attribute, A.18.3

OCI_ATTR_NONBLOCKING_MODE

server handle attribute, 2.6.10, A.5

OCI_ATTR_NOWAIT_SUPPORT

attribute, 6.2.14

OCI_ATTR_NUM_COLS

attribute, 6.2.1

direct path loading

column array handle attribute, A.19.3

function context attribute, 13.4.2.5

function context handle attribute, A.19.2

direct path loading context handle attribute, A.19.1

OCI_ATTR_NUM_DML_ERRORS

statement handle attribute, A.10

OCI_ATTR_NUM_ELEMS

attribute, 6.2.7

OCI_ATTR_NUM_HANDLES attribute, 6.2.12

OCI_ATTR_NUM_ROWS

attribute, 13.4.4.1

direct path loading

column array handle attribute, A.19.3

context handle attribute, A.19.1

function context handle attribute, A.19.2

function context attribute, 13.4.2.6

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, 14.1.7.4

environment handle attribute, 14.1.7.4, A.2

OCI_ATTR_OBJECT_NEWNOTNULL, 18.1.7

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

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_OVERLOAD_ID

attribute, 6.2.2

OCI_ATTR_PARAM

describe handle attribute, A.13

use when an attribute is itself a descriptor, 16.1.10

OCI_ATTR_PARAM_COUNT

describe handle attribute, A.13

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, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_PDPRC

bind handle attribute, A.11

define handle attribute, A.12

OCI_ATTR_PDSCL

bind handle attribute, A.11

define handle attribute, 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

attribute, 6.1.2.3, 6.2.5, 6.2.7, 6.2.10, 6.2.11

direct path loading column parameter attribute, A.19.5.1

OCI_ATTR_PREFETCH_MEMORY, 4.7.2

statement handle attribute, A.10

OCI_ATTR_PREFETCH_ROWS, 4.7.2

statement handle attribute, A.10

OCI_ATTR_PRIORITY

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_PROC_MODE

process handle attribute, A.20

OCI_ATTR_PROXY_CLIENT, 2.4.1.3.2

user session handle attribute, A.5.2

OCI_ATTR_PROXY_CREDENTIALS, 8.4.1.2, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_PTYPE

attribute, 6.2

possible values of, 6.2

OCI_ATTR_PURITY, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_PURITY_DEFAULT

user session handle attribute, A.5.2

OCI_ATTR_PURITY_NEW, 9.3.3.1

OCI_ATTR_PURITY_SELF, 9.3.3.1

OCI_ATTR_QUEUE_NAME, 9.10.2

notification descriptor attribute, A.18.3

OCI_ATTR_RADIX

attribute, 6.2.11

OCI_ATTR_RDBA

attribute, 6.2.1

OCI_ATTR_RECIPIENT_LIST

OCIAQMsgProperties descriptor attribute, 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

OCIAQEnqOptions descriptor attribute, A.17.1

OCI_ATTR_RELATIVE_MSGID enqueue option, 9.9.3

OCI_ATTR_ROW_COUNT, 4.8, 4.8

direct path loading

column array handle attribute, A.19.3

stream handle attribute, A.19.4

statement handle attribute, A.10

OCI_ATTR_ROWID

statement handle attribute, A.10

OCI_ATTR_ROWS_FETCHED, 4.8

statement handle attribute, A.10

OCI_ATTR_ROWS_RETURNED

bind handle attribute, A.11

use with callbacks, 5.7.5

OCI_ATTR_SAVEPOINT_SUPPORT

attribute, 6.2.14

OCI_ATTR_SCALE

attribute, 6.2.5, 6.2.7, 6.2.10, 6.2.11

direct path loading column parameter attribute, A.19.5.1

OCI_ATTR_SCHEMA_NAME

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

direct path loading context handle attribute, A.19.1

OCI_ATTR_SENDER_ID

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_SEQ

attributes, 6.2.9

OCI_ATTR_SEQUENCE enqueue option, 9.9.3

OCI_ATTR_SEQUENCE_DEVIATION

OCIAQEnqOptions descriptor attribute, A.17.1

OCI_ATTR_SERVER

service context handle attribute, A.4

OCI_ATTR_SERVER_DN

OCIServerDNs descriptor attribute, A.17.5

OCI_ATTR_SERVER_DNS

subscription handle attribute, A.18

OCI_ATTR_SERVER_GROUP, 8.3.4

server handle attribute, A.5

OCI_ATTR_SERVER_STATUS, 2.5

server handle attribute, A.5

OCI_ATTR_SERVICENAME

event handle attribute, A.21

OCI_ATTR_SESSION

service context handle attribute, A.4

OCI_ATTR_SESSION_STATE, 9.3.10, 9.3.11, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_SHARED_HEAPALLOC

environment handle attribute, A.2

OCI_ATTR_SPOOL_AUTH

session pool handle attribute, A.8

OCI_ATTR_SPOOL_BUSY_COUNT

session pool handle attribute, A.8

OCI_ATTR_SPOOL_GETMODE

session pool handle attribute, A.8

OCI_ATTR_SPOOL_INCR

session pool handle attribute, A.8

OCI_ATTR_SPOOL_MAX

session pool handle attribute, A.8

OCI_ATTR_SPOOL_MIN

session pool handle attribute, A.8

OCI_ATTR_SPOOL_OPEN_COUNT

session pool handle attribute, A.8

OCI_ATTR_SPOOL_STMTCACHESIZE

session pool handle attribute, A.8

OCI_ATTR_SPOOL_TIMEOUT

session pool handle attribute, A.8

OCI_ATTR_SQLFNCODE

statement handle attribute, A.10

OCI_ATTR_STATEMENT

statement handle attribute, A.10

OCI_ATTR_STMT_STATE

statement handle attribute, A.10

OCI_ATTR_STMT_TYPE

statement handle attribute, A.10

OCI_ATTR_STMTCACHE_CBK

service context handle attribute, A.4

OCI_ATTR_STMTCACHE_CBKCTX

statement handle attribute, A.10

OCI_ATTR_STMTCACHESIZE, 9.5.3, 16.1.10, 16.1.10

service context handle attribute, A.4

OCI_ATTR_STREAM_OFFSET

direct path loading stream handle attribute, A.19.4

OCI_ATTR_SUB_NAME

attribute, 6.2.11

direct path loading context handle attribute, A.19.1

OCI_ATTR_SUBSCR_CALLBACK, 9.10.1.1, 9.10.1.3, 10.1.3

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_CQ_CHNF_QOSFLAGS, 10.1.3

OCI_ATTR_SUBSCR_CQ_QOSFLAGS

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_CTX, 9.10.1.1, 9.10.1.3

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_HOSTADDR, 9.10.1.1

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_IPADDR

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_NAME, 9.10.1.1, 9.10.1.3

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_NAMESPACE, 9.10.1.1, 9.10.1.3, 10.1.3

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_NTFN_GROUPING_CLASS, 9.10.1.1, A.18

OCI_ATTR_SUBSCR_NTFN_GROUPING_REPEAT_COUNT, 9.10.1.1

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_NTFN_GROUPING_START_TIME, 9.10.1.1

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_NTFN_GROUPING_TYPE, 9.10.1.1

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_NTFN_GROUPING_VALUE, 9.10.1.1

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_PAYLOAD, 9.10.1.1, 9.10.1.3

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_PORTNO

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_QOSFLAGS, 9.10.1.1, 9.10.1.3, 10.1.3

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_RECPT, 9.10.1.1, 9.10.1.3

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_RECPTPRES, 9.10.1.1

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_RECPTPROTO, 9.10.1.1, 9.10.1.3

subscription handle attribute, A.18

OCI_ATTR_SUBSCR_RECPTRES, 9.10.1.3

OCI_ATTR_SUBSCR_SERVER_DN

descriptor handle, 9.10.1.3

OCI_ATTR_SUBSCR_TIMEOUT, 9.10.1.1, 9.10.1.3, 10.1.3

subscription handle attribute, 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.8.6

server handle attribute, A.5

OCI_ATTR_TIMESTAMP

attribute, 6.2

OCI_ATTR_TRANS

service context handle attribute, A.4

OCI_ATTR_TRANS_NAME, 8.2.3.1

transaction handle attribute, A.9

OCI_ATTR_TRANS_TIMEOUT

transaction handle attribute, A.9

OCI_ATTR_TRANSACTION_IN_PROGRESS

user session handle attribute, A.5.2

OCI_ATTR_TRANSACTION_NO

OCIAQMsgProperties descriptor attribute, A.17.3

OCI_ATTR_TRANSFORMATION (dequeue)

OCIAQDeqOptions descriptor attribute, A.17.2

OCI_ATTR_TRANSFORMATION (enqueue)

OCIAQEnqOptions descriptor attribute, A.17.1

OCI_ATTR_TYPE

attribute, 6.2.19

OCI_ATTR_TYPE_NAME

attribute, 6.2.5, 6.2.7, 6.2.10, 6.2.11

OCI_ATTR_TYPECODE

attribute, 6.1.2.1, 6.2.4, 6.2.5, 6.2.7, 6.2.11

OCI_ATTR_USER_MEMORY, 9.8.5

server handle attribute, A.5

OCI_ATTR_USERNAME, 2.4.1.3.2, 16.1.10

user session handle attribute, A.5.2

OCI_ATTR_VALUE

attribute, 6.2.20

OCI_ATTR_VAR_METHOD_FUNCTION

attribute, 6.2.19, 6.2.19

OCI_ATTR_VAR_VALUE_FUNCTION

attribute, 6.2.19

OCI_ATTR_VERSION

attribute, 6.2.14

OCI_ATTR_VISIBILITY

OCIAQDeqOptions descriptor attribute, A.17.2

OCIAQEnqOptions descriptor attribute, A.17.1

OCI_ATTR_WAIT

OCIAQDeqOptions descriptor attribute, A.17.2

OCI_ATTR_WALL_LOC, 9.10.1.3

environment handle attribute, A.2

OCI_ATTR_XID, 8.2.3.1

transaction handle attribute, A.9

OCI_BATCH_ERRORS, 17.1.1

OCI_BIND_SOFT, 16.1.10, 16.1.10

OCI_COMMIT_ON_SUCCESS, 17.1.1

OCI_CONTINUE, 2.5

OCI_CPOOL_REINITIALIZE, 16.1.10

OCI_CRED_EXT, 16.1.10

OCI_CRED_PROXY, 8.4.1.1

OCI_CRED_RDBMS, 8.4.1.1, 16.1.10

OCI_DATA_AT_EXEC, 16.1.10, 16.1.10

OCI_DEFAULT, 8.9.3, 16.1.10, 16.1.10, 16.1.10, 17.1.1

OCISessionBegin() mode, 16.1.10

OCI_DEFAULT mode for OCIDefineByPos(), 16.1.10

OCI_DEFINE_SOFT, 16.1.10

OCI_DESCRIBE_ONLY, 17.1.1

OCI_DIRPATH_COL_ERROR, 13.2.2.4

OCI_DIRPATH_DATASAVE_FINISH, 17.1.1

OCI_DIRPATH_DATASAVE_SAVEONLY, 17.1.1

OCI_DIRPATH_EXPR_OBJ_CONSTR, 13.4.2.2, 13.4.2.3

OCI_DIRPATH_EXPR_REF_TBLNAME, 13.2.4.1, 13.4.2.3

OCI_DIRPATH_EXPR_SQL, 13.4.2.2, 13.4.2.3

OCI_DIRPATH_OID column array attribute, 13.4.3.3

OCI_DTYPE_AQAGENT, 2.3.1.13

OCI_DTYPE_AQDEQ_OPTIONS, 2.3.1.13

OCI_DTYPE_AQENQ_OPTIONS, 2.3.1.13

OCI_DTYPE_AQLIS_MSG_PROPERTIES, 2.3.1.13

OCI_DTYPE_AQLIS_OPTIONS, 2.3.1.13

OCI_DTYPE_AQMSG_PROPERTIES, 2.3.1.13

OCI_DTYPE_AQNFY, 2.3.1.13

OCI_DTYPE_CHDES, 2.3.1.13

OCI_DTYPE_COMPLEXOBJECTCOMP, 2.3.1.13

OCI_DTYPE_CQDES, 10.1.5.1.1

OCI_DTYPE_DATE, 2.3.1.13

OCI_DTYPE_FILE, 2.3.1.13

OCI_DTYPE_INTERVAL_DS, 2.3.1.13

OCI_DTYPE_INTERVAL_YM, 2.3.1.13

OCI_DTYPE_LOB, 2.3.1.13

OCI_DTYPE_PARAM, 2.3.1.13, 16.1.10, 16.1.10

when used, 16.1.10

OCI_DTYPE_ROW_CHDES, 2.3.1.13

OCI_DTYPE_ROWID, 2.3.1.13

OCI_DTYPE_RSET, 2.3.1.13

OCI_DTYPE_SNAP, 2.3.1.13

OCI_DTYPE_SRVDN, 2.3.1.13

OCI_DTYPE_TABLE_CHDES, 2.3.1.13

OCI_DTYPE_TIMESTAMP, 2.3.1.13

OCI_DTYPE_TIMESTAMP_LTZ, 2.3.1.13

OCI_DTYPE_TIMESTAMP_TZ, 2.3.1.13

OCI_DTYPE_UCB, 2.3.1.13

OCI_DURATION_DEFAULT, 18.1.7

OCI_DURATION_NULL, 6.2.1, 18.1.7

possible value of OCI_ATTR_DURATION, 6.2.1

OCI_DURATION_SESSION, 6.2.1, 14.1.4.1, 17.1.1, 20.1.3, 21.1.2, 21.1.2, 21.1.2, 21.1.2

possible value of OCI_ATTR_DURATION, 6.2.1

OCI_DURATION_STATEMENT, 17.1.1, 20.1.3, 21.1.2, 21.1.2, 21.1.2, 21.1.2

OCI_DURATION_TRANS, 6.2.1, 14.1.4.1

possible value of OCI_ATTR_DURATION, 6.2.1

OCI_DYNAMIC_FETCH, 16.1.10

OCI_ENABLE_NLS_VALIDATION, 16.1.10, 16.1.10

OCI_ENV_NO_MUTEX, 8.9.3, 16.1.10, 16.1.10

OCI_ERROR, 2.5, 8.2.3.7

OCI_EVENTS, 16.1.10, 16.1.10

mode for receiving notifications, 9.10.1.1

OCI_EXACT_FETCH, 17.1.1

OCI_EXT_CRED, 8.4.1.1

OCI_HTYPE_ADMIN, 2.3.1, 10.2

OCI_HTYPE_AUTHINFO, 2.3.1, 9.2.4.2

OCI_HTYPE_BIND, 2.3.1

OCI_HTYPE_COMPLEXOBJECT, 2.3.1

OCI_HTYPE_COR, 16.1.10

OCI_HTYPE_CPOOL, 2.3.1, 9.1.2.1

OCI_HTYPE_DEFINE, 2.3.1

OCI_HTYPE_DESCRIBE, 2.3.1

OCI_HTYPE_DIRPATH_COLUMN_ARRAY, 2.3.1

OCI_HTYPE_DIRPATH_CTX, 2.3.1

OCI_HTYPE_DIRPATH_FN_COL_ARRAY, 13.2.2.2, 13.4.2.6, 13.4.4

OCI_HTYPE_DIRPATH_FN_CTX, 2.3.1

OCI_HTYPE_DIRPATH_STREAM, 2.3.1

OCI_HTYPE_ENV, 2.3.1

OCI_HTYPE_ERROR, 2.3.1

OCI_HTYPE_PROC, 2.3.1

OCI_HTYPE_SERVER, 2.3.1

OCI_HTYPE_SESSION, 2.3.1

OCI_HTYPE_SPOOL, 2.3.1

OCI_HTYPE_STMT, 2.3.1, 16.1.10, 16.1.10

OCI_HTYPE_SUBSCRIPTION, 2.3.1

OCI_HTYPE_SVCCTX, 2.3.1

OCI_HTYPE_TRANS, 2.3.1

OCI_IND_NULL, 11.3.14, 16.1.10, 21.1.2

OCI_INVALID_HANDLE, 2.5

OCI_IOV, 5.6, 5.6, 16.1.10, 16.1.10

OCI_LOCK_NONE, 14.1.7.1

OCI_LOCK_X, 14.1.7.1

OCI_LOCK_X_NOWAIT, 14.1.7.1, 14.1.7.3

parameter usage, 14.1.7.3

OCI_LOGON2_STMTCACHE, 9.5.2

OCI_LTYPE_ARG_FUNC list attribute, 6.2.12

OCI_LTYPE_ARG_PROC list attribute, 6.2.12

OCI_LTYPE_COLUMN 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, 17.1.1

OCI_MIGRATE, 8.3.1

OCISessionBegin() mode, 16.1.10

OCI_MINOR_VERSION, client library version, 17.1.1

OCI_NCHAR_LITERAL_REPLACE_OFF, 16.1.10, 16.1.10

OCI_NCHAR_LITERAL_REPLACE_ON, 16.1.10, 16.1.10

OCI_NEED_DATA, 2.5

OCI_NEW_LENGTH_SEMANTICS, 16.1.10

OCI_NLS_MAXBUFSZ, 22.1.2

OCI_NO_DATA, 2.5

OCI_NO_UCB, 16.1.10, 16.1.10, 16.1.10

OCI_NTV_SYNTAX, 17.1.1, 17.1.1

OCI_OBJECT, 2.4.1.1, 9.10.1.1, 16.1.10, 16.1.10

OCI_PARSE_ONLY, 17.1.1

OCI_PIN_ANY, 14.1.4.1

OCI_PIN_LATEST, 14.1.4.1

OCI_PIN_RECENT, 14.1.4.1

OCI_PRELIM_AUTH

OCISessionBegin() mode, 16.1.10

OCI_PTYPE_ARG

attributes, 6.2.11

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_COL

attributes, 6.2.10

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_COLL

attributes, 6.2.7

OCI_PTYPE_DATABASE

attributes, 6.2.14

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_EVALUATION CONTEXT

attributes, 6.2.17

OCI_PTYPE_FUNC

attributes, 6.2.2

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_LIST

attributes, 6.2.12

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_NAME_VALUE

attributes, 6.2.20

OCI_PTYPE_PKG

attributes, 6.2.3

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_PROC

attributes, 6.2.2

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_RULE_SET

attributes, 6.2.16

OCI_PTYPE_RULES

attributes, 6.2.15

OCI_PTYPE_SCHEMA

attributes, 6.2.13

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_SEQ

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_SYN

attributes, 6.2.8

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_TABLE

attributes, 6.2.1

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_TABLE_ALIAS

attributes, 6.2.18

OCI_PTYPE_TYPE

attributes, 6.2.4

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_TYPE_ARG

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_TYPE_ATTR

attributes, 6.2.5

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_TYPE_COLL

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_TYPE_FUNC

attributes, 6.2.6

OCI_PTYPE_TYPE_METHOD, 6.2.6

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_TYPE_PROC

attributes, 6.2.6

OCI_PTYPE_TYPE_RESULT

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_UNK

possible value of OCI_ATTR_PTYPE, 6.2

OCI_PTYPE_VARIABLE_TYPE

attributes, 6.2.19

OCI_PTYPE_VIEW

attributes, 6.2.1

possible value of OCI_ATTR_PTYPE, 6.2

OCI_ROWCBK_DONE, 2.5

OCI_SESSGET_PURITY_NEW, 9.3.3.1

OCI_SESSGET_PURITY_SELF, 9.3.3.1

OCI_SESSGET_STMTCACHE, 9.5.2

OCI_SESSION_STATEFUL, 9.3.11

OCI_SESSION_STATELESS, 9.3.10, 9.3.11

OCI_SESSRLS_RETAG, 16.1.10, 16.1.10

OCI_SPC_NO_RLB, 9.2.8

OCI_STILL_EXECUTING, 2.5, 2.6.9

OCI_STMT_CACHE

OCISessionBegin() mode, 16.1.10

OCI_STMT_SCROLLABLE_READONLY, 17.1.1

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.10.1.1, 9.10.1.4, 10.1.3

OCI_SUBSCR_QOS_RELIABLE, 9.10.1.1, 9.10.1.4, 10.1.3

OCI_SUCCESS, 2.5, 8.2.3.7

OCI_SUCCESS_WITH_INFO, 2.5

OCI_SUPPRESS_NLS_VALIDATION, 16.1.10, 16.1.10

OCI_SYSDBA

OCISessionBegin() mode, 16.1.10

OCI_SYSOPER

OCISessionBegin() mode, 16.1.10

OCI_THREADED, 8.9.3, 16.1.10, 16.1.10

OCI_TRANS_LOOSE, 8.2.3.3

OCI_TRANS_NEW, 8.2.5.1

OCI_TRANS_READONLY, 8.2.2, 8.2.5.3

OCI_TRANS_READWRITE, 8.2.2

OCI_TRANS_RESUME, 8.2.5.2

OCI_TRANS_SERIALIZABLE, 8.2.2

OCI_TRANS_TIGHT, 8.2.3.3

OCI_TRANS_TWOPHASE, 8.2.5.2

OCI_TYPECODE, 6.1.2.1

values, 3.5, 3.5, 3.5.1

OCI_TYPECODE_NAMEDCOLLECTION

possible value of OCI_ATTR_TYPECODE, 6.2.4

OCI_TYPECODE_NCHAR, 12.13.3, 12.13.3

OCI_TYPECODE_OBJECT

possible value of OCI_ATTR_TYPECODE, 6.2.4

OCI_TYPECODE_TABLE

possible value of OCI_ATTR_COLLECTION_TYPECODE, 6.2.4

OCI_TYPECODE_VARRAY

possible value of OCI_ATTR_COLLECTION_TYPECODE, 6.2.4

OCI_TYPEENCAP_PRIVATE

possible value of OCI_ATTR_ENCAPSULATION, 6.2.6

OCI_TYPEENCAP_PUBLIC

possible value of OCI_ATTR_ENCAPSULATION, 6.2.6

OCI_UTF16ID, 2.8.1

OCI_V7_SYNTAX, 17.1.1, 17.1.1

OCIAnyDataAccess(), 21.1.2

OCIAnyDataAttrGet(), 21.1.2

OCIAnyDataAttrSet(), 21.1.2

OCIAnyDataBeginCreate(), 21.1.2

OCIAnyDataCollAddElem(), 21.1.2

OCIAnyDataCollGetElem(), 21.1.2

OCIAnyDataConvert(), 21.1.2

OCIAnyDataDestroy(), 21.1.2

OCIAnyDataEndCreate(), 21.1.2

OCIAnyDataGetCurrAttrNum(), 21.1.2

OCIAnyDataGetType(), 21.1.2

OCIAnyDataIsNull(), 21.1.2

OCIAnyDataSetAddInstance(), 21.1.2

OCIAnyDataSetBeginCreate(), 21.1.2

OCIAnyDataSetDestroy(), 21.1.2

OCIAnyDataSetEndCreate(), 21.1.2

OCIAnyDataSetGetCount(), 21.1.2

OCIAnyDataSetGetInstance(), 21.1.2

OCIAnyDataSetGetType(), 21.1.2

OCIAnyDataTypeCodeToSqlt(), 12.13.3, 21.1.2

OCIAppCtxClearAll(), 8.6.2, 16.1.10

OCIAppCtxSet(), 8.6.1, 16.1.10

OCIAQAgent

descriptor attributes, A.17.4

OCIAQDeq(), 17.1.1

OCIAQDeqArray(), 17.1.1

OCIAQDeqOptions

descriptor attributes, A.17.2

OCIAQEnq(), 17.1.1

OCIAQEnqArray(), 17.1.1

OCIAQEnqOptions

descriptor attributes, A.17.1

OCIAQListen(), E

OCIAQListen2(), 17.1.1

OCIAQMsgProperties

descriptor attributes, A.17.3

OCIArray, 12.9

binding and defining, 12.9, 12.16

OCIArray manipulation

code example, 12.9.4

OCIArrayDescriptorAlloc(), 16.1.10

OCIArrayDescriptorFree(), 16.1.10

OCIAttrGet(), 16.1.10

used for describing, 4.5.1

OCIAttrSet(), 16.1.10

OCIAuthInfo definition, 9.2.4.2

OCIAuthInfo handle attributes, A.5.2

OCIBindArrayOfStruct(), 16.1.10

OCIBindByName(), 16.1.10

OCIBindByPos(), 16.1.10

OCIBindDynamic(), 16.1.10

OCIBindObject(), 16.1.10

OCIBinXmlCreateReposCtxFromConn(), 14.5.4.3, 23.1.2

OCIBinXmlCreateReposCtxFromCPool(), 14.5.4.4, 23.1.2

OCIBinXmlReposCtx repository context, 14.5.4.2

OCIBinXmlSetFormatPref(), 14.5.4.6, 23.1.2

OCIBinXmlSetReposCtxForConn(), 14.5.4.5, 23.1.2

OCIBreak(), 17.1.1

use of, 2.6.5, 2.6.11

OCICacheFlush(), 18.1.7

OCICacheFree(), 18.1.7

OCICacheRefresh(), 18.1.7

OCICacheUnmark(), 18.1.7

OCICacheUnpin(), 18.1.7

OCICharSetConversionIsReplacementUsed(), 22.1.2

OCICharSetToUnicode(), 22.1.2

OCIClientVersion(), 17.1.1

OCIColl, 12.9

binding and defining, 12.9

OCICollAppend(), 19.1.6

OCICollAssign(), 19.1.6

OCICollAssignElem(), 19.1.6

OCICollGetElem(), 19.1.6

OCICollGetElemArray(), 19.1.6

OCICollIsLocator(), 19.1.6

OCICollMax(), 19.1.6

OCICollSize(), 19.1.6

OCICollTrim(), 19.1.6

OCIComplexObject

use of, 11.3.10.2

OCIComplexObjectComp

use of, 11.3.10.2

OCIConnectionPoolCreate(), 16.1.10

OCIConnectionPoolDestroy(), 16.1.10

OCIContextClearValue(), 20.1.3

OCIContextGenerateKey(), 20.1.3

OCIContextGetValue(), 20.1.3

OCIContextSetValue(), 20.1.3

OCIDate, 12.4

binding and defining, 12.4, 12.16

manipulation usage example, 12.4.1

OCIDateAddDays(), 19.1.6

OCIDateAddMonths(), 19.1.6

OCIDateAssign(), 19.1.6

OCIDateCheck(), 19.1.6

OCIDateCompare(), 19.1.6

OCIDateDaysBetween(), 19.1.6

OCIDateFromText(), 19.1.6

OCIDateGetDate(), 19.1.6

OCIDateGetTime(), 19.1.6

OCIDateLastDay(), 19.1.6

OCIDateNextDay(), 19.1.6

OCIDateSetDate(), 19.1.6

OCIDateSetTime(), 19.1.6

OCIDateSysDate(), 19.1.6

OCIDateTimeAssign(), 19.1.6

OCIDateTimeCheck(), 19.1.6

OCIDateTimeCompare(), 19.1.6

OCIDateTimeConstruct(), 19.1.6

OCIDateTimeConvert(), 19.1.6

OCIDateTimeFromArray(), 19.1.6

OCIDateTimeFromText(), 19.1.6

OCIDateTimeGetDate(), 19.1.6

OCIDateTimeGetTime(), 19.1.6

OCIDateTimeGetTimeZoneName(), 19.1.6

OCIDateTimeGetTimeZoneOffset(), 19.1.6

OCIDateTimeIntervalAdd(), 19.1.6

OCIDateTimeIntervalSub(), 19.1.6

OCIDateTimeSubtract(), 19.1.6

OCIDateTimeSysTimeStamp(), 19.1.6

OCIDateTimeToArray(), 19.1.6

OCIDateTimeToText(), 19.1.6

OCIDateToText(), 19.1.6

OCIDateZoneToZone(), 19.1.6

OCIDBShutdown(), 16.1.10

OCIDBStartup(), 16.1.10

OCIDefineArrayOfStruct(), 16.1.10

OCIDefineByPos(), 16.1.10

OCIDefineDynamic(), 16.1.10

OCIDefineObject(), 16.1.10

OCIDescribeAny(), 16.1.10

limitations, 6.1.1

overview, 6.1

usage examples, 6.4

OCIDescriptorAlloc(), 16.1.10

OCIDescriptorFree(), 16.1.10

OCIDirPathAbort(), 17.1.1

OCIDirPathColArray context, 13.1.2.1

OCIDirPathColArrayEntryGet(), 17.1.1

OCIDirPathColArrayEntrySet(), 17.1.1

OCIDirPathColArrayReset(), 17.1.1

OCIDirPathColArrayRowGet(), 17.1.1

OCIDirPathColArrayToStream(), 17.1.1

OCIDirPathCtx context, 13.1.2.1

OCIDirPathDataSave(), 17.1.1

OCIDirPathFinish(), 17.1.1

OCIDirPathFlushRow(), 17.1.1

OCIDirPathLoadStream(), 17.1.1

OCIDirPathPrepare(), 17.1.1

OCIDirPathStream context, 13.1.2.1

OCIDirPathStreamReset(), 17.1.1

OCIDuration

use of, 14.1.4.1, 14.1.9

OCIDurationBegin(), 17.1.1, 20.1.3

OCIDurationEnd(), 17.1.1, 20.1.3

OCIEnvCreate(), 16.1.10

OCIEnvInit(), E

OCIEnvNlsCreate(), 2.8.1, 5.8.2, 16.1.10

OCIErrorGet(), 17.1.1

OCIEvent handle, 9.8.1

OCIEventCallback data type, 9.8.4

OCIExtProcAllocCallMemory(), 20.1.3

OCIExtProcGetEnv(), 20.1.3

OCIExtProcRaiseExcp(), 20.1.3

OCIExtProcRaiseExcpWithMsg(), 20.1.3

OCIExtractFromFile(), 20.1.3, 20.1.3, 20.1.3

OCIExtractFromList(), 20.1.3

OCIExtractFromStr(), 20.1.3

OCIExtractInit(), 20.1.3

OCIExtractReset(), 20.1.3

OCIExtractSetKey(), 20.1.3

OCIExtractSetNumKeys(), 20.1.3

OCIExtractTerm(), 20.1.3

OCIExtractToBool(), 20.1.3

OCIExtractToInt(), 20.1.3

OCIExtractToList(), 20.1.3

OCIExtractToOCINum(), 20.1.3

OCIExtractToStr(), 20.1.3

OCIFileClose(), 20.1.3

OCIFileExists(), 20.1.3

OCIFileFlush(), 20.1.3

OCIFileGetLength(), 20.1.3

OCIFileInit(), 20.1.3

OCIFileObject data structure, 20.1.3

OCIFileOpen(), 20.1.3

OCIFileRead(), 20.1.3

OCIFileSeek(), 20.1.3

OCIFileTerm(), 20.1.3

OCIFileWrite(), 20.1.3

OCIFormatInit(), 20.1.3

OCIFormatString(), 20.1.3

OCIFormatTerm(), 20.1.3

OCIHandleAlloc(), 16.1.10

OCIHandleFree(), 16.1.10

OCIInd

use of, 11.3.14

OCIInitialize(), E

OCIIntervalAdd(), 19.1.6

OCIIntervalAssign(), 19.1.6

OCIIntervalCheck(), 19.1.6

OCIIntervalCompare(), 19.1.6

OCIIntervalDivide(), 19.1.6

OCIIntervalFromNumber(), 19.1.6

OCIIntervalFromText(), 19.1.6

OCIIntervalFromTZ(), 19.1.6

OCIIntervalGetDaySecond(), 19.1.6

OCIIntervalGetYearMonth(), 19.1.6

OCIIntervalMultiply(), 19.1.6

OCIIntervalSetDaySecond(), 19.1.6

OCIIntervalSetYearMonth(), 19.1.6

OCIIntervalSubtract(), 19.1.6

OCIIntervalToNumber(), 19.1.6

OCIIntervalToText(), 19.1.6

OCIIOV struct, 5.6

OCIIter, 12.9

binding and defining, 12.9

usage example, 12.9.4

OCIIterCreate(), 19.1.6

OCIIterDelete(), 19.1.6

OCIIterGetCurrent(), 19.1.6

OCIIterInit(), 19.1.6

OCIIterNext(), 19.1.6

OCIIterPrev(), 19.1.6

OCILdaToSvcCtx(), 17.1.1

oci.lib, D.5

OCILobAppend(), 17.1.1

OCILobArrayRead(), 7.9, 17.1.1

OCILobArrayWrite(), 17.1.1

OCILobAssign(), 17.1.1

OCILobCharSetForm(), 17.1.1

OCILobCharSetId(), 17.1.1

OCILobClose(), 17.1.1

OCILobCopy(), E

OCILobCopy2(), 17.1.1

OCILobCreateTemporary(), 17.1.1

OCILobDisableBuffering(), 17.1.1

OCILobEnableBuffering(), 17.1.1

OCILobErase(), E

OCILobErase2(), 17.1.1

OCILobFileClose(), 17.1.1

OCILobFileCloseAll(), 17.1.1

OCILobFileExists(), 17.1.1

OCILobFileGetName(), 17.1.1

OCILobFileIsOpen(), 17.1.1

OCILobFileOpen(), 17.1.1

OCILobFileSetName(), 17.1.1

OCILobFlushBuffer(), 17.1.1

OCILobFreeTemporary(), 17.1.1

OCILobGetChunkSize(), 7.6, 17.1.1

OCILobGetContentType(), 17.1.1

OCILobGetLength(), E

OCILobGetLength2(), 17.1.1

OCILobGetOptions(), 17.1.1

OCILobGetStorageLimit(), 17.1.1

OCILobIsEqual(), 17.1.1

OCILobIsOpen(), 17.1.1

OCILobIsTemporary(), 17.1.1

OCILobLoadFromFile(), E

OCILobLoadFromFile2(), 17.1.1

OCILobLocatorAssign(), 17.1.1

OCILobLocatorIsInit(), 17.1.1

OCILobOpen(), 17.1.1

OCILobRead(), E

OCILobRead2(), 17.1.1

OCILobSetContentType(), 17.1.1

OCILobSetOptions(), 17.1.1

OCILobTrim(), E

OCILobTrim2(), 17.1.1

OCILobWrite(), E

OCILobWrite2(), 17.1.1

OCILobWriteAppend(), E

OCILobWriteAppend2(), 17.1.1

OCILockOpt

possible values, 18.1.7, 18.1.7

OCILogoff(), 16.1.10

OCILogon(), 16.1.10

using, 2.4.1.3.1

OCILogon2(), 16.1.10

OCIMemoryAlloc(), 20.1.3

OCIMemoryFree(), 20.1.3

OCIMemoryResize(), 20.1.3

OCIMessageClose(), 22.1.2

OCIMessageGet(), 22.1.2

OCIMessageOpen(), 22.1.2

OCIMultiByteInSizeToWideChar(), 22.1.2

OCIMultiByteStrCaseConversion(), 22.1.2

OCIMultiByteStrcat(), 22.1.2

OCIMultiByteStrcmp(), 22.1.2

OCIMultiByteStrcpy(), 22.1.2

OCIMultiByteStrlen(), 22.1.2

OCIMultiByteStrncat(), 22.1.2

OCIMultiByteStrncmp(), 22.1.2

OCIMultiByteStrncpy(), 22.1.2

OCIMultiByteStrnDisplayLength(), 22.1.2

OCIMultiByteToWideChar(), 22.1.2

OCINlsCharSetConvert(), 22.1.2

OCINlsCharSetIdToName(), 22.1.2, 22.1.2, 22.1.2, 22.1.2, 22.1.2

OCINlsCharSetNameTold(), 22.1.2

OCINlsEnvironmentVariableGet(), 5.8.2, 22.1.2

OCINlsGetInfo(), 2.8.2, 22.1.2

OCINlsNameMap(), 22.1.2

OCINlsNumericInfoGet(), 22.1.2

OCINumber, 12.6

bind example, 12.16.1

binding and defining, 12.6, 12.16

define example, 12.16.1

usage examples, 12.6.1

OCINumberAbs(), 19.1.6

OCINumberAdd(), 19.1.6

OCINumberArcCos(), 19.1.6

OCINumberArcSin(), 19.1.6

OCINumberArcTan(), 19.1.6

OCINumberArcTan2(), 19.1.6

OCINumberAssign(), 19.1.6

OCINumberCeil(), 19.1.6

OCINumberCmp(), 19.1.6

OCINumberCos(), 19.1.6

OCINumberDec(), 19.1.6

OCINumberDiv(), 19.1.6

OCINumberExp(), 19.1.6

OCINumberFloor(), 19.1.6

OCINumberFromInt(), 19.1.6

OCINumberFromReal(), 19.1.6

OCINumberFromText(), 19.1.6

OCINumberHypCos(), 19.1.6

OCINumberHypSin(), 19.1.6

OCINumberHypTan(), 19.1.6

OCINumberInc(), 19.1.6

OCINumberIntPower(), 19.1.6

OCINumberIsInt(), 19.1.6

OCINumberIsZero(), 19.1.6

OCINumberLn(), 19.1.6

OCINumberLog(), 19.1.6

OCINumberMod(), 19.1.6

OCINumberMul(), 19.1.6

OCINumberNeg(), 19.1.6

OCINumberPower(), 19.1.6

OCINumberPrec(), 19.1.6

OCINumberRound(), 19.1.6

OCINumberSetPi(), 19.1.6

OCINumberSetZero(), 19.1.6

OCINumberShift(), 19.1.6

OCINumberSign(), 19.1.6

OCINumberSin(), 19.1.6

OCINumberSqrt(), 19.1.6

OCINumberSub(), 19.1.6

OCINumberTan(), 19.1.6

OCINumberToInt(), 19.1.6

OCINumberToReal(), 19.1.6

OCINumberToRealArray(), 19.1.6

OCINumberToText(), 19.1.6

OCINumberTrunc(), 19.1.6

OCIObjectArrayPin(), 18.1.7

OCIObjectCopy(), 18.1.7

OCIObjectExists(), 18.1.7

OCIObjectFlush(), 18.1.7

OCIObjectFree(), 18.1.7

OCIObjectGetAttr(), 18.1.7

OCIObjectGetInd(), 18.1.7

example of use, 11.3.14

OCIObjectGetObjectRef(), 18.1.7

OCIObjectGetProperty(), 18.1.7

OCIObjectGetTypeRef(), 18.1.7

OCIObjectIsDirty(), 18.1.7

OCIObjectIsLocked(), 18.1.7

OCIObjectLifetime

possible values, 18.1.7

OCIObjectLock(), 18.1.7

OCIObjectLockNoWait(), 18.1.7

OCIObjectMarkDelete(), 18.1.7

OCIObjectMarkDeleteByRef(), 18.1.7

OCIObjectMarkStatus

possible values, 18.1.7

OCIObjectMarkUpdate(), 18.1.7

OCIObjectNew(), 18.1.7

OCIObjectPin(), 18.1.7

OCIObjectPinCountReset(), 18.1.7

OCIObjectPinTable(), 18.1.7

OCIObjectRefresh(), 18.1.7

OCIObjectSetAttr(), 18.1.7

OCIObjectUnmark(), 18.1.7

OCIObjectUnmarkByRef(), 18.1.7

OCIObjectUnpin(), 18.1.7

OCIParamGet(), 16.1.10

used for describing, 4.5.1

OCIParamSet(), 16.1.10

OCIPasswordChange(), 17.1.1

OCIPing(), 17.1.1

OCIPinOpt

use of, 14.1.4.1

OCIRaw, 12.8

binding and defining, 12.8, 12.16

manipulation usage example, 12.8.2

OCIRawAllocSize(), 19.1.6

OCIRawAssignBytes(), 19.1.6

OCIRawAssignRaw(), 19.1.6

OCIRawPtr(), 19.1.6

OCIRawResize(), 19.1.6

OCIRawSize(), 19.1.6

OCIRef, 12.11

binding and defining, 12.11

usage example, 12.11.2

OCIRefAssign(), 19.1.6

OCIRefClear(), 19.1.6

OCIRefFromHex(), 19.1.6

OCIRefHexSize(), 19.1.6

OCIRefIsEqual(), 19.1.6

OCIRefIsNull(), 19.1.6

OCIRefToHex(), 19.1.6

OCIReset(), 17.1.1

use of, 2.6.11

OCIRowid ROWID descriptor, 2.3.1.13.4

OCIRowidToChar(), 17.1.1

OCIServerAttach(), 16.1.10

shadow processes, 16.1.10

OCIServerDetach(), 16.1.10

OCIServerDNs descriptor attributes, A.17.5

OCIServerRelease(), 17.1.1

OCIServerVersion(), 17.1.1

OCISessionBegin(), 2.4.1.3.3, 2.8.5, 8.3.1, 16.1.10

OCISessionEnd(), 16.1.10

OCISessionGet(), 16.1.10

OCISessionPoolCreate(), 16.1.10

OCISessionPoolDestroy(), 16.1.10

OCISessionRelease(), 16.1.10

OCIStmtExecute(), 17.1.1

prefetch during, 4.4

use of iters parameter, 4.4

OCIStmtFetch(), E

OCIStmtFetch2(), 4.8, 17.1.1

OCIStmtGetBindInfo(), 16.1.10

OCIStmtGetPieceInfo(), 17.1.1

OCIStmtPrepare(), 17.1.1

OCIStmtPrepare2(), 17.1.1

preparing SQL statements, 4.2

OCIStmtRelease(), 17.1.1

OCIStmtSetPieceInfo(), 17.1.1

OCIString, 12.7

binding and defining, 12.7, 12.16

manipulation usage example, 12.7.2

OCIStringAllocSize(), 19.1.6

OCIStringAssign(), 19.1.6

OCIStringAssignText(), 19.1.6

OCIStringPtr(), 19.1.6

OCIStringResize(), 19.1.6

OCIStringSize(), 19.1.6

OCISubscriptionDisable(), 17.1.1

OCISubscriptionEnable(), 17.1.1

OCISubscriptionPost(), 17.1.1

OCISubscriptionRegister(), 17.1.1

OCISubscriptionUnRegister(), 17.1.1

OCISvcCtxToLda(), 17.1.1

OCITable, 12.9

binding and defining, 12.9, 12.16

OCITableDelete(), 19.1.6

OCITableExists(), 19.1.6

OCITableFirst(), 19.1.6

OCITableLast(), 19.1.6

OCITableNext(), 19.1.6

OCITablePrev(), 19.1.6

OCITableSize(), 19.1.6

OCITerminate(), 16.1.10

OCIThread package, 8.10

OCIThreadClose(), 17.1.1

OCIThreadCreate(), 17.1.1

OCIThreadHandleGet(), 17.1.1

OCIThreadHndDestroy(), 17.1.1

OCIThreadHndInit(), 17.1.1

OCIThreadIdDestroy(), 17.1.1

OCIThreadIdGet(), 17.1.1

OCIThreadIdInit(), 17.1.1

OCIThreadIdNull(), 17.1.1

OCIThreadIdSame(), 17.1.1

OCIThreadIdSet(), 17.1.1

OCIThreadIdSetNull(), 17.1.1

OCIThreadInit(), 17.1.1

OCIThreadIsMulti(), 17.1.1

OCIThreadJoin(), 17.1.1

OCIThreadKeyDestroy(), 17.1.1

OCIThreadKeyGet(), 17.1.1

OCIThreadKeyInit(), 17.1.1

OCIThreadKeySet(), 17.1.1

OCIThreadMutexAcquire(), 17.1.1

OCIThreadMutexDestroy(), 17.1.1

OCIThreadMutexInit(), 17.1.1

OCIThreadMutexRelease(), 17.1.1

OCIThreadProcessInit(), 17.1.1

OCIThreadTerm(), 17.1.1

OCITransCommit(), 17.1.1

OCITransDetach(), 17.1.1

OCITransForget(), 17.1.1

OCITransMultiPrepare(), 8.2.3.8, 17.1.1

OCITransPrepare(), 17.1.1

OCITransRollback(), 17.1.1

OCITransStart(), 17.1.1

OCIType

description, 12.12.1

OCITypeAddAttr(), 21.1.2

OCITypeArrayByName(), 18.1.7

OCITypeArrayByRef(), 18.1.7

OCITypeBeginCreate(), 21.1.2

OCITypeByName(), 18.1.7

OCITypeByRef(), 18.1.7

OCITypeCode, 3.5

OCITypeElem

description, 12.12.1

OCITypeEndCreate(), 21.1.2

OCITypeMethod

description, 12.12.1

OCITypeSetBuiltin(), 21.1.2

OCITypeSetCollection(), 21.1.2

OCIUnicodeToCharSet(), 22.1.2

OCIUserCallbackGet(), 17.1.1

OCIUserCallbackRegister(), 17.1.1

OCIWchar data type, 2.8.7

OCIWideCharInSizeToMultiByte(), 22.1.2

OCIWideCharIsAlnum(), 22.1.2

OCIWideCharIsAlpha(), 22.1.2

OCIWideCharIsCntrl(), 22.1.2

OCIWideCharIsDigit(), 22.1.2

OCIWideCharIsGraph(), 22.1.2

OCIWideCharIsLower(), 22.1.2

OCIWideCharIsPrint(), 22.1.2

OCIWideCharIsPunct(), 22.1.2

OCIWideCharIsSingleByte(), 22.1.2

OCIWideCharIsSpace(), 22.1.2

OCIWideCharIsUpper(), 22.1.2

OCIWideCharIsXdigit(), 22.1.2

OCIWideCharMultiByteLength(), 22.1.2

OCIWideCharStrCaseConversion(), 22.1.2

OCIWideCharStrcat(), 22.1.2

OCIWideCharStrchr(), 22.1.2

OCIWideCharStrcmp(), 22.1.2

OCIWideCharStrcpy(), 22.1.2

OCIWideCharStrlen(), 22.1.2

OCIWideCharStrncat(), 22.1.2

OCIWideCharStrncmp(), 22.1.2

OCIWideCharStrncpy(), 22.1.2

OCIWideCharStrrchr(), 22.1.2

OCIWideCharToLower(), 22.1.2

OCIWideCharToMultiByte(), 22.1.2

OCIWideCharToUpper(), 22.1.2

OCIXmlDbFreeXmlCtx(), 14.5.3, 23.1.2

ocixmldb.h header file, 14.5.3

OCIXmlDbInitXmlCtx(), 14.5.3, 23.1.2

OID

See object identifiers

opaque, definition of, 1.1

optimistic locking

implementing, 14.1.7.4

ORA_EDITION environment variable, 8.7

ORA_NCHAR_LITERAL_REPLACE, 16.1.10

ORA-25219 error during enqueue, 9.9.3

Oracle Call Interface

See OCI

Oracle data types, 3.1

mapping to C, 12.2

Oracle Database

transaction processing monitor, D.7

Oracle RAC, 9.2.8

Oracle Real Application Clusters, 9.2.8

Oracle Streams Advanced Queuing

dequeue function, 17.1.1

description, 9.9

descriptor attributes, A.17

enqueue function, 17.1.1

functions, 17.1.1, E

OCI and, 9.9

OCI descriptors for, 9.9.2

OCI functions for, 9.9.1

OCI versus PL/SQL, 9.9.3

publish-subscribe notification in OCI, 9.10

Oracle XA Library

additional documentation, D.7.3

compiling and linking an OCI program, D.7.1

dynamic registration, D.7.2

Oracle XML DB OCI functions, 14.5, 23.1.2

orasb8 data type, 7.6

oratypes.h

as parameter source in OCI, 3.6

contents, 3.6

definitions in, 3.6

oraub8 data type, 7.6

ORE

See object runtime environment

OTT

See OTT utility

OTT parameters, 15.8.1, 15.8.2

CASE, 15.8.2.10

CODE, 15.8.2.4

CONFIG, 15.8.2.8

ERRTYPE, 15.8.2.9

HFILE, 15.8.2.7

INITFILE, 15.8.2.5

INITFUNC, 15.8.2.6

INTYPE, 15.8.2.2

OUTTYPE, 15.8.2.3

SCHEMA_NAMES, 15.8.2.11

TRANSITIVE, 15.8.2.12

URL, 15.8.2.13

USERID, 15.8.2.1

where they appear, 15.8.3

OTT utility

command line, 15.3, D.8

command-line syntax, 15.8.1

creating types in the database, 15.2.1

data type mappings, 15.5

initialization function

calling, 15.7.2

tasks of, 15.7.3

intype file, 15.8.4

outtype file, 15.6

overview, 15.1

parameters, 15.8.2

See OTT parameters

providing an intype file, 15.4

reference, 15.8

restriction, 15.8.8

sample output, 11.3.1

use with OCI, 11.3.1

using, 15, 15.2

ottcfg.cfg, D.2

outtype file, 15.8.4

when running OTT utility, 15.6

OUTTYPE OTT parameter, 15.8.2.3

---

P

packages

attributes, 6.2.3

describing, 6.1

parameter descriptor, 2.3.1.13.3

attributes, 6.2, A.14

object, 12.12.1

parameters

attributes, 6.2

buffer lengths, 16.1.9

modes, 16.1.4

passing strings, 2.6.2.3

string length, 16.1.9

password management, 8.3, 8.3.2

persistent objects, 11.2.2.1

meta-attributes, 11.3.9.1

piecewise

binds and defines for LOBs, 5.10.7

fetch, 5.10.6

piecewise operations, 5.10.3

fetch, 5.10, 5.10.6.1

in PL/SQL, 5.10.4

insert, 5.10

update, 5.10

valid data types, 5.10.1

pin count, 11.3.13

pin duration

example, 14.1.9.1

of objects, 14.1.9

pinning objects, 14.1.4.1

placeholders

rules, 4.3.1

PL/SQL, 1.1.6.5

binding and defining nested tables, 5.9

binding and defining REF CURSORS, 5.9

binding placeholders, 2.7

defining output variables, 5.4.2

piecewise operations, 5.10.4

uses in OCI applications, 2.7

using in OCI applications, 2.7

using in OCI programs, 5.1.5

polling mode, 2.6.8

positioned deletes, 2.6.6

positioned updates, 2.6.6

prefetching

during OCIStmtExecute(), 4.4

LOBs, 7.9

setting prefetch memory size, 4.7.2

setting row count, 4.7.2

preparing multiple branches in a single message, 8.2.3.8

procedures

attributes, 6.2.2

process

handle attributes, A.20

proxy access, 2.4.1.3.2

proxy authentication, 2.4.1.3.2, 8.4.1.7, 8.4.1.7

publish-subscribe

_SYSTEM_TRIG_ENABLED parameter, 9.10.4

COMPATIBLE parameter, 9.10.1.1

example, 9.10.4

functions, 9.10.1, 17.1.1, E

handle attributes, 9.10.1.1, A.18

LDAP registration, 9.10.1.3

notification callback, 9.10.2

notification in OCI, 9.10

subscription handle, 9.10.1.1

---

Q

query

explicit describe, 4.5.2

See SQL query

---

R

RAW

external data type, 3.3.11

read-only parameter descriptor, 2.3.1.13

REF

external data type, 3.3.20

REF columns

direct path loading of, 13.2.4

REF CURSOR variables

binding and defining, 5.9

references to objects

See REFs

refreshing, 14.1.6.2

objects, 14.1.6.2

REFs

binding, 12.14.2

CURSOR variables, binding, 5.2.3

defining, 12.15.2

external data type, 3.3.20

indicator variables for, 2.6.3, 2.6.4.3

retrieving from server, 11.3.4

registering

user callbacks, 9.6.1

registry

REGEDT32, D.7.2.3

relational functions, C.8

server round-trips, C.2

relinking, need for, 1.2.1

required support files, D.1

reserved namespaces, 2.6.7.1

reserved words, 2.6.7

result cache, 10.4

result set, 4.8

result set descriptor, 2.3.1.13

resuming branches, 8.2.3.5

retrieving attributes of an object type

example, 6.4.3

retrieving column data types for a table

example, 6.4.1

retrieving the collection element’s data type of a named collection type

example, 6.4.4

return values

navigational functions, 18.1.5

RETURNING clause

binding with, 5.7.2

error handling, 5.7.3

initializing variables, 5.7.2

using with OCI, 5.7

with REFs, 5.7.4

rollback, 2.4.3

in object applications, 14.1.8

row change descriptor, 2.3.1.13

ROWID

external data type, 3.3.21

implicit fetching, 10.3

logical, 3.2.3

OCIRowid descriptor, 2.3.1.13.4

Universal ROWID, 3.2.3

used for positioned updates and deletes, 2.6.6

ROWID descriptor, 2.3.1.13

RSFs, D.1

rule sets

attributes, 6.2.16

type OCI_PTYPE_RULE_SET, 6.2.16

rules

attributes, 6.2.15

type OCI_PTYPE_RULE, 6.2.15

running OCI application, D.6

---

S

sample programs, B, D.3

samples directory, D.2

sb1

definition, 3.6

sb2

definition, 3.6

sb4

definition, 3.6

scatter/gather for binds/defines, 5.6

schema type attributes

type OCI_PTYPE_SCHEMA, 6.2.13

SCHEMA_NAMES OTT parameter, 15.8.2.11

usage, 15.8.6

SCHEMA.QUEUE, 17.1.1

SCHEMA.QUEUE:CONSUMER_NAME, 17.1.1

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

in OCI, 4.8

increasing performance, 4.8.1

SDK for Instant Client Light, 1.3.9

secondary memory

of object, 14.1.10

SECUREFILE parameter, 7.10

SecureFiles, 7.10

OCILobGetContentType(), 17.1.1

OCILobSetContentType(), 17.1.1

SecureFiles LOBs, 7.10

security

init.ora parameters, 8.8

OCI enhancements, 8.8

select list

describing, 4.5

sequences

attributes, 6.2.9

describing, 6.1

server handle

attributes, A.5

description, 2.3.1.4

setting in service context, 2.3.1.4

server round-trips

cache functions, C.4

data type mapping and manipulation functions, C.6

definition of, C

describe operation, C.5

LOB functions, C.3

object functions, C.4

relational functions, C.8

service context handle

attributes, A.4

description, 2.3.1.4

elements of, 2.3.1.4

session creation, 2.4.1.3

session management, 8.3, 8.3.4

session migration, 8.3.1, 16.1.10

session pool handle

attributes, A.8

session pooling, 9.2, 9.4

example, 9.2.7

functionality, 9.2.1

runtime connection load balancing, 9.2.8

tagging, 9.2

shutting down databases, 10.2

signal handler, 8.9

skip parameters

for arrays of structures, 5.5.1

for standard arrays, 5.5.1.1

snapshot descriptor, 2.3.1.13, 2.3.1.13.1

snapshots

executing against, 4.4.1

SQL query

binding placeholders

See bind operations

defining output variables, 4.6, 5.3, 12.15

See define operations

fetching results, 4.7

statement type, 1.1.6.4

SQL statements, 1.1.6

binding placeholders in, 4.3, 5.1, 12.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.8.1.1, 17.1.1, 17.1.1, 17.1.1, 17.1.1, 17.1.1, 17.1.1, 17.1.1, E, E, E

SQLCS_NCHAR, 5.8.1.1, 17.1.1, 17.1.1, 17.1.1, 17.1.1, 17.1.1, 17.1.1, 17.1.1, E, E, E

sqlnet.ora, 8.8

sqlnet.ora, controlling ADR, 10.5.3

SQLT typecodes, 3.5.1

SQLT_BDOUBLE, 3.3.24

SQLT_BFLOAT, 3.3.24

SQLT_CHR, A.19.1

SQLT_IBDOUBLE, 3.2.4, 6.2.10

SQLT_IBFLOAT, 3.2.4, 6.2.10

SQLT_NTY

bind example, 12.17.1

define example, 12.17.2

description, 3.3.19

preallocating object memory, 12.15.3

SQLT_REF

definition, 3.3.20

description, 3.3.20

starting up databases, 10.2

STATEFUL, 9.3.11

stateful sessions, 9.1.1.2

STATELESS, 9.3.11

stateless sessions, 9.1.1.2

statement caching, 9.5

code example, 9.5.5

statement handle

attributes, A.10

description, 2.3.1.5

statically linked applications, 1.2.1

stored functions

describing, 6.1

stored procedures

describing, 6.1

STRING

external data type, 3.3.6

strings

passing as parameters, 2.6.2.3

structures

arrays of, 5.5

subprogram attributes, 6.2.2

subscription handle, 2.3.1.9

attributes, A.18

supporting UTF-16 Unicode in OCI, 2.8.1, 2.8.1, 2.8.5, 2.8.5, 2.8.7, 2.8.8

sword

definition in oratypes.h file, 3.6

synonyms

attributes, 6.2.8

describing, 6.1

---

T

table alias

attributes

type OCI_PTYPE_TABLE_ALIAS, 6.2.18

table change descriptor, 2.3.1.13

tables

attributes, 6.2.1

describing, 6.1

limitations on OCIDescribeAny() and OCIStmtExecute(), 6.1.1

TAF (transparent application failover)

callback registration, 9.7.4

callbacks, 9.7

connections enabled by, 9.8.6

in connection pools, 9.1.1.4

OCI callbacks, 9.7

tagging

custom pooling, 9.8.5

session pooling, 9.2, 16.1.10, 16.1.10

TDO

definition, 12.14.1

description, 12.12.1

in the object cache, 14.4

obtaining, 12.12.1

terminology

navigational functions, 18.1.2

used in this manual, 1.1.6.7

thread handle description, 2.3.1.8, 8.10.3.1

thread management functions, 17.1.1

thread safety, 8.9

advantages of, 8.9.1

basic concepts, 8.9

implementing with OCI, 8.9.3

mixing 7.x and 8.0 calls, 8.9.3.2

required OCI calls, 8.9.3

three-tier architectures, 8.9.2

threads package, 8.10

three-tier architectures

thread safety, 8.9.2

time zone files differ on client and server, 10.6

TIMESTAMP data type, 3.3.23.2

TIMESTAMP descriptor, 2.3.1.13

TIMESTAMP WITH LOCAL TIME ZONE data type, 3.3.23.4

TIMESTAMP WITH LOCAL TIME ZONE descriptor, 2.3.1.13

TIMESTAMP WITH TIME ZONE data type, 3.3.23.3

TIMESTAMP WITH TIME ZONE descriptor, 2.3.1.13

TimesTen In-Memory Database access from OCI, Preface, 1.1, 10

TNS_ADMIN, 1.3.6

tnsnames.ora file, 1.3.2

top-level memory

of object, 14.1.10

transaction handle

attributes, A.9

description, 2.3.1.4

transaction identifier, 8.2.3.1

transaction processing monitor

additional documentation, D.7.3

interacting with Oracle Database, D.7

types, D.7

transactional complexity

levels in OCI, 8.2

transactions

committing, 2.4.3

functions, 17.1.1

global, 8.2.3

branch states, 8.2.3.4

branches, 8.2.3.3

one-phase commit, 8.2.3.7

transactions identifier, 8.2.3.1

two-phase commit, 8.2.3.7

global examples, 8.2.4

initialization parameters, 8.2.5

local, 8.2.1

OCI functions for

transactions, 8.1

read-only, 8.2.2

rolling back, 2.4.3

serializable, 8.2.2

transient objects, 11.2.2.2

LOBs

attributes, 7.4.2

meta-attributes, 11.3.9.3

TRANSITIVE OTT parameter, 15.4, 15.5.2, 15.8.2.12

transparent application failover

See TAF

type attributes

attributes, 6.2.5

type descriptor object, 11.3.1, 12.12.1

type evolution, 11.5

object cache, 14.4

type functions

attributes, 6.2.6

type inheritance

OTT utility support, 15.5.4

type method attributes, 6.2.6

type procedures

attributes, 6.2.6

type reference, 11.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.11, A.11, A.12

data buffer alignment, 2.8.8

OCILobRead(), E

OCILobWrite(), 17.1.1, 17.1.1, E

Universal ROWID, 3.2.3

unmarking objects, 14.1.5.2

unpinning objects, 11.3.13, 14.1.4.2

UNSIGNED

external data type, 3.3.14

updates

piecewise, 5.10, 5.10.3

positioned, 2.6.6

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, 15.8.2.13

UROWID

Universal ROWID, 3.2.3

user callback descriptor, 2.3.1.13

user memory

allocating, 2.3.1.13.8

user session handle

attributes, A.5.2

description, 2.3.1.4

setting in service context, 2.3.1.4

user-defined callback functions, 9.6

registering, 9.6.1

USERID OTT parameter, 15.8.2.1

using an explicit describe on a named collection type

example, 6.4.4

using an explicit describe on a named object type

example, 6.4.3

using an explicit describe to retrieve column data types for a table

example, 6.4.1

utext

Unicode data type, 5.8.2, 5.8.3.5.2

UTF-16 data, sample code, 5.8.3.5.2

---

V

values, 11.2.2

in object applications, 11.2.2.3

VARCHAR

external data type, 3.3.9

VARCHAR2

external data type, 3.3.1

variable type attributes

type OCI_PTYPE_VARIABLE_TYPE, 6.2.19

VARNUM

external data type, 3.3.7

VARRAW

external data type, 3.3.12

varrays, 3.3.19, 12.9

as objects, 11.1

C mapping, 15.5.1

define calls, 12.15.1

direct path loading not supported, 13.1.4

iterator, 19.1.6

NULLs, 11.3.14

or collection Iterator example, 12.9.4

scan, 19.1.6

version compatibility, 1.2.1

views

attributes, 6.2.1

describing, 6.1

---

W

wchar_t data type, 2.8.7, 5.8.3.5.2, 22.1.2

with_context

argument to external procedure functions, 20.1.3

---

X

XA Library

compiling and linking an OCI program, D.7.1

functions, D.7

OCI support, 1.1.12

overview, D.7

XA specification, 8.2.3.1

xa.h header, 1.1.12

XID

See transaction identifier

XML DB functions, 14.5.3, 23.1.2

XML support in OCI, 14.5, 23.1

xtramem_sz parameter

using, 2.3.1.13.8