Skip Headers
Oracle® C++ Call Interface Programmer's Guide
10g Release 2 (10.2)

Part Number B14294-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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
see also REF
Object Type Translator utility
see OTT utility
object types, 1.5
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.4
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, 4.7.2
recording database changes, 4.7.6
runtime environment, 1.5.2
transparent application failover, 11.2.2
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, 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
Data 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, 12
SQLException class, 12
StatelessConnectionPool class, 12
Statement class, 12
Stream class, 12
Subscription class, 12
Timestamp class, 12
OCCI environment
connection pool, 3.2.1
creating, 3.1.1, 3.1.1
opening a connection, 3.1.1, 3.1.2
scope, 3.1.1, 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
OTT parameter TRANSITIVE, 7.4.3.13
OTT parameters
CASE, 7.4.3.2
CODE, 7.4.3.3
CONFIG, 7.4.3.4
ERRTYPE, 7.4.3.6
HFILE, 7.4.3.7
INTYPE, 7.4.3.8
OUTTYPE, 7.4.3.11
SCHEMA_NAMES, 7.4.3.12
USERID, 7.4.3.15, 7.4.3.16
where they appear, 7.4.4
OTT utility
benefits, 1.5.5
creating types in the database, 7.3
default name mapping, 7.6.1
description, 1.5.5
parameters, 7.4.3
using, 7.2
out bind variables, 1.3
OUTTYPE OTT parameter, 7.4.3.11

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