1. Index

Index

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

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