Oracle C++ Call Interface Programmer's Guide
Release 9.0.1

Part Number A89860-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

Index

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


A

application-provided serialization, 2-26
associative access
overview, 3-11
atomic nullness, 3-21
attributes, 1-9
automatic serialization, 2-25

B

Bfile class, 8-5
methods, 8-6
BFILEs
datatype, 5-3
external datatype, 4-8
bind operations
in bind operations, 1-9
out bind operations, 1-9
Blob class, 8-13
methods, 8-14
BLOBs
datatype, 5-2
external datatype, 4-8
Bytes class, 8-24
methods, 8-24

C

callable statements, 2-10
with arrays as parameters, 2-11
CASE OTT parameter, 7-91
CHAR
external datatype, 4-8
classes
Bfile class, 8-5
Blob class, 8-13
Bytes class, 8-24
Clob class, 8-27
Connection class, 8-40
ConnectionPool, 8-45
Date class, 8-51
Environment class, 8-64
IntervalDS class, 8-70
IntervalYM class, 8-83
Map class, 8-95
Metadata class, 8-97
Number class, 8-104
PObject class, 8-130
Ref class, 8-137
RefAny class, 8-144
ResultSet, 2-14
ResultSet class, 8-147
SQLException class, 8-169
Statement class, 8-171
Stream class, 8-215
summary, 8-2
Timestamp class, 8-219
Clob class, 8-27
methods, 8-28
CLOBs
datatype, 5-2
external datatype, 4-9
code
example programs, A-1
list of demonstration programs, A-1
CODE OTT parameter, 7-92
collections
working with, 3-19
committing a transaction, 2-20
complex object retrieval
complex object, 3-16
depth level, 3-16
implementing, 3-17
overview, 3-16
prefetch limit, 3-16
root object, 3-16
complex objects, 3-16
prefetching, 3-19
retrieving, 3-17
CONFIG OTT parameter, 7-92
configuration files
and the OTT utility, 7-10
connecting to a database, 2-2
Connection class, 8-40
methods, 8-40
connection pool
createConnectionPool method, 2-4
creating, 2-3, 2-4, 2-5
ConnectionPool class, 8-45
methods, 8-45
control statements, 1-6
copy semantics
internal LOBs, 5-2

D

data conversions
DATE datatype, 4-22
internal datatypes, 4-20
INTERVAL datatypes, 4-22
LOB datatype, 4-22
TIMESTAMP datatypes, 4-22
data definition language (DDL) statements, 1-5
data manipulation language (DML) statements, 1-6
database
connecting to, 2-2
datatypes, 4-1
LOBs
external LOBs, 5-3
internal LOBs, 5-2
OTT mappings, 7-16
overview, 4-2
types
external datatypes, 4-2, 4-5
internal datatypes, 4-2, 4-3
DATE
external datatype, 4-9
data conversion, 4-22
Date class, 8-51
methods, 8-52
DDL statements
executing, 2-6
depth level, 3-16
DML statements, 1-6
executing, 2-6

E

embedded objects, 3-3
creating, 3-4
fetching, 3-20
prefetching, 3-20
Environment class, 8-64
methods, 8-64
error handling, 2-20
ERRTYPE OTT parameter, 7-93
executing SQL queries, 2-13
executing statements dynamically, 2-16
external datatypes, 4-5, 4-8
BFILE, 4-8
BLOB, 4-8
CHAR, 4-8
CHARZ, 4-9
CLOB, 4-9
DATE, 4-9
FLOAT, 4-11
INTEGER, 4-11
INTERVAL DAY TO SECOND, 4-11
INTERVAL YEAR TO MONTH, 4-12
LONG, 4-12
LONG RAW, 4-13
LONG VARCHAR, 4-13
LONG VARRAW, 4-13
NCLOB, 4-13
NUMBER, 4-13
OCCI BFILE, 4-14
OCCI BLOB, 4-14
OCCI BYTES, 4-14
OCCI CLOB, 4-15
OCCI DATE, 4-15
OCCI INTERVALDS, 4-15
OCCI INTERVALYM, 4-15
OCCI NUMBER, 4-15
OCCI POBJECT, 4-15
OCCI REF, 4-16
OCCI REFANY, 4-16
OCCI STRING, 4-16
OCCI TIMESTAMP, 4-16
OCCI VECTOR, 4-16
RAW, 4-16
REF, 4-17
ROWID, 4-17
STRING, 4-17
TIMESTAMP, 4-17
TIMESTAMP WITH LOCAL TIME ZONE, 4-18
TIMESTAMP WITH TIME ZONE, 4-18
UNSIGNED INT, 4-18
VARCHAR, 4-19
VARCHAR2, 4-19
VARNUM, 4-19
VARRAW, 4-19
external LOBs
BFILE, 5-3

F

FLOAT
external datatype, 4-11
freeing objects, 3-22

H

HFILE OTT parameter, 7-93

I

INITFILE OTT parameter, 7-94
INITFUNC OTT parameter, 7-94
INTEGER
external datatype, 4-11
internal datatypes, 4-3
CHAR, 4-4
LONG, 4-4
LONG RAW, 4-4
RAW, 4-4
VARCHAR2, 4-4
internal LOBs
BLOB, 5-2
CLOB, 5-2
NCLOB, 5-2
INTERVAL DAY TO SECOND
external datatype, 4-11
INTERVAL YEAR TO MONTH
external datatype, 4-12
IntervalDS class, 8-70
methods, 8-72
IntervalYM class, 8-83
methods, 8-84
INTYPE file
structure of, 7-98
INTYPE OTT parameter, 7-94

L

LOB locators
external LOBs, 5-4
internal LOBs, 5-4
LOBs
classes, 5-4, 5-5
closing, 5-8
copy semantics
internal LOBs, 5-2
creating, 5-7
datatypes
BFILE, 5-3
BLOB, 5-2
CLOB, 5-2
NCLOB, 5-2
external datatype
data conversion, 4-22
improving read and write performance, 5-14
using getChunckSize method, 5-15
using writeChunk method, 5-15
LOB locators, 5-3, 5-4
LOB value, 5-3
inline storage, 5-4
methods, 5-4, 5-5
nonstreamed read, 5-10
nonstreamed write, 5-12
opening, 5-8
overview, 5-2
reading, 5-10
reference semantics
external LOBs, 5-3
restrictions, 5-9
streamed read, 5-13
streamed write, 5-14
types
external LOBs, 5-3
internal LOBs, 5-2
updating, 5-15
writing, 5-10
LONG
external datatype, 4-12
LONG RAW
external datatype, 4-13
LONG VARCHAR
external datatype, 4-13

M

manipulating object attributes, 3-15
Map class, 8-95
methods, 8-95
metadata
argument and result attributes, 6-21
attribute groupings, 6-4
argument and result attributes, 6-4
collection attributes, 6-4
column attributes, 6-4
database attributes, 6-5
list attributes, 6-4
package attributes, 6-4
parameter attributes, 6-4
procedure, function, and subprogram attributes, 6-4
schema attributes, 6-5
sequence attributes, 6-4
synonym attributes, 6-4
table and view attributes, 6-4
type attribute attibutes, 6-4
type attributes, 6-4
type method attributes, 6-4
attributes, 6-9
code example, 6-5
collection attributes, 6-17
column attributes, 6-20
database attributes, 6-24
describing database objects, 6-3
list attributes, 6-23
overview, 6-2
package attributes, 6-13
parameter attributes, 6-10
procedure, function, and subprogram attributes, 6-12
schema attributes, 6-24
sequence attributes, 6-19
synonym attributes, 6-19
table and view attributes, 6-11
type attribute attributes, 6-15
type attributes, 6-13
type methods attributes, 6-16
MetaData class, 8-97
methods, 8-98
methods, 1-9
Bfile methods, 8-6
Blob methods, 8-14
Bytes methods, 8-24
Clob methods, 8-28
Connection methods, 8-40
ConnectionPool methods, 8-45
createConnection method, 2-3
createConnectionPool method, 2-4
createEnvironment method, 2-3
createProxyConnection method, 2-5, 2-6
createStatement method, 2-6
Date methods, 8-52
Environment class, 8-64
execute method, 2-6
executeArrayUpdate method, 2-7, 2-28
executeQuery method, 2-6
executeUpdate method, 2-6
IntervalDS methods, 8-72
IntervalYM methods, 8-84
Map methods, 8-95
MetaData methods, 8-98
Number methods, 8-107
PObject methods, 8-130
Ref methods, 8-138
RefAny methods, 8-144, 8-148
setDataBuffer method, 2-27
SQLException methods, 8-169
Statement methods, 8-171
Stream methods, 8-215
terminateConnection method, 2-3
terminateEnvironment, 2-3
terminateStatement method, 2-8
Timestamp methods, 8-221

N

navigational access
overview, 3-13
NCLOBs
datatype, 5-2
external datatype, 4-13
NEEDS_STREAM_DATA status, 2-17, 2-19
nonreferenceable objects, 3-3
nonstreamed reads
LOBs, 5-10
nonstreamed writes
LOBs, 5-12
nullness, 3-21
NUMBER
external datatype, 4-13
Number class, 8-104
methods, 8-107

O

object cache, 3-10, 3-11
flushing, 3-11
object mode, 3-9
object programming
overview, 3-2
using OCCI, 3-1
object references
using, 3-22
see alsoREF
Object Type Translator utility
see OTT utility
object types, 1-9
objects
access using SQL, 3-12
attributes, 1-9
dirty, 3-15
flushing, 3-15
freeing, 3-22
in OCCI, 3-2
inserting, 3-12
manipulating attributes, 3-15
marking, 3-15
methods, 1-9
modifying, 3-12
object types, 1-9
pinned, 3-14
pinning, 3-10, 3-14
recording database changes, 3-15
with LOB attributes, 5-16
OCCI
advantages, 1-2
benefits, 1-2
functionality, 1-4
object mode, 3-9
overview, 1-2
special SQL terms, 1-8
OCCI classes
Bfile class, 8-5
Blob class, 8-13
Bytes class, 8-24
Clob class, 8-27
Connection class, 8-40
ConnectionPool class, 8-45
Data class, 8-51
Environment class, 8-64
IntervalDS class, 8-70
IntervalYM class, 8-83
Map class, 8-95
MetaData class, 8-97
Number class, 8-104
PObject class, 8-130
Ref class, 8-137
RefAny class, 8-144
ResultSet class, 8-147
SQLException class, 8-169
Statement class, 8-171
Stream class, 8-215
summary, 8-2
Timestamp class, 8-219
OCCI environment
connection pool, 2-3
creating, 2-2
openning a connection, 2-3
scope, 2-2
terminating, 2-2
OCCI program
example of, 3-26
OCCI program development, 3-7
operational flow, 3-8
program structure, 3-7
OCCI types
data conversion, 4-2
optimizing performance, 2-15, 2-27
setting prefetch count, 2-15
OTT parameter TRANSITIVE, 7-96
OTT parameters
CASE, 7-91
CODE, 7-92
CONFIG, 7-92
ERRTYPE, 7-93
HFILE, 7-93
INITFILE, 7-94
INITFUNC, 7-94
INTYPE, 7-94
OUTTYPE, 7-95
SCHEMA_NAMES, 7-96
USERID, 7-97
where they appear, 7-97
OTT utility
command line, 7-12
command line syntax, 7-88
creating types in the database, 7-10
default name mapping, 7-105
description, 1-11
parameters, 7-90 to 7-96
restriction, 7-107
using, 7-2
out bind variables, 1-7
OUTTYPE OTT parameter, 7-95

P

parameterized statements, 2-9
performance
optimizing, 2-27
array fetch using next method, 2-29
executeArrayUpdate method, 2-28
setDataBuffer method, 2-27
persistent objects, 3-2, 3-3
standalone objects, 3-3
types
embedded objects, 3-3
nonreferenceable objects, 3-3
referenceable objects, 3-3
standalone objects, 3-3
with LOB attributes, 5-16
pinning objects, 3-10, 3-14
PL/SQL
out bind variables, 1-7
overview, 1-7
PObject class, 8-130
methods, 8-130
prefetch count
set, 2-15
prefetch limit, 3-16
PREPARED status, 2-17
proxy connections, 2-5
using createProxyConnection method, 2-5

Q

queries, 1-6
how to specify, 2-15

R

RAW
external datatype, 4-16
REF
external datatype, 4-17
retrieving a reference to an object, 3-13
Ref class, 8-137
methods, 8-138
RefAny class, 8-144
methods, 8-144, 8-148
reference semantics
external LOBs, 5-3
referenceable objects, 3-3
relational programming
using OCCI, 2-1
RESULT_SET_AVAILABLE status, 2-17, 2-18
ResultSet class, 2-14, 8-147
root object, 3-16
ROWID
external datatype, 4-17

S

SCHEMA_NAMES OTT parameter, 7-96
usage, 7-103
shared server environments
application-provided serialization, 2-26
automatic serialization, 2-25
concurrency, 2-26
thread safety, 2-23, 2-24
implementing, 2-24
using, 2-23
SQL statements
control statements, 1-6
DDL statements, 1-5
DML statements, 1-6
processing of, 1-5
queries, 1-6
types
callable statements, 2-8, 2-10
parameterized statements, 2-8, 2-9
standard statements, 2-8, 2-9
SQLException class, 8-169
methods, 8-169
standalone objects, 3-3
creating, 3-3
standard statements, 2-9
Statement class, 8-171
methods, 8-171
statement handles
creating, 2-6
reusing, 2-7
terminating, 2-8
status
NEEDS_STREAM_DATA, 2-17, 2-19
PREPARED, 2-17
RESULT_SET_AVAILABLE, 2-17, 2-18
STREAM_DATA_AVAILABLE, 2-17, 2-19
UNPREPARED, 2-17
UPDATE_COUNT_AVAILABLE, 2-17, 2-18
Stream class, 8-215
methods, 8-215
STREAM_DATA_AVAILABLE status, 2-17, 2-19
streamed reads, 2-12
LOBs, 5-13
streamed writes, 2-12
LOBs, 5-14
STRING
external datatype, 4-17
substitutability, 3-24

T

thread safety, 2-23, 2-24
implementing, 2-24
TIMESTAMP
external datatype, 4-17
Timestamp class
methods, 8-221
TIMESTAMP WITH LOCAL TIME ZONE
external datatype, 4-18
TIMESTAMP WITH TIME ZONE
external datatype, 4-18
transient objects, 3-2, 3-4
creating, 3-4
with LOB attributes, 5-17
TRANSITIVE OTT parameter, 7-23, 7-96
type inheritance, 3-22, 3-25

U

UNPREPARED status, 2-17
UNSIGNED INT
external datatype, 4-18
UPDATE_COUNT_AVAILABLE status, 2-17, 2-18
USERID OTT parameter, 7-97

V

values
in context of this document, 3-5
in object applications, 3-5
VARCHAR
external datatype, 4-19
VARCHAR2
external datatype, 4-19
VARNUM
external datatype, 4-19
VARRAW
external datatype, 4-13, 4-19

Go to previous page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback