Index

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

A

Agent class, 10

methods, 10

AnyData class, 10

methods, 10

application-provided serialization, 2.10.1.4.2

associative access

overview, 3.6

atomic null, 3.9.2

attributes, 1.6

automatic serialization, 2.10.1.4.1

B

Bfile class, 10

methods, 10

BFILEs

external datatype, 4.3.1.1

bind operations

in bind operations, 1.5

out bind operations, 1.5

Blob class, 10

methods, 10

BLOBs

external datatype, 4.3.1.4

Bytes class, 10

methods, 10

C

callable statements, 2.4.3

with arrays as parameters, 2.4.3.1

CASE OTT parameter, 6.4.3.2

CHAR

external datatype, 4.3.1.5

classes

Agent class, 10

AnyData class, 10

Bfile class, 10

Blob class, 10

Bytes class, 10

Clob class, 10

Connection class, 10

ConnectionPool class, 10

Consumer class, 10

Date class, 10

Environment class, 10

IntervalDS class, 10

IntervalYM class, 10

Listener class, 10

Map class, 10

Message class, 10

Metadata class, 10

NotifyResult class, 10

Number class, 10

PObject class, 10

Producer class, 10

Ref class, 10

RefAny class, 10

ResultSet class, 2.5.1, 10

SQLException class, 10

StatelessConnectionPool class, 10

Statement class, 10

Stream class, 10

Subscription class, 10

Timestamp class, 10

Clob class, 10

methods, 10

CLOBs

external datatype, 4.3.1.7

CODE OTT parameter, 6.4.3.3

collections

working with, 3.9

committing a transaction, 2.7

complex object retrieval

complex object, 3.8

depth level, 3.8

implementing, 3.8.1

overview, 3.8

prefetch limit, 3.8

root object, 3.8

complex objects, 3.8

prefetching, 3.8.2

retrieving, 3.8.1

CONFIG OTT parameter, 6.4.3.4

configuration files

and the OTT utility, 6.4

connecting to a database, 2.1

Connection class, 10

methods, 10

connection pool

createConnectionPool method, 2.2.1.1

creating, 2.2.1, 2.2.1.1

connection pooling, 2.2

ConnectionPool class, 10

methods, 10

Consumer class, 10

methods, 10

control statements, 1.3.2

D

data conversions

Date, 4.4.2

DATE datatype, 4.4.2

internal datatypes, 4.4, 4.4

Interval, 4.4.2

INTERVAL datatypes, 4.4.2

LOB datatype, 4.4.1

LOBs, 4.4.1

Timestamp, 4.4.2

TIMESTAMP datatypes, 4.4.2

database

connecting to, 2.1

datatypes, 4

OTT mappings, 6.6

overview, 4.1

types

external datatypes, 4.1, 4.3

internal datatypes, 4.1, 4.2

DATE

external datatype, 4.3.1.8

data conversion, 4.4.2

Date class, 10

methods, 10

DDL statements

executing, 2.3

depth level, 3.8

DML statements

executing, 2.3

E

embedded objects, 3.2.1

creating, 3.2.1

fetching, 3.9.1

prefetching, 3.9.1

Environment class, 10

methods, 10

ERRTYPE OTT parameter, 6.4.3.6

exception handling, 2.9

executing SQL queries, 2.5

executing statements dynamically, 2.6

external datatypes, 4.3.1

BFILE, 4.3.1.1

BLOB, 4.3.1.4

CHAR, 4.3.1.5

CHARZ, 4.3.1.6

CLOB, 4.3.1.7

DATE, 4.3.1.8

FLOAT, 4.3.1.9

INTEGER, 4.3.1.10

INTERVAL DAY TO SECOND, 4.3.1.11

INTERVAL YEAR TO MONTH, 4.3.1.12

LONG, 4.3.1.13

LONG RAW, 4.3.1.14

LONG VARCHAR, 4.3.1.15

LONG VARRAW, 4.3.1.16

NCLOB, 4.3.1.17

NUMBER, 4.3.1.18

OCCI BFILE, 4.3.1.19

OCCI BLOB, 4.3.1.20

OCCI BYTES, 4.3.1.21

OCCI CLOB, 4.3.1.22

OCCI DATE, 4.3.1.23

OCCI INTERVALDS, 4.3.1.24

OCCI INTERVALYM, 4.3.1.25

OCCI NUMBER, 4.3.1.26

OCCI POBJECT, 4.3.1.27

OCCI REF, 4.3.1.28

OCCI REFANY, 4.3.1.29

OCCI STRING, 4.3.1.29

OCCI TIMESTAMP, 4.3.1.31

OCCI VECTOR, 4.3.1.32

RAW, 4.3.1.33

REF, 4.3.1.34

ROWID, 4.3.1.35

STRING, 4.3.1.36

TIMESTAMP, 4.3.1.37

TIMESTAMP WITH LOCAL TIME ZONE, 4.3.1.38

TIMESTAMP WITH TIME ZONE, 4.3.1.39

UNSIGNED INT, 4.3.1.40

VARCHAR, 4.3.1.41

VARCHAR2, 4.3.1.41

VARNUM, 4.3.1.43

VARRAW, 4.3.1.44

F

fields

Timestamp fields, 10

FLOAT

external datatype, 4.3.1.9

H

HFILE OTT parameter, 6.4.3.7

I

Instant Client, 1.2

INTEGER

external datatype, 4.3.1.10

internal datatypes, 4.2

CHAR, 4.2.1

LONG, 4.2.1

LONG RAW, 4.2.1

RAW, 4.2.1

VARCHAR2, 4.2.1

INTERVAL DAY TO SECOND

external datatype, 4.3.1.11

INTERVAL YEAR TO MONTH

external datatype, 4.3.1.12

IntervalDS class, 10

methods, 10

IntervalYM class, 10

methods, 10

INTYPE file

structure of, 6.5.2

INTYPE OTT parameter, 6.4.3.8

L

Listener class, 10

methods, 10

LOBs

external datatype

data conversion, 4.4.1

LONG

external datatype, 4.3.1.13

LONG RAW

external datatype, 4.3.1.14

LONG VARCHAR

external datatype, 4.3.1.15

M

manipulating object attributes, 3.7.3

Map class, 10

Message class, 10

methods, 10

metadata

argument and result attributes, 5.3.12

attribute groupings, 5.2

argument and result attributes, 5.2

collection attributes, 5.2

column attributes, 5.2

database attributes, 5.2

list attributes, 5.2

package attributes, 5.2

parameter attributes, 5.2, 5.2

procedure, function, and subprogram attributes, 5.2

schema attributes, 5.2

sequence attributes, 5.2

synonym attributes, 5.2

table and view attributes, 5.2

type attribute attributes, 5.2

type attributes, 5.2

type method attributes, 5.2

attributes, 5.3

code example, 5.2.1

collection attributes, 5.3.8

column attributes, 5.3.11

database attributes, 5.3.15

describing database objects, 5.2

list attributes, 5.3.13

overview, 5.1

package attributes, 5.3.4

parameter attributes, 5.3.1

procedure, function, and subprogram attributes, 5.3.3

schema attributes, 5.3.14

sequence attributes, 5.3.10

synonym attributes, 5.3.9

table and view attributes, 5.3.2

type attribute attributes, 5.3.6

type attributes, 5.3.5

type methods attributes, 5.3.7

MetaData class, 10

methods, 10, 10

methods, 1.6

Agent methods, 10

AnyData methods, 10

Bfile methods, 10

Blob methods, 10

Bytes methods, 10

Clob methods, 10

Connection methods, 10

ConnectionPool methods, 10

Consumer methods, 10

createConnection method, 2.1.2, 2.1.2

createConnectionPool method, 2.2.1.1

createEnvironment method, 2.1.1

createProxyConnection method, 2.2.1.2, 2.2.1.2

createStatement method, 2.3.1

Date methods, 10

Environment methods, 10

execute method, 2.3.2

executeArrayUpdate method, 2.3.2, 2.10.2.2

executeQuery method, 2.3.2

executeUpdate method, 2.3.2

IntervalDS methods, 10

IntervalYM methods, 10

Listener methods, 10

Message methods, 10

MetaData methods, 10, 10

NotifyResult methods, 10

Number methods, 10

PObject methods, 10

Producer methods, 10

Ref methods, 10

RefAny methods, 10

ResultSet methods, 10

setDataBuffer method, 2.10.2.1

SQLException methods, 10

StatelessConnectionPool, 10

Statement, 10

Stream methods, 10

Subscription methods, 10

terminateConnection method, 2.1.2, 2.1.2

terminateEnvironment method, 2.1.2

terminateStatement method, 2.3.4

Timestamp methods, 10

N

navigational access

overview, 3.7

NCLOBs

external datatype, 4.3.1.17

NEEDS_STREAM_DATA status, 2.6.1, 2.6.1.5

nonreferenceable objects, 3.2.1

NotifyResult class, 10

methods, 10

nullness, 3.9.2

NUMBER

external datatype, 4.3.1.18

Number class, 10

methods, 10

O

object cache, 3.4.2.1, 3.4.2.3

flushing, 3.4.2.4

object mode, 3.4.2.1

object programming

overview, 3.1

using OCCI, 3

object references

using, 3.10

see also REF

Object Type Translator utility

see OTT utility

object types, 1.6

objects

access using SQL, 3.6.1

attributes, 1.6

dirty, 3.7.5

flushing, 3.7.4

freeing, 3.10

in OCCI, 3.2

inserting, 3.6.2

manipulating attributes, 3.7.3

marking, 3.7.4

methods, 1.6

modifying, 3.6.2

object types, 1.6

pinned, 3.7.2

pinning, 3.4.2.2, 3.7.2, 3.7.2

recording database changes, 3.7.6

OCCI

advantages, 1.1.1

benefits, 1.1.1

functionality, 1.1.3

object mode, 3.4.2.1

overview, 1.1

special SQL terms, 1.5

OCCI classes

Agent class, 10

AnyData class, 10

Bfile class, 10

Blob class, 10

Bytes class, 10

Clob class, 10

Connection class, 10

ConnectionPool class, 10

Consumer class, 10

Data class, 10

Environment class, 10

IntervalDS class, 10

IntervalYM class, 10

Listener class, 10

Map class, 10

Message class, 10

MetaData class, 10

NotifyResult class, 10

Number class, 10

PObject class, 10

Producer class, 10

Ref class, 10

RefAny class, 10

ResultSet class, 10

SQLException class, 10

StatelessConnectionPool class, 10

Statement class, 10

Stream class, 10

Subscription class, 10

Timestamp class, 10

OCCI environment

connection pool, 2.2.1

creating, 2.1.1, 2.1.1

opening a connection, 2.1.1, 2.1.2

scope, 2.1.1, 2.1.1

terminating, 2.1, 2.1.1

OCCI program

example of, 3.13

OCCI program development, 3.4

operational flow, 3.4.2

program structure, 3.4.1

OCCI types

data conversion, 4.1.1

optimizing performance, 2.5.3, 2.10.2

setting prefetch count, 2.5.3

OTT parameter TRANSITIVE, 6.4.3.13

OTT parameters

CASE, 6.4.3.2

CODE, 6.4.3.3

CONFIG, 6.4.3.4

ERRTYPE, 6.4.3.6

HFILE, 6.4.3.7

INTYPE, 6.4.3.8

OUTTYPE, 6.4.3.11

SCHEMA_NAMES, 6.4.3.12

USERID, 6.4.3.15, 6.4.3.16

where they appear, 6.4.4

OTT utility

creating types in the database, 6.3

default name mapping, 6.6.1

description, 1.6.5

parameters, 6.4.3

using, 6.2

out bind variables, 1.4

OUTTYPE OTT parameter, 6.4.3.11

P

parameterized statements, 2.4.2

performance

optimizing, 2.10.2

array fetch using next method, 2.10.2.3

executeArrayUpdate method, 2.10.2.2

setDataBuffer method, 2.10.2.1

persistent objects, 3.2, 3.2.1

creating, 3.3.1

standalone objects, 3.2.1

types

embedded objects, 3.2.1

nonreferenceable objects, 3.2.1

referenceable objects, 3.2.1

standalone objects, 3.2.1

pinning objects, 3.4.2.2, 3.7.2

PL/SQL

out bind variables, 1.4

overview, 1.4

PObject class, 10

methods, 10

prefetch count

set, 2.5.3

prefetch limit, 3.8

PREPARED status, 2.6.1, 2.6.1.2

Producer class, 10

methods, 10

proxy connections, 2.2.1.2

using createProxyConnection method, 2.2.1.2

Q

queries, 1.3.4

how to specify, 2.5.2

R

RAW

external datatype, 4.3.1.33, 4.3.1.33

REF

external datatype, 4.3.1.34

retrieving a reference to an object

Ref class, 10

methods, 10

RefAny class, 10

methods, 10

referenceable objects, 3.2.1

relational programming

using OCCI, 2

RESULT_SET_AVAILABLE status, 2.6.1, 2.6.1.3

ResultSet class, 2.5.1, 10

methods, 10

root object, 3.8

ROWID

external datatype, 4.3.1.35

S

SCHEMA_NAMES OTT parameter, 6.4.3.12

shared connections

using, 2.10.1

shared server environments

application-provided serialization, 2.10.1.4.2

automatic serialization, 2.10.1.4.1

concurrency, 2.10.1.4.2

thread safety, 2.10.1.1, 2.10.1.2

implementing, 2.10.1.3

SQL statements

control statements, 1.3.2

DML statements, 1.3.3

processing of, 1.3

queries, 1.3.4

types

callable statements, 2.4, 2.4.3

parameterized statements, 2.4, 2.4.2

standard statements, 2.4, 2.4.1

SQLException class, 10

methods, 10

standalone objects, 3.2.1

creating, 3.2.1

standard statements, 2.4.1

StatelessConnectionPool class, 10

methods, 10

statement caching, 2.8

Statement class, 10

methods, 10

statement handles

creating, 2.3.1, 2.3.1, 2.3.2

reusing, 2.3.3

terminating, 2.3.4

status

NEEDS_STREAM_DATA, 2.6.1, 2.6.1.5

PREPARED, 2.6.1, 2.6.1.2

RESULT_SET_AVAILABLE, 2.6.1, 2.6.1.3

STREAM_DATA_AVAILABLE, 2.6.1, 2.6.1.6

UNPREPARED, 2.6.1, 2.6.1.1

UPDATE_COUNT_AVAILABLE, 2.6.1, 2.6.1.4

Stream class, 10

methods, 10

STREAM_DATA_AVAILABLE status, 2.6.1, 2.6.1.6

streamed reads, 2.4.4

streamed writes, 2.4.4

STRING

external datatype, 4.3.1.36

Subscription class, 10

methods, 10

substitutability, 3.12.1

T

thread safety, 2.10.1.1, 2.10.1.2

implementing, 2.10.1.3

TIMESTAMP

external datatype, 4.3.1.37

Timestamp class

methods, 10

TIMESTAMP WITH LOCAL TIME ZONE

external datatype, 4.3.1.38

TIMESTAMP WITH TIME ZONE

external datatype, 4.3.1.39

transient objects, 3.2, 3.2.2

creating, 3.2.2, 3.3.1

TRANSITIVE OTT parameter, 6.4.3.13

type inheritance, 3.12, 3.12.3, 3.12.4

U

UNPREPARED status, 2.6.1, 2.6.1.1

UNSIGNED INT

external datatype, 4.3.1.40

UPDATE_COUNT_AVAILABLE status, 2.6.1, 2.6.1.4

USERID OTT parameter, 6.4.3.15, 6.4.3.16

V

values

in context of this document, 3.2.3

in object applications, 3.2.3

VARCHAR

external datatype, 4.3.1.41

VARCHAR2

external datatype, 4.3.1.41

VARNUM

external datatype, 4.3.1.43

VARRAW

external datatype, 4.3.1.16, 4.3.1.44

X

XA library, 9