Index

A

ADR 12.8
- ADRC utility 12.8.2
- base location 12.8.1
ADRCI 12.8, 12.8.2
ADR Command Interpreter 12.8
Agent class 13.3
- methods 13.3
AnyData class 13.4
- methods 13.4
- supported data type 13.4
- usage examples 13.4
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.8
automatic serialization 12.2.3.1

B

BatchSQLException
- methods 13.5
BatchSQLException class 13.5
Bfile class 13.6
- methods 13.6
BFILEs
- external data type 5.3.1.1
bind operations
- in bind operations 1.4
- out bind operations 1.4
Blob class 13.7
- methods 13.7
BLOBs
- external data type 5.3.1.4
Bytes class 13.8
- methods 13.8

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.3
- AnyData class 13.4
- BatchSQLException class 13.5
- Bfile class 13.6
- Blob class 13.7
- Bytes class 13.8
- Clob class 13.9
- Connection class 13.10
- ConnectionPool class 13.11
- Consumer class 13.12
- Date class 13.13
- Environment class 13.14
- IntervalDS class 13.15
- IntervalYM class 13.16
- Listener class 13.17
- Map class 13.18
- Message class 13.19
- Metadata class 13.20
- NotifyResult class 13.21
- Number class 13.22
- PObject class 13.23
- Producer class 13.24
- RefAny class 13.26
- Ref class 13.25
- ResultSet class 3.5.1, 13.27
- SQLException class 13.28
- StatelessConnectionPool class 13.29
- Statement class 13.30
- Stream class 13.31
- Subscription class 13.32
- Timestamp class 13.33
Client Result Cache 12.9
- hint 12.9
Clob class 13.9
- methods 13.9
CLOBs
- external data type 5.3.1.7
CODE OTT parameter 8.4.3.3
collections
- working with 4.9
committing a transaction 3.8
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.10
- methods 13.10
connection pool
- createConnectionPool method 3.2.1.1
- creating 3.2.1, 3.2.1.1
ConnectionPool class 13.11
- methods 13.11
connection pooling 3.2
- transparent application failover 12.1.3
Consumer class 13.12
- methods 13.12
control statements 1.2.2

D

database
- connecting to 3.1
database resident connection pooling 3.2.3
- administration 3.2.3.1
- using 3.2.3.2
data buffering 12.3
data conversion
- Date 5.4.2
- DATE data type 5.4.2
- internal data type 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.4
- 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
DATE
- external data type 5.3.1.8
  - data conversion 5.4.2
Date class 13.13
- methods 13.13
- usage examples 13.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.14
- methods 13.14
ERRTYPE OTT parameter 8.4.3.6
examples
- Date class 13.13
- IntervalDS class 13.15
- IntervalYM class 13.16
- Number class 13.22
exception handling 3.10
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.8
Fault Diagnosability
- disabling 12.8.3
fields
- IntervalDS class 13.15
- IntervalYM class 13.16
- Timestamp fields 13.33
FLOAT
- external data type 5.3.1.9

H

HFILE OTT parameter 8.4.3.7

I

identity column metadata 6.2
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
INTERVAL DAY TO SECOND
- external data type 5.3.1.11
IntervalDS class 13.15
- fields 13.15
- methods 13.15
- usage examples 13.15
INTERVAL YEAR TO MONTH
- external data type 5.3.1.12
IntervalYM class 13.16
- fields 13.16
- methods 13.16
- usage examples 13.16
INTYPE file
- structure of 8.5.2
INTYPE OTT parameter 8.4.3.8

L

Listener class 13.17
- methods 13.17
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.18
- methods 13.18, 13.18.1
Message class 13.19
- methods 13.19
metadata
- argument and result attributes 6.4.12
- attribute groupings 6.3
  - argument and result attributes 6.3
  - collection attributes 6.3
  - column attributes 6.3
  - database attributes 6.3
  - list attributes 6.3
  - package attributes 6.3
  - parameter attributes 6.3
  - procedure, function, and subprogram attributes 6.3
  - schema attributes 6.3
  - sequence attributes 6.3
  - synonym attributes 6.3
  - table and view attributes 6.3
  - type attribute attributes 6.3
  - type attributes 6.3
  - type method attributes 6.3
- attributes 6.4
- code example 6.3.1
- collection attributes 6.4.8
- column attributes 6.4.11
- database attributes 6.4.15
- describing database objects 6.3
- list attributes 6.4.13
- overview 6.1
- package attributes 6.4.4
- parameter attributes 6.4.1
- procedure, function, and subprogram attributes 6.4.3
- schema attributes 6.4.14
- sequence attributes 6.4.10
- synonym attributes 6.4.9
- table and view attributes 6.4.2
- type attribute attributes 6.4.6
- type attributes 6.4.5
- type methods attributes 6.4.7
MetaData class 13.20
- methods 13.20
methods 1.5
- Agent methods 13.3
- AnyData methods 13.4
- BatchSQLException methods 13.5
- Bfile methods 13.6
- Blob methods 13.7
- Bytes methods 13.8
- Clob methods 13.9
- Connection methods 13.10
- ConnectionPool methods 13.11
- Consumer methods 13.12
- createConnection method 3.1.2
- createConnectionPool method 3.2.1.1
- createEnvironment method 3.1.1
- createProxyConnection method 3.2.1.2
- createStatement method 3.3.1
- Date methods 13.13
- Environment class 13.14
- executeArrayUpdate method 3.3.2, 12.3.2
- execute method 3.3.2
- executeQuery method 3.3.2
- IntervalDS methods 13.15
- IntervalYM class 13.16
- Listener methods 13.17
- Map methods 13.18, 13.18.1
- Message methods 13.19
- MetaData class 13.20
- NotifyResult methods 13.21
- Number class 13.22
- PObject methods 13.23
- Producer methods 13.24
- RefAny methods 13.26
- Ref methods 13.25
- ResultSet methods 13.27
- setDataBuffer method 12.3.1
- SQLException methods 13.28
- StatelessConnectionPool 13.29
- Statement 13.30
- Stream methods 13.31
- Subscription methods 13.32
- terminateConnection method 3.1.2
- terminateEnvironment method 3.1.2
- terminateStatement method 3.3.4
- Timestamp methods 13.33
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.21
- methods 13.21
nullness 4.9.2
NUMBER
- external data type 5.3.1.18
Number class 13.22
- methods 13.22
- usage examples 13.22

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
- see also REF 4.7.1
- using 4.10
objects
- access using SQL 4.6.1
- attributes 1.5
- client-side 1.5.1
- dirty 4.7.5
- environment 1.5.2
- flushing 4.7.4
- freeing 4.10
- in OCCI 4.2
- inserting 4.6.2
- interfaces 1.5.3
  - associative 1.5.3
  - navigational 1.5.3
- manipulating attributes 4.7.3
- marking 4.7.4
- Metadata Class 1.5.5
- methods 1.5
- modifying 4.6.2
- object cache 1.5.1
- object types 1.5
- pinned 4.7.2
- pinning 4.4.2.2, 4.7.2
- recording database changes 4.7.6
- run-time environment 1.5.2
- transparent application failover 12.1.2
object types 1.5
Object Type Translator utility
- see OTT utility 1.5
OCCI
- benefits 1.1.1
- building applications 1.1.2
- functionality 1.1.3
- object mode 4.4.2.1
- overview 1.1
- special SQL terms 1.4
OCCI classes
- Agent class 13.3
- AnyData class 13.4
- BatchSQLException class 13.5
- Bfile class 13.6
- Blob class 13.7
- Bytes class 13.8
- Clob class 13.9
- Connection class 13.10
- ConnectionPool class 13.11
- Consumer class 13.12
- Data class 13.13
- Environment class 13.14
- IntervalDS class 13.15
- IntervalYM class 13.16
- Listener class 13.17
- Map class 13.18
- Message class 13.19
- MetaData class 13.20
- NotifyResult class 13.21
- Number class 13.22
- PObject class 13.23
- Producer class 13.24
- RefAny class 13.26
- Ref class 13.25
- ResultSet class 13.27
- SQLException class 13.28
- StatelessConnectionPool class 13.29
- Statement class 13.30
- Stream class 13.31
- Subscription class 13.32
- Timestamp class 13.33
OCCI environment
- connection pool 3.2.1
- creating 3.1.1
- opening a connection 3.1.1, 3.1.2
- scope 3.1.1
- terminating 3.1, 3.1.1
OCCI program
- example of 4.13
OCCI program development 4.4
- operational flow 4.4.2
- program structure 4.4.1
OCCI types
- data conversion 5.1.1
optimizing performance 3.5.3
- setting prefetch count 3.5.3
Oracle Connection Manager in Traffic Director Mode 12.6
OTT parameters
- CASE 8.4.3.2
- CODE 8.4.3.3
- CONFIG 8.4.3.4
- ERRTYPE 8.4.3.6
- HFILE 8.4.3.7
- INTYPE 8.4.3.8
- OUTTYPE 8.4.3.11
- SCHEMA_NAMES 8.4.3.12
- USERID 8.4.3.15, 8.4.3.16
- where they appear 8.4.4
OTT parameter TRANSITIVE 8.4.3.13
OTT utility
- benefits 1.5.6
- creating types in the database 8.3
- default name mapping 8.6.1
- description 1.5.6
- parameters 8.4.3
- using 8.2
out bind variables 1.3
OUTTYPE OTT parameter 8.4.3.11

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
- 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
pluggable databases
- OCCI support for 3.1.3
PObject class 13.23
- methods 13.23
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.24
- methods 13.24
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
REF
- external data type 5.3.1.34
- retrieving a reference to an object 4.7.1
RefAny class 13.26
- methods 13.26
Ref class 13.25
- methods 13.25
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.27
- methods 13.27
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
SQLException class 13.28
- methods 13.28
sqlnet.ora 12.8.3
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
standalone objects 4.2.1
- creating 4.2.1
standard statements 3.4.1
StatelessConnectionPool class 13.29
- methods 13.29
statement caching 3.9
Statement class 13.30
- methods 13.30
statement handles
- creating 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_DATA_AVAILABLE status 3.6.1, 3.6.1.6
Stream class 13.31
- methods 13.31
streamed reads 3.4.4
streamed writes 3.4.4
STRING
- external data type 5.3.1.36
Subscription class 13.32
- methods 13.32
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.33
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