Index

A

ADR 1
- ADRC utility 1
- base location 1
ADRCI 1, 2
ADR Command Interpreter 1
Agent class 1
- methods 1
AnyData class 1
- methods 1
- supported data type 1
- usage examples 1
application managed data buffering 1
application-provided serialization 1
associative access
- overview 1
atomic null 1
attributes 1
automatic diagnostic repository (ADR) 1
automatic serialization 1

B

BatchSQLException
- methods 1
BatchSQLException class 1
Bfile class 1
- methods 1
BFILEs
- external data type 1
bind operations
- in bind operations 1
- out bind operations 1
Blob class 1
- methods 1
BLOBs
- external data type 1
Bytes class 1
- methods 1

C

callable statements 1
- with arrays as parameters 1
CASE OTT parameter 1
CHAR
- external data type 1
classes
- Agent class 1
- AnyData class 1
- BatchSQLException class 1
- Bfile class 1
- Blob class 1
- Bytes class 1
- Clob class 1
- Connection class 1
- ConnectionPool class 1
- Consumer class 1
- Date class 1
- Environment class 1
- IntervalDS class 1
- IntervalYM class 1
- Listener class 1
- Map class 1
- Message class 1
- Metadata class 1
- NotifyResult class 1
- Number class 1
- PObject class 1
- Producer class 1
- RefAny class 1
- Ref class 1
- ResultSet class 1, 2
- SQLException class 1
- StatelessConnectionPool class 1
- Statement class 1
- Stream class 1
- Subscription class 1
- Timestamp class 1
Client Result Cache 1
- hint 1
Clob class 1
- methods 1
CLOBs
- external data type 1
CODE OTT parameter 1
collections
- working with 1
committing a transaction 1
complex object retrieval
- complex object 1
- depth level 1
- implementing 1
- overview 1
- prefetch limit 1
- root object 1
complex objects 1
- prefetching 1
- retrieving 1
CONFIG OTT parameter 1
configuration files
- and the OTT utility 1
connecting to a database 1
Connection class 1
- methods 1
connection pool
- createConnectionPool method 1
- creating 1, 2
ConnectionPool class 1
- methods 1
connection pooling 1
- transparent application failover 1
Consumer class 1
- methods 1
control statements 1

D

database
- connecting to 1
database resident connection pooling 1
- administration 1
- using 1
data buffering 1
data conversion
- Date 1
- DATE data type 1
- internal data type 1
- Interval 1
- INTERVAL data type 1
- LOB data type 1
- LOBs 1
- Timestamp 1
- TIMESTAMP data type 1
data type
- AnyData 1
- external data type 1, 2
- internal data type 1
- internal data types 1
- OTT mappings 1
- overview 1
data types 1
DATE
- external data type 1
  - data conversion 1
Date class 1
- methods 1
- usage examples 1
DDL statements
- executing 1
depth level 1
DML statements
- executing 1

E

elements 1
embedded objects 1
- creating 1
- fetching 1
- prefetching 1
Environment class 1
- methods 1
ERRTYPE OTT parameter 1
examples
- Date class 1
- IntervalDS class 1
- IntervalYM class 1
- Number class 1
exception handling 1
executing SQL queries 1
executing statements dynamically 1
external data type 1
- BFILE 1
- BLOB 1
- CHAR 1
- CHARZ 1
- CLOB 1
- DATE 1
- FLOAT 1
- INTEGER 1
- INTERVAL DAY TO SECOND 1
- INTERVAL YEAR TO MONTH 1
- LONG 1
- LONG RAW 1
- LONG VARCHAR 1
- LONG VARRAW 1
- NCLOB 1
- NUMBER 1
- OCCI BFILE 1
- OCCI BLOB 1
- OCCI BYTES 1
- OCCI CLOB 1
- OCCI DATE 1
- OCCI INTERVALDS 1
- OCCI INTERVALYM 1
- OCCI NUMBER 1
- OCCI POBJECT 1
- OCCI REF 1
- OCCI REFANY 1
- OCCI STRING 1
- OCCI TIMESTAMP 1
- OCCI VECTOR 1
- RAW 1
- REF 1
- ROWID 1
- STRING 1
- TIMESTAMP 1
- TIMESTAMP WITH LOCAL TIME ZONE 1
- TIMESTAMP WITH TIME ZONE 1
- UNSIGNED INT 1
- VARCHAR 1
- VARCHAR2 1
- VARNUM 1
- VARRAW 1

F

fault diagnosability 1
Fault Diagnosability
- disabling 1
fields
- IntervalDS class 1
- IntervalYM class 1
- Timestamp fields 1
FLOAT
- external data type 1

H

HFILE OTT parameter 1

I

identity column metadata 1
index-organized table 1
Instant Client 1
- benefits 1
- connection names 1
- database connection 1
- environment variables 1
  - Solaris 1
  - Windows 1
- installation 1
- libraries 1
  - Data Shared Library 1
  - patching 1
  - regenerating 1
- patching libraries 1
- SDK 1
- using 1
Instant Client Light (English) 1
- character sets 1
- errors 1
- globalization settings 1
- installation 1
  - Client Admin Install 1
  - Oracle Universal Installer 1
  - OTN download 1
- using 1
INTEGER
- external data type 1
internal data type 1
INTERVAL DAY TO SECOND
- external data type 1
IntervalDS class 1
- fields 1
- methods 1
- usage examples 1
INTERVAL YEAR TO MONTH
- external data type 1
IntervalYM class 1
- fields 1
- methods 1
- usage examples 1
INTYPE file
- structure of 1
INTYPE OTT parameter 1

L

Listener class 1
- methods 1
LOBs
- external data type
  - data conversion 1
LONG
- external data type 1
LONG RAW
- external data type 1
LONG VARCHAR
- external data type 1

M

manipulating object attributes 1
Map class 1
- methods 1, 2
Message class 1
- methods 1
metadata
- argument and result attributes 1
- attribute groupings 1
  - argument and result attributes 1
  - collection attributes 1
  - column attributes 1
  - database attributes 1
  - list attributes 1
  - package attributes 1
  - parameter attributes 1
  - procedure, function, and subprogram attributes 1
  - schema attributes 1
  - sequence attributes 1
  - synonym attributes 1
  - table and view attributes 1
  - type attribute attributes 1
  - type attributes 1
  - type method attributes 1
- attributes 1
- code example 1
- collection attributes 1
- column attributes 1
- database attributes 1
- describing database objects 1
- list attributes 1
- overview 1
- package attributes 1
- parameter attributes 1
- procedure, function, and subprogram attributes 1
- schema attributes 1
- sequence attributes 1
- synonym attributes 1
- table and view attributes 1
- type attribute attributes 1
- type attributes 1
- type methods attributes 1
MetaData class 1
- methods 1
methods 1
- Agent methods 1
- AnyData methods 1
- BatchSQLException methods 1
- Bfile methods 1
- Blob methods 1
- Bytes methods 1
- Clob methods 1
- Connection methods 1
- ConnectionPool methods 1
- Consumer methods 1
- createConnection method 1
- createConnectionPool method 1
- createEnvironment method 1
- createProxyConnection method 1
- createStatement method 1
- Date methods 1
- Environment class 1
- executeArrayUpdate method 1, 2
- execute method 1
- executeQuery method 1
- IntervalDS methods 1
- IntervalYM class 1
- Listener methods 1
- Map methods 1, 2
- Message methods 1
- MetaData class 1
- NotifyResult methods 1
- Number class 1
- PObject methods 1
- Producer methods 1
- RefAny methods 1
- Ref methods 1
- ResultSet methods 1
- setDataBuffer method 1
- SQLException methods 1
- StatelessConnectionPool 1
- Statement 1
- Stream methods 1
- Subscription methods 1
- terminateConnection method 1
- terminateEnvironment method 1
- terminateStatement method 1
- Timestamp methods 1
modifying rows iteratively 1

N

navigational access
- overview 1
NCLOBs
- external data type 1
NEEDS_STREAM_DATA status 1, 2
nonprocedural elements 1
nonreferenceable objects 1
NotifyResult class 1
- methods 1
nullness 1
NUMBER
- external data type 1
Number class 1
- methods 1
- usage examples 1

O

object cache 1, 2
- flushing 1
object mode 1
object programming
- overview 1
- using OCCI 1
object references
- see also REF 1
- using 1
objects
- access using SQL 1
- attributes 1
- client-side 1
- dirty 1
- environment 1
- flushing 1
- freeing 1
- in OCCI 1
- inserting 1
- interfaces 1
  - associative 1
  - navigational 1
- manipulating attributes 1
- marking 1
- Metadata Class 1
- methods 1
- modifying 1
- object cache 1
- object types 1
- pinned 1
- pinning 1, 2
- recording database changes 1
- run-time environment 1
- transparent application failover 1
object types 1
Object Type Translator utility
- see OTT utility 1
OCCI
- benefits 1
- building applications 1
- functionality 1
- object mode 1
- overview 1
- special SQL terms 1
OCCI classes
- Agent class 1
- AnyData class 1
- BatchSQLException class 1
- Bfile class 1
- Blob class 1
- Bytes class 1
- Clob class 1
- Connection class 1
- ConnectionPool class 1
- Consumer class 1
- Data class 1
- Environment class 1
- IntervalDS class 1
- IntervalYM class 1
- Listener class 1
- Map class 1
- Message class 1
- MetaData class 1
- NotifyResult class 1
- Number class 1
- PObject class 1
- Producer class 1
- RefAny class 1
- Ref class 1
- ResultSet class 1
- SQLException class 1
- StatelessConnectionPool class 1
- Statement class 1
- Stream class 1
- Subscription class 1
- Timestamp class 1
OCCI environment
- connection pool 1
- creating 1
- opening a connection 1, 2
- scope 1
- terminating 1, 2
OCCI program
- example of 1
OCCI program development 1
- operational flow 1
- program structure 1
OCCI types
- data conversion 1
optimizing performance 1
- setting prefetch count 1
Oracle Connection Manager in Traffic Director Mode 1
OTT parameters
- CASE 1
- CODE 1
- CONFIG 1
- ERRTYPE 1
- HFILE 1
- INTYPE 1
- OUTTYPE 1
- SCHEMA_NAMES 1
- USERID 1, 2
- where they appear 1
OTT parameter TRANSITIVE 1
OTT utility
- benefits 1
- creating types in the database 1
- default name mapping 1
- description 1
- parameters 1
- using 1
out bind variables 1
OUTTYPE OTT parameter 1

P

parameterized statements 1
performance
- optimizing
  - executeArrayUpdate method 1
  - setDataBuffer method 1
performance tuning 1
- application managed data buffering 1
- array fetch using next() method 1
- connection sharing 1
- data buffering 1
- reading and writing multiple LOBs 1
- shared server environments 1
  - thread safety 1
- thread safety 1
- transparent application failover 1
persistent objects 1, 2
- creating 1
- standalone objects 1
- types
  - embedded objects 1
  - nonreferenceable objects 1
  - referenceable objects 1
  - standalone objects 1
pinning objects 1, 2
PL/SQL
- out bind variables 1
- overview 1
pluggable databases
- OCCI support for 1
PObject class 1
- methods 1
prefetch count
- set 1
prefetch limit 1
PREPARED status 1, 2
procedural elements 1
Producer class 1
- methods 1
proxy connections 1
- using createProxyConnection method 1

Q

queries 1
- how to specify 1

R

RAW
- external data type 1
REF
- external data type 1
- retrieving a reference to an object 1
RefAny class 1
- methods 1
Ref class 1
- methods 1
referenceable objects 1
relational programming
- using OCCI 1
RESULT_SET_AVAILABLE status 1, 2
ResultSet class 1, 2
- methods 1
root object 1
ROWID
- external data type 1
rows
- iterative modification 1
- modify 1

S

SCHEMA_NAMES OTT parameter 1
shared connections
- using 1
shared server environments
- application-provided serialization 1
- automatic serialization 1
- concurrency 1
- thread safety 1
  - implementing 1
SQLException class 1
- methods 1
sqlnet.ora 1
SQL statements
- control statements 1
- DML statements 1
- processing of 1
- queries 1
- types
  - callable statements 1, 2
  - parameterized statements 1, 2
  - standard statements 1, 2
standalone objects 1
- creating 1
standard statements 1
StatelessConnectionPool class 1
- methods 1
statement caching 1
Statement class 1
- methods 1
statement handles
- creating 1, 3
- reusing 1
- terminating 1
status
- NEEDS_STREAM_DATA 1, 2
- PREPARED 1, 2
- RESULT_SET_AVAILABLE 1, 2
- STREAM_DATA_AVAILABLE 1, 2
- UNPREPARED 1, 2
- UPDATE_COUNT_AVAILABLE 1, 2
STREAM_DATA_AVAILABLE status 1, 2
Stream class 1
- methods 1
streamed reads 1
streamed writes 1
STRING
- external data type 1
Subscription class 1
- methods 1
substitutability 1

T

table
- index-organized 1
thread safety 1
- implementing 1
TIMESTAMP
- external data type 1
Timestamp class
- methods 1
TIMESTAMP WITH LOCAL TIME ZONE
- external data type 1
TIMESTAMP WITH TIME ZONE
- external data type 1
transient objects 1, 2
- creating 1, 2
TRANSITIVE OTT parameter 1
transparent application failover 1
- connection pooling 1
- objects 1
- using 1
type inheritance 1, 2, 3

U

UNPREPARED status 1, 2
UNSIGNED INT
- external data type 1
UPDATE_COUNT_AVAILABLE status 1, 2
USERID OTT parameter 1, 2

V

values
- in context of this document 1
- in object applications 1
VARCHAR
- external data type 1
VARCHAR2
- external data type 1
VARNUM
- external data type 1
VARRAW
- external data type 1, 2

X

XA library 1