Index

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

A

Agent class, 12

methods, 12

AnyData class, 12

methods, 12

supported datatypes, 12

usage examples, 12

application managed data buffering, 11.4

application-provided serialization, 11.3.3.2

associative access

overview, 4.6

atomic null, 4.9.2

attributes, 1.5

automatic serialization, 11.3.3.1

B

BatchSQLException

methods, 12

BatchSQLException class, 12

Bfile class, 12

methods, 12

BFILEs

external datatype, 5.3.1.1

bind operations

in bind operations, 1.4

out bind operations, 1.4

Blob class, 12

methods, 12

BLOBs

external datatype, 5.3.1.4

Bytes class, 12

methods, 12

C

callable statements, 3.4.3

with arrays as parameters, 3.4.3.1

CASE OTT parameter, 7.4.3.2

CHAR

external datatype, 5.3.1.5

classes

Agent class, 12

AnyData class, 12

BatchSQLException class, 12

Bfile class, 12

Blob class, 12

Bytes class, 12

Clob class, 12

Connection class, 12

ConnectionPool class, 12

Consumer class, 12

Date class, 12

Environment class, 12

IntervalDS class, 12

IntervalYM class, 12

Listener class, 12

Map class, 12

Message class, 12

Metadata class, 12

NotifyResult class, 12

Number class, 12

PObject class, 12

Producer class, 12

Ref class, 12

RefAny class, 12

ResultSet class, 3.5.1, 12

SQLException class, 12

StatelessConnectionPool class, 12

Statement class, 12

Stream class, 12

Subscription class, 12

Timestamp class, 12

Clob class, 12

methods, 12

CLOBs

external datatype, 5.3.1.7

CODE OTT parameter, 7.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, 7.4.3.4

configuration files

and the OTT utility, 7.4

connecting to a database, 3.1

Connection class, 12

methods, 12

connection pool

createConnectionPool method, 3.2.1.1

creating, 3.2.1, 3.2.1.1

connection pooling, 3.2

transparent application failover, 11.2.3

ConnectionPool class, 12

methods, 12

Consumer class, 12

methods, 12

control statements, 1.2.2

D

data buffering, 11.4

data conversions

Date, 5.4.2

DATE datatype, 5.4.2

internal datatypes, 5.4, 5.4

Interval, 5.4.2

INTERVAL datatypes, 5.4.2

LOB datatype, 5.4.1

LOBs, 5.4.1

Timestamp, 5.4.2

TIMESTAMP datatypes, 5.4.2

database

connecting to, 3.1

datatypes, 5

AnyData, 12

OTT mappings, 7.6

overview, 5.1

types

external datatypes, 5.1, 5.3

internal datatypes, 5.1, 5.2

DATE

external datatype, 5.3.1.8

data conversion, 5.4.2

Date class, 12

methods, 12

usage examples, 12

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

methods, 12

ERRTYPE OTT parameter, 7.4.3.6

examples

Date class, 12

IntervalDS class, 12

IntervalYM class, 12

Number class, 12

exception handling, 3.9

executing SQL queries, 3.5

executing statements dynamically, 3.6

external datatypes, 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

fields

IntervalDS class, 12

IntervalYM class, 12

Timestamp fields, 12

FLOAT

external datatype, 5.3.1.9

H

HFILE OTT parameter, 7.4.3.7

I

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 datatype, 5.3.1.10

internal datatypes, 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 datatype, 5.3.1.11

INTERVAL YEAR TO MONTH

external datatype, 5.3.1.12

IntervalDS class, 12

fields, 12

methods, 12

usage examples, 12

IntervalYM class, 12

fields, 12

methods, 12

usage examples, 12

INTYPE file

structure of, 7.5.2

INTYPE OTT parameter, 7.4.3.8

L

Listener class, 12

methods, 12

LOBs

external datatype

data conversion, 5.4.1

LONG

external datatype, 5.3.1.13

LONG RAW

external datatype, 5.3.1.14

LONG VARCHAR

external datatype, 5.3.1.15

M

manipulating object attributes, 4.7.3

Map class, 12

methods, 12

Message class, 12

methods, 12

metadata

code example, 6.2.1

describing database objects, 6.2

overview, 6.1

MetaData class, 12

methods, 12

methods, 1.5

Agent methods, 12

AnyData methods, 12

BatchSQLException methods, 12

Bfile methods, 12

Blob methods, 12

Bytes methods, 12

Clob methods, 12

Connection methods, 12

ConnectionPool methods, 12

Consumer methods, 12

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

Environment class, 12

execute method, 3.3.2

executeArrayUpdate method, 3.3.2, 11.4.2

executeQuery method, 3.3.2

executeUpdate method, 3.3.2

IntervalDS methods, 12

IntervalYM class, 12

Listener methods, 12

Map methods, 12

Message methods, 12

MetaData class, 12

NotifyResult methods, 12

Number class, 12

PObject methods, 12

Producer methods, 12

Ref methods, 12

RefAny methods, 12

ResultSet methods, 12

setDataBuffer method, 11.4.1

SQLException methods, 12

StatelessConnectionPool, 12

Statement, 12

Stream methods, 12

Subscription methods, 12

terminateConnection method, 3.1.2, 3.1.2

terminateEnvironment method, 3.1.2

terminateStatement method, 3.3.4

Timestamp methods, 12

modifying rows iteratively, 11.6

N

navigational access

overview, 4.7

NCLOBs

external datatype, 5.3.1.17

NEEDS_STREAM_DATA status, 3.6.1, 3.6.1.5

new features

Oracle Database 10g Release 1 (10.1), Preface

Oracle Database 10g Release 2 (10.2), Preface

nonprocedural elements, 1.1.4

nonreferenceable objects, 4.2.1

NotifyResult class, 12

methods, 12

nullness, 4.9.2

NUMBER

external datatype, 5.3.1.18

Number class, 12

methods, 12

usage examples, 12

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

setDataBuffer method, 11.4.1

performance tuning

application managed data buffering, 11.4

array fetch using next() method, 11.5

data buffering, 11.4

performance tunning, 11

connection sharing, 11.3

reading and writing multiple LOBs, 11.1

shared server environments, 11.3.1

thread safety, 11.3.1

transparent application failover, 11.2

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

methods, 12

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

methods, 12

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 datatype, 5.3.1.33, 5.3.1.33

REF

external datatype, 5.3.1.34

retrieving a reference to an object

Ref class, 12

methods, 12

RefAny class, 12

methods, 12

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

methods, 12

root object, 4.8

ROWID

external datatype, 5.3.1.35

rows

iterative modification, 11.6

modify, 11.6

S

SCHEMA_NAMES OTT parameter, 7.4.3.12

shared connections

using, 11.3

shared server environments

application-provided serialization, 11.3.3.2

automatic serialization, 11.3.3.1

concurrency, 11.3.3.2

thread safety, 11.3.1

implementing, 11.3.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, 12

methods, 12

standalone objects, 4.2.1

creating, 4.2.1

standard statements, 3.4.1

StatelessConnectionPool class, 12

methods, 12

statement caching, 3.8

Statement class, 12

methods, 12

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

methods, 12

STREAM_DATA_AVAILABLE status, 3.6.1, 3.6.1.6

streamed reads, 3.4.4

streamed writes, 3.4.4

STRING

external datatype, 5.3.1.36

Subscription class, 12

methods, 12

substitutability, 4.12.1

T

thread safety, 11.3.1

implementing, 11.3.2

TIMESTAMP

external datatype, 5.3.1.37

Timestamp class

methods, 12

TIMESTAMP WITH LOCAL TIME ZONE

external datatype, 5.3.1.38

TIMESTAMP WITH TIME ZONE

external datatype, 5.3.1.39

transient objects, 4.2, 4.2.2

creating, 4.2.2, 4.3.1

TRANSITIVE OTT parameter, 7.4.3.13

transparent application failover, 11.2

connection pooling, 11.2.3

objects, 11.2.2

using, 11.2.1

type inheritance, 4.12, 4.12.3, 4.12.4

U

UNPREPARED status, 3.6.1, 3.6.1.1

UNSIGNED INT

external datatype, 5.3.1.40

UPDATE_COUNT_AVAILABLE status, 3.6.1, 3.6.1.4

USERID OTT parameter, 7.4.3.15, 7.4.3.16

V

values

in context of this document, 4.2.3

in object applications, 4.2.3

VARCHAR

external datatype, 5.3.1.41

VARCHAR2

external datatype, 5.3.1.41

VARNUM

external datatype, 5.3.1.43

VARRAW

external datatype, 5.3.1.16, 5.3.1.44

X

XA library, 10