Index

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

A

ADR, 12.7

ADRC utility, 12.7.2

base location, 12.7.1

ADR Command Interpreter, 12.7

ADRCI, 12.7, 12.7.2

Agent class, 13

methods, 13

AnyData class, 13

methods, 13

supported data type, 13

usage examples, 13

application managed data buffering, 12.3

application-provided serialization, 12.2.3.2

associative access

overview, 4.6

atomic null, 4.9.2

attributes, 1.5

automatic diagnostic repository (ADR), 12.7

automatic serialization, 12.2.3.1

B

BatchSQLException

methods, 13

BatchSQLException class, 13

Bfile class, 13

methods, 13

BFILEs

external data type, 5.3.1.1

bind operations

in bind operations, 1.4

out bind operations, 1.4

Blob class, 13

methods, 13

BLOBs

external data type, 5.3.1.4

Bytes class, 13

methods, 13

C

callable statements, 3.4.3

with arrays as parameters, 3.4.3.1

CASE OTT parameter, 8.4.3.2

CHAR

external data type, 5.3.1.5

classes

Agent class, 13

AnyData class, 13

BatchSQLException class, 13

Bfile class, 13

Blob class, 13

Bytes class, 13

Clob class, 13

Connection class, 13

ConnectionPool class, 13

Consumer class, 13

Date class, 13

Environment class, 13

IntervalDS class, 13

IntervalYM class, 13

Listener class, 13

Map class, 13

Message class, 13

Metadata class, 13

NotifyResult class, 13

Number class, 13

PObject class, 13

Producer class, 13

Ref class, 13

RefAny class, 13

ResultSet class, 3.5.1, 13

SQLException class, 13

StatelessConnectionPool class, 13

Statement class, 13

Stream class, 13

Subscription class, 13

Timestamp class, 13

Client Result Cache, 12.8

hint, 12.8

Clob class, 13

methods, 13

CLOBs

external data type, 5.3.1.7

CODE OTT parameter, 8.4.3.3

collections

working with, 4.9

committing a transaction, 3.7

complex object retrieval

complex object, 4.8

depth level, 4.8

implementing, 4.8.1

overview, 4.8

prefetch limit, 4.8

root object, 4.8

complex objects, 4.8

prefetching, 4.8.2

retrieving, 4.8.1

CONFIG OTT parameter, 8.4.3.4

configuration files

and the OTT utility, 8.4

connecting to a database, 3.1

Connection class, 13

methods, 13

connection pool

createConnectionPool method, 3.2.1.1

creating, 3.2.1, 3.2.1.1

connection pooling, 3.2

transparent application failover, 12.1.3

ConnectionPool class, 13

methods, 13

Consumer class, 13

methods, 13

control statements, 1.2.2

D

data buffering, 12.3

data conversion

Date, 5.4.2

DATE data type, 5.4.2

internal data type, 5.4, 5.4

Interval, 5.4.2

INTERVAL data type, 5.4.2

LOB data type, 5.4.1

LOBs, 5.4.1

Timestamp, 5.4.2

TIMESTAMP data type, 5.4.2

data type

AnyData, 13

external data type, 5.1, 5.3

internal data type, 5.2

internal data types, 5.1

OTT mappings, 8.6

overview, 5.1

data types, 5

database

connecting to, 3.1

database resident connection pooling, 3.2.3

administration, 3.2.3.1

using, 3.2.3.2

DATE

external data type, 5.3.1.8

data conversion, 5.4.2

Date class, 13

methods, 13

usage examples, 13

DDL statements

executing, 3.3

depth level, 4.8

DML statements

executing, 3.3

E

elements, 1.1.4

embedded objects, 4.2.1

creating, 4.2.1

fetching, 4.9.1

prefetching, 4.9.1

Environment class, 13

methods, 13

ERRTYPE OTT parameter, 8.4.3.6

examples

Date class, 13

IntervalDS class, 13

IntervalYM class, 13

Number class, 13

exception handling, 3.9

executing SQL queries, 3.5

executing statements dynamically, 3.6

external data type, 5.3.1

BFILE, 5.3.1.1

BLOB, 5.3.1.4

CHAR, 5.3.1.5

CHARZ, 5.3.1.6

CLOB, 5.3.1.7

DATE, 5.3.1.8

FLOAT, 5.3.1.9

INTEGER, 5.3.1.10

INTERVAL DAY TO SECOND, 5.3.1.11

INTERVAL YEAR TO MONTH, 5.3.1.12

LONG, 5.3.1.13

LONG RAW, 5.3.1.14

LONG VARCHAR, 5.3.1.15

LONG VARRAW, 5.3.1.16

NCLOB, 5.3.1.17

NUMBER, 5.3.1.18

OCCI BFILE, 5.3.1.19

OCCI BLOB, 5.3.1.20

OCCI BYTES, 5.3.1.21

OCCI CLOB, 5.3.1.22

OCCI DATE, 5.3.1.23

OCCI INTERVALDS, 5.3.1.24

OCCI INTERVALYM, 5.3.1.25

OCCI NUMBER, 5.3.1.26

OCCI POBJECT, 5.3.1.27

OCCI REF, 5.3.1.28

OCCI REFANY, 5.3.1.29

OCCI STRING, 5.3.1.29

OCCI TIMESTAMP, 5.3.1.31

OCCI VECTOR, 5.3.1.32

RAW, 5.3.1.33

REF, 5.3.1.34

ROWID, 5.3.1.35

STRING, 5.3.1.36

TIMESTAMP, 5.3.1.37

TIMESTAMP WITH LOCAL TIME ZONE, 5.3.1.38

TIMESTAMP WITH TIME ZONE, 5.3.1.39

UNSIGNED INT, 5.3.1.40

VARCHAR, 5.3.1.41

VARCHAR2, 5.3.1.41

VARNUM, 5.3.1.43

VARRAW, 5.3.1.44

F

fault diagnosability, 12.7

Fault Diagnosability

disabling, 12.7.3

fields

IntervalDS class, 13

IntervalYM class, 13

Timestamp fields, 13

FLOAT

external data type, 5.3.1.9

H

HFILE OTT parameter, 8.4.3.7

I

index-organized table, 5.2.2

Instant Client, 2.4

benefits, 2.4.1

connection names, 2.4.6

database connection, 2.4.6

environment variables, 2.4.7

Solaris, 2.4.7

Windows, 2.4.7

installation, 2.4.2

libraries, 2.4.4

Data Shared Library, 2.4.5

patching, 2.4.4

regenerating, 2.4.5

patching libraries, 2.4.4

SDK, 2.4.2.1.1

using, 2.4.3

Instant Client Light (English), 2.5

character sets, 2.5.1

errors, 2.5.1

globalization settings, 2.5.1

installation, 2.5.3

Client Admin Install, 2.5.3.2

Oracle Universal Installer, 2.5.3.3

OTN download, 2.5.3.1

using, 2.5.2

INTEGER

external data type, 5.3.1.10

internal data type, 5.2

CHAR, 5.2.1

LONG, 5.2.1

LONG RAW, 5.2.1

RAW, 5.2.1

VARCHAR2, 5.2.1

INTERVAL DAY TO SECOND

external data type, 5.3.1.11

INTERVAL YEAR TO MONTH

external data type, 5.3.1.12

IntervalDS class, 13

fields, 13

methods, 13

usage examples, 13

IntervalYM class, 13

fields, 13

methods, 13

usage examples, 13

INTYPE file

structure of, 8.5.2

INTYPE OTT parameter, 8.4.3.8

L

Listener class, 13

methods, 13

LOBs

external data type

data conversion, 5.4.1

LONG

external data type, 5.3.1.13

LONG RAW

external data type, 5.3.1.14

LONG VARCHAR

external data type, 5.3.1.15

M

manipulating object attributes, 4.7.3

Map class, 13

methods, 13, 13

Message class, 13

methods, 13

metadata

argument and result attributes, 6.3.12

attribute groupings, 6.2

argument and result attributes, 6.2

collection attributes, 6.2

column attributes, 6.2

database attributes, 6.2

list attributes, 6.2

package attributes, 6.2

parameter attributes, 6.2, 6.2

procedure, function, and subprogram attributes, 6.2

schema attributes, 6.2

sequence attributes, 6.2

synonym attributes, 6.2

table and view attributes, 6.2

type attribute attributes, 6.2

type attributes, 6.2

type method attributes, 6.2

attributes, 6.3

code example, 6.2.1

collection attributes, 6.3.8

column attributes, 6.3.11

database attributes, 6.3.15

describing database objects, 6.2

list attributes, 6.3.13

overview, 6.1

package attributes, 6.3.4

parameter attributes, 6.3.1

procedure, function, and subprogram attributes, 6.3.3

schema attributes, 6.3.14

sequence attributes, 6.3.10

synonym attributes, 6.3.9

table and view attributes, 6.3.2

type attribute attributes, 6.3.6

type attributes, 6.3.5

type methods attributes, 6.3.7

MetaData class, 13

methods, 13

methods, 1.5

Agent methods, 13

AnyData methods, 13

BatchSQLException methods, 13

Bfile methods, 13

Blob methods, 13

Bytes methods, 13

Clob methods, 13

Connection methods, 13

ConnectionPool methods, 13

Consumer methods, 13

createConnection method, 3.1.2, 3.1.2

createConnectionPool method, 3.2.1.1

createEnvironment method, 3.1.1

createProxyConnection method, 3.2.1.2, 3.2.1.2

createStatement method, 3.3.1

Date methods, 13

Environment class, 13

execute method, 3.3.2

executeArrayUpdate method, 3.3.2, 12.3.2

executeQuery method, 3.3.2

IntervalDS methods, 13

IntervalYM class, 13

Listener methods, 13

Map methods, 13, 13

Message methods, 13

MetaData class, 13

NotifyResult methods, 13

Number class, 13

PObject methods, 13

Producer methods, 13

Ref methods, 13

RefAny methods, 13

ResultSet methods, 13

setDataBuffer method, 12.3.1

SQLException methods, 13

StatelessConnectionPool, 13

Statement, 13

Stream methods, 13

Subscription methods, 13

terminateConnection method, 3.1.2, 3.1.2

terminateEnvironment method, 3.1.2

terminateStatement method, 3.3.4

Timestamp methods, 13

modifying rows iteratively, 12.5

N

navigational access

overview, 4.7

NCLOBs

external data type, 5.3.1.17

NEEDS_STREAM_DATA status, 3.6.1, 3.6.1.5

nonprocedural elements, 1.1.4

nonreferenceable objects, 4.2.1

NotifyResult class, 13

methods, 13

nullness, 4.9.2

NUMBER

external data type, 5.3.1.18

Number class, 13

methods, 13

usage examples, 13

O

object cache, 4.4.2.1, 4.4.2.3

flushing, 4.4.2.4

object mode, 4.4.2.1

object programming

overview, 4.1

using OCCI, 4

object references

using, 4.10

P

parameterized statements, 3.4.2

performance

optimizing

executeArrayUpdate method, 12.3.2

setDataBuffer method, 12.3.1

performance tuning, 12

application managed data buffering, 12.3

array fetch using next() method, 12.4

connection sharing, 12.2

data buffering, 12.3

reading and writing multiple LOBs, 7.4.5

shared server environments, 12.2.1

thread safety, 12.2.1

transparent application failover, 12.1

persistent objects, 4.2, 4.2.1

creating, 4.3.1

standalone objects, 4.2.1

types

embedded objects, 4.2.1

nonreferenceable objects, 4.2.1

referenceable objects, 4.2.1

standalone objects, 4.2.1

pinning objects, 4.4.2.2, 4.7.2

PL/SQL

out bind variables, 1.3

overview, 1.3

PObject class, 13

methods, 13

prefetch count

set, 3.5.3

prefetch limit, 4.8

PREPARED status, 3.6.1, 3.6.1.2

procedural elements, 1.1.4

Producer class, 13

methods, 13

proxy connections, 3.2.1.2

using createProxyConnection method, 3.2.1.2

Q

queries, 1.2.4

how to specify, 3.5.2

R

RAW

external data type, 5.3.1.33, 5.3.1.33

REF

external data type, 5.3.1.34

retrieving a reference to an object

Ref class, 13

methods, 13

RefAny class, 13

methods, 13

referenceable objects, 4.2.1

relational programming

using OCCI, 3

RESULT_SET_AVAILABLE status, 3.6.1, 3.6.1.3

ResultSet class, 3.5.1, 13

methods, 13

root object, 4.8

ROWID

external data type, 5.3.1.35

rows

iterative modification, 12.5

modify, 12.5

S

SCHEMA_NAMES OTT parameter, 8.4.3.12

shared connections

using, 12.2

shared server environments

application-provided serialization, 12.2.3.2

automatic serialization, 12.2.3.1

concurrency, 12.2.3.2

thread safety, 12.2.1

implementing, 12.2.2

SQL statements

control statements, 1.2.2

DML statements, 1.2.3

processing of, 1.2

queries, 1.2.4

types

callable statements, 3.4, 3.4.3

parameterized statements, 3.4, 3.4.2

standard statements, 3.4, 3.4.1

SQLException class, 13

methods, 13

sqlnet.ora, 12.7.3

standalone objects, 4.2.1

creating, 4.2.1

standard statements, 3.4.1

StatelessConnectionPool class, 13

methods, 13

statement caching, 3.8

Statement class, 13

methods, 13

statement handles

creating, 3.3.1, 3.3.1, 3.3.2

reusing, 3.3.3

terminating, 3.3.4

status

NEEDS_STREAM_DATA, 3.6.1, 3.6.1.5

PREPARED, 3.6.1, 3.6.1.2

RESULT_SET_AVAILABLE, 3.6.1, 3.6.1.3

STREAM_DATA_AVAILABLE, 3.6.1, 3.6.1.6

UNPREPARED, 3.6.1, 3.6.1.1

UPDATE_COUNT_AVAILABLE, 3.6.1, 3.6.1.4

Stream class, 13

methods, 13

STREAM_DATA_AVAILABLE status, 3.6.1, 3.6.1.6

streamed reads, 3.4.4

streamed writes, 3.4.4

STRING

external data type, 5.3.1.36

Subscription class, 13

methods, 13

substitutability, 4.12.1

T

table

index-organized, 5.2.2

thread safety, 12.2.1

implementing, 12.2.2

TIMESTAMP

external data type, 5.3.1.37

Timestamp class

methods, 13

TIMESTAMP WITH LOCAL TIME ZONE

external data type, 5.3.1.38

TIMESTAMP WITH TIME ZONE

external data type, 5.3.1.39

transient objects, 4.2, 4.2.2

creating, 4.2.2, 4.3.1

TRANSITIVE OTT parameter, 8.4.3.13

transparent application failover, 12.1

connection pooling, 12.1.3

objects, 12.1.2

using, 12.1.1

type inheritance, 4.12, 4.12.3, 4.12.4

U

UNPREPARED status, 3.6.1, 3.6.1.1

UNSIGNED INT

external data type, 5.3.1.40

UPDATE_COUNT_AVAILABLE status, 3.6.1, 3.6.1.4

USERID OTT parameter, 8.4.3.15, 8.4.3.16

V

values

in context of this document, 4.2.3

in object applications, 4.2.3

VARCHAR

external data type, 5.3.1.41

VARCHAR2

external data type, 5.3.1.41

VARNUM

external data type, 5.3.1.43

VARRAW

external data type, 5.3.1.16, 5.3.1.44

X

XA library, 11