-- Index

in object applications, 11-14

character set form, 5-26

character set ID, 5-26

CHARZ

external datatype, 3-17

CLOB

datatype, 3-21

CLOB datatype, 3-21

CODE OTT parameter, 12-25

coherency

of object cache, 11-5

collections

columns

one-phase for global transactions, 7-8

two-pahse for global transactions, 7-8

complex object retrieval, 8-18

implementing, 8-21

navigational prefetching, 8-22

complex object retrieval (COR) descriptor, 2-14

attributes, B-29

complex object retrieval (COR) handle, 2-10

attributes, B-29

CONFIG OTT parameter, 12-27

configuration files

and the OTT, 12-5

connections

establishing, 2-18, 2-19

managing multiple, 2-21

consistency

of object cache, 11-5

copying objects, 8-29

COR, see complex object retrieval, 8-18

creating objects, 8-29

D

data definition language

SQL statements, 1-4

data manipulation language

SQL statements, 1-5

data structures

new for 8.0, 2-5

database connection

for object applications, 8-10

datatype

datatype code

datatype mapping

Oracle methodology, 9-5

datatype mapping and manipulation functions

server roundtrips, E-6

datatype mappings, 12-10

datatypes

BFILE, 3-20

BLOB, 3-20

CLOB, 3-21

FILE, 3-20

for piecewise operations, 7-18

manipulating with OCI, 9-5

mapping from Oracle to C, 9-3

NCLOB, 3-21

DATE

external datatype, 3-13

DDL. See data definition language, 1-4

default file name extensions, 12-36

default name mapping, 12-36

define

arrays, 10-6

define handle

attributes, B-26

description, 2-9

define operation, 4-12, 5-14, 10-4

example, 5-15

LOBs, 5-17

named data types, 5-17, 10-4

piecewise fetch, 5-18

PL/SQL output variables, 5-17

defining

deletes

describe

object describe code example, D-47

of collections, 6-2

of packages, 6-2

of sequences, 6-2

of stored functions, 6-2

of stored procedures, 6-2

describe handle

describe operation, 4-8

implicit, 4-9

server roundtrips, E-5

descriptor, 2-12

complex object retrieval, 2-14

parameter, 2-14

ROWID, 2-14

snapshot, 2-12

descriptor objects, 9-25

descriptors

allocating, 2-17

detaching branches, 7-7

DML with RETURNING clause

See RETURNING clause, 5-22

DML. See data manipulation language, 1-5

duration

of objects, 11-14

durations

example, 11-15

E

embedded objects

fetching, 8-15

embedded SQL, 1-8

mixing with OCI calls, 1-8

environment handle

attributes, B-13

navigational functions, 14-5

error codes

error handle

handling in object applications, 8-29

error handling

example, 2-26

errors

handling, 2-25

ERRTYPE OTT parameter, 12-27

executing SQL statements, 4-6

execution

against multiple servers, 4-5

modes, 4-8

execution snapshots, 4-7

extensions

default file name, 12-36

external datatype, 3-4

external datatypes, 3-7

conversions, 3-22

external procedure functions

return codes, 16-2

with_context type, 16-2

external procedures

OCI callbacks, 7-29

F

fetch

piecewise, 7-16, 7-21

fetch operation, 4-12

LOB data, 4-13

setting prefetch count, 4-13

FILE

associating with OS file, 7-26

datatype, 3-20

locator, 7-25

FLOAT

external datatype, 3-11

flushing, 11-11

object changes, 8-14

flushing objects, 11-11

freeing objects, 8-29, 11-9

functions

attributes, 6-7

G

global transactions, 7-4

GTRID. See transaction identifer, 7-5

H

I

K

keywords, C-2

L

linking, 2-31

issues, A-7

modes, A-7

support for single-task, A-10

lists

LOB, 7-24

external data type, 3-19

OCI operations on, 7-24

LOB attributes

of transient objects, 7-26

LOB buffering, 7-27

code example, D-82

LOB functions

server roundtrips, E-2

LOB locator, 2-13, 7-24

LOB operations

for LOB datatype, 2-13, 7-24

locking, 11-13

locking objects, 11-13

LONG

external datatype, 3-12

LONG RAW

LONG VARCHAR

LONG VARRAW

MDO. See method descriptor object, 9-25

M

marking objects, 11-10

meta-attributes

of objects, 8-17

of persistent objects, 8-17

of transient objects, 8-18

method descriptor object, 9-25

migration

7.x to 8.0, A-5

MLSLABEL

external datatype, 3-17

multiple servers

executing statement against, 4-5

multi-threaded development

basic concepts, 7-14

N

named data type

binding and defining, 10-6

indicator variable for, 2-28

named data types

binding, 5-10, 10-2

defining, 5-17, 10-4

definition, 3-18

external data types, 3-18

indicator variables, 2-30

namespaces

reserved, C-11

navigation, 11-17

navigational functions

NCHAR

NCLOB

nested table

element ordering, 9-22

null indicator struct

generated by OTT, 8-9

null undicator struct, 8-26

nullness

NULLs

inserting into database, 2-28

inserting using indicator variables, 2-28

NUMBER

external datatype, 3-10

O

object

allocation duration, 11-14

array pin, 8-13

attributes

manipulating, 8-13

duration, 11-14

memory layout of instance, 11-16

secondary memory, 11-16

top-level memory, 11-16

unpinning, 8-25

object application

database connection, 8-10

object applications

loading objects, 11-7

memory parameters, 11-5

operations on, 11-6

removing objects, 11-7

setting the size of, 11-5

object functions

See navigational functions, 14-6

server roundtrips, E-4

object identifier

for persistent objects, 8-6

object reference, 8-29

object reference. See REF, 8-11

object retrieval

code example, D-10

object runtime environment

initializing, 8-10

object type translator

sample output, 8-9

See OTT, 12-2

use with OCI, 8-8

objects

obsolescent OCI functions, A-2

obsolete OCI functions , A-4

OCI

object support, 1-9

overview, 1-2

parts of, 1-10

release 8.0 new features, 1-10

OCI application

compiling, 1-11

general structure, 2-3

initialization example, 2-19

linking, 1-11

steps, 2-16

structure, 2-3

structure using objects, 8-4

terminating, 2-23

with objects

initializing, 8-10

OCI applications

using the OTT with, 12-17

OCI environment

initializing for objects, 8-10

OCI functions

canceling calls, 2-30

obsolescent, A-2

obsolete , A-4

return codes, 2-25, 2-27

OCI navigational functions, 11-19

flush functions, 11-20

mark functions, 11-20

meta-attribute accessor functions, 11-21

miscellaneous functions, 11-21

naming scheme, 11-19

pin/unpin/free functions, 11-19

OCI process

initializing, 2-17

initializing for objects, 8-10

modes, 2-17

OCI program. See OCI application, 2-3

OCI relational functions

guide to reference entries, 13-7, 16-3

quick reference, 13-3

OCI Release 8

accessing and manipulating objects, 12-19

OCI_ATTR_ALLOC_DURATION

environment handle attribute, B-15

OCI_ATTR_CACHE

OCI_ATTR_CACHE_MAX_SIZE

OCI_ATTR_CACHE_OPT_SIZE

OCI_ATTR_CHAR_COUNT

use of, 5-28

OCI_ATTR_CHARSET_FORM

attribute, 6-9, 6-11, 6-13

attribute, 6-9, 6-11, 6-13, 6-15

OCI_ATTR_CHARSET_ID

OCI_ATTR_CLUSTERED

OCI_ATTR_COLLECTION_ELEMENT

OCI_ATTR_COLLECTION_TYPECODE

COR handle attribute, B-29

OCI_ATTR_COMPLEXOBJECT_COLL

_OUTOFLINE

OCI_ATTR_COMPLEXOBJECT_LEVEL

COR handle attribute, B-29

OCI_ATTR_COMPLEXOBJECTCOMP

_TYPE

COR descriptor attribute, B-29

OCI_ATTR_COMPLEXOBJECTCOMP

_TYPE_LEVEL

COR descriptor attribute, B-29

OCI_ATTR_DATA_SIZE

OCI_ATTR_DATA_TYPE

OCI_ATTR_DBA

server handle attribute, B-18

OCI_ATTR_ENCAPSULATION

attribute, 6-10

OCI_ATTR_ENV

OCI_ATTR_EXTERNAL_NAME

OCI_ATTR_FNCODE

server handle attribute, B-18

statement handle attribute, B-21

OCI_ATTR_FOCBK

OCI_ATTR_HAS_DEFAULT

OCI_ATTR_HAS_FILE

OCI_ATTR_HAS_LOB

OCI_ATTR_HAS_NESTED_TABLE

OCI_ATTR_HW_MARK

OCI_ATTR_IN_V8_MODE

service context handle attribute, B-18

OCI_ATTR_INCR

OCI_ATTR_INDEX_ONLY

OCI_ATTR_INTERNAL_NAME

OCI_ATTR_IOMODE

OCI_ATTR_IS_CONSTRUCTOR

attribute, 6-10

OCI_ATTR_IS_DESTRUCTOR

attribute, 6-10

OCI_ATTR_IS_INCOMPLETE_TYPE

OCI_ATTR_IS_MAP

OCI_ATTR_IS_NULL

OCI_ATTR_IS_OPERATOR

OCI_ATTR_IS_ORDER

OCI_ATTR_IS_PREDEFINED_TYPE

OCI_ATTR_IS_RNDS

OCI_ATTR_IS_RNPS

OCI_ATTR_IS_SELFISH

OCI_ATTR_IS_SYSTEM_GENERATED_TYPE

OCI_ATTR_IS_SYSTEM_TYPE

OCI_ATTR_IS_TRANSIENT_TYPE

OCI_ATTR_IS_WNDS

OCI_ATTR_IS_WNPS

OCI_ATTR_LEVEL

OCI_ATTR_LINK

attribute, 6-12, 6-15

OCI_ATTR_LIST_ARGUMENTS

attribute, 6-7, 6-10

OCI_ATTR_LIST_COLUMNS

OCI_ATTR_LIST_SUBPROGRAMS

attribute, 6-7

OCI_ATTR_LIST_TYPE

attribute, 6-16

OCI_ATTR_LIST_TYPE_ATTRS

OCI_ATTR_LIST_TYPE_METHODS

LOB locator attribute, B-28

OCI_ATTR_LOBEMPTY

OCI_ATTR_MAP_METHOD

OCI_ATTR_MAX

OCI_ATTR_MAXDATA_SIZE

use with binding, 5-27

OCI_ATTR_MIN

OCI_ATTR_NAME

attribute, 6-7, 6-9-6-14

OCI_ATTR_NUM_ATTRS

OCI_ATTR_NUM_COLS

OCI_ATTR_NUM_ELEMENTS

attribute, 6-11

OCI_ATTR_NUM_HANDLES

attribute, 6-16

OCI_ATTR_NUM_PARAMS

OCI_ATTR_NUM_TYPE_ATTRS

OCI_ATTR_NUM_TYPE_METHODS

OCI_ATTR_OBJECT

OCI_ATTR_OBJID

attribute, 6-6, 6-12

OCI_ATTR_ORDER

OCI_ATTR_ORDER_METHOD

describe handle attribute, B-27

OCI_ATTR_OVERLOAD

attribute, 6-7

OCI_ATTR_PARAM_COUNT

statement handle attribute, B-22

OCI_ATTR_PARTITIONED

user session handle attribute, B-20

OCI_ATTR_PASSWORD

OCI_ATTR_PDFMT

bind handle attribute, B-25

define handle attribute, B-27

OCI_ATTR_PDSCL

bind handle attribute, B-25

define handle attribute, B-27

OCI_ATTR_PIN_DURATION

environment handle attribute, B-15

OCI_ATTR_PINOPTION

environment handle attribute, B-15

OCI_ATTR_POSITION

OCI_ATTR_PRECISION

statement handle attribute, B-23

OCI_ATTR_PREFETCH_MEMORY

OCI_ATTR_PREFETCH_ROWS

statement handle attribute, B-23

OCI_ATTR_PTYPE

OCI_ATTR_RADIX

attribute, 6-8-6-9, 6-11, 6-13, 6-15

OCI_ATTR_REF_TDO

OCI_ATTR_ROWID

statement handle attribute, B-22

OCI_ATTR_ROWS_RETURNED

bind handle attribute, B-25

use with callbacks, 5-26

OCI_ATTR_SCALE

OCI_ATTR_SCHEMA

attribute, 6-9, 6-11, 6-13, 6-15

OCI_ATTR_SCHEMA_NAME

OCI_ATTR_SEQ

attributes, 6-12

OCI_ATTR_SERVER

OCI_ATTR_SESSION

service context handle attribute, B-15

OCI_ATTR_SQLCODE

OCI_ATTR_STMT_TYPE

statement handle attribute, B-22

OCI_ATTR_SUB_NAME

attribute, 6-15

OCI_ATTR_TABLESPACE

OCI_ATTR_TIMESTAMP

OCI_ATTR_TRANS

transaction handle attribute, B-20

OCI_ATTR_TRANS_NAME

OCI_ATTR_TYPE_NAME

attribute, 6-9, 6-11, 6-13, 6-15

OCI_ATTR_TYPECODE

attribute, 6-8-6-9, 6-11, 6-14

OCI_ATTR_USRNAME

user session handle attribute, B-20

OCI_ATTR_VERSION

transaction handle attribute, B-20

OCI_ATTR_XID

OCI_PTYPE_ARG

OCI_PTYPE_COL

OCI_PTYPE_COLL

OCI_PTYPE_FUNC

OCI_PTYPE_LIST

OCI_PTYPE_PKG

OCI_PTYPE_PROC

OCI_PTYPE_SYN

OCI_PTYPE_TABLE

OCI_PTYPE_TYPE

OCI_PTYPE_TYPE_ATTR

OCI_PTYPE_TYPE_FUNC

OCI_PTYPE_TYPE_PROC

OCI_PTYPE_VIEW

OCI_TYPECODE values, 3-24

OCIArray, 9-18

binding and defining, 9-18, 10-6

OCIArray manipulation

code example, 9-20

OCIAttrGet(), 13-8

used for describing, 4-9

OCIAttrSet(), 13-9

OCIBindArrayOfStruct(), 13-11

OCIBindByName(), 13-12

OCIBindByPos(), 13-16

OCIBindDynamic(), 13-20

OCIBindObject(), 13-23

OCICacheFlush(), 14-10

OCICacheFree(), 14-12

OCICacheRefresh(), 14-13

OCICacheUnmark(), 14-15

OCICacheUnpin(), 14-16

OCIColl, 9-18

binding and defining, 9-18

OCICollAppend(), 15-8

OCICollAssign(), 15-9

OCICollAssignElem(), 15-10

OCICollGetElem(), 15-11

binding and defining, 9-7, 10-6

OCIDate manipulation

code example, 9-9

OCIDateAddDays(), 15-17

OCIDateAddMonths(), 15-18

OCIDateAssign(), 15-19

OCIDateCheck(), 15-20

OCIDateCompare(), 15-21

OCIDateDaysBetween(), 15-22

OCIDateFromText(), 15-23

OCIDateGetDat(), 15-24

OCIDateGetTime(), 15-25

OCIDateLastDay(), 15-26

OCIDateNextDay(), 15-27

OCIDateSetDate(), 15-28

OCIDateSetTime(), 15-29

OCIDateSysDate(), 15-30

OCIDateToText(), 15-31

OCIDateZoneToZone(), 15-32

OCIDefineArrayOfStruct(), 13-26

OCIDefineByPos(), 13-27

OCIDefineDynamic(), 13-30

OCIDefineObject(), 13-32

OCIDescAlloc(), 13-37

OCIDescFree(), 13-38

OCIDescribeAny(), 13-34

OCIExtProcAllocCallmemory(), 16-4

OCIExtProcGetEnv(), 16-7

OCIExtProcRaiseExcp(), 16-5

OCIExtProcRaiseExcpWithMsg(), 16-6

OCIHandleAlloc(), 13-42

OCIHandleFree(), 13-44

OCIInitialize(), 13-45

OCIIter, 9-18

binding and defining, 9-18

usage example, 9-20

OCIIterCreate(), 15-33

OCIIterDelete(), 15-34

OCIIterGetCurrent(), 15-35

OCIIterInit(), 15-36

OCIIterNext(), 15-37

OCIIterPrev(), 15-38

OCILdaToSvcCtx(), 13-47

OCILobAppend(), 13-48

OCILobAssign(), 13-49

OCILobCharSet(), 13-51-13-52

OCILobCopy(), 13-53

OCILobDisableBuffering(), 13-55

OCILobEnableBuffering(), 13-56

OCILobErase(), 13-57

OCILobFileClose(), 13-58

OCILobFileCloseAll(), 13-59

OCILobFileExists(), 13-60

OCILobFileIsOpen(), 13-62

OCILobFileOpen(), 13-63

OCILobFlushBuffer(), 13-65

OCILobGetFile(), 13-61

OCILobGetLength(), 13-66

OCILobIsEqual(), 13-67

OCILobLoadFromFile(), 13-68

OCILobLocatorIsInit(), 13-70

OCILobRead(), 13-71

OCILobSetFile(), 13-64

binding and defining, 9-11, 10-6

define example, 10-7

OCINumber manipulation

code example, 8-14, 9-14

OCINumberAbs(), 15-39

OCINumberAdd(), 15-40

OCINumberArcCos(), 15-41

OCINumberArcSin(), 15-42

OCINumberArcTan(), 15-43

OCINumberArcTan2(), 15-44

OCINumberAssign(), 15-45

OCINumberCeil(), 15-46

OCINumberCompare(), 15-47

OCINumberCos(), 15-48

OCINumberDiv(), 15-49

OCINumberExp(), 15-50

OCINumberFloor(), 15-51

OCINumberFromInt(), 15-52

OCINumberFromReal(), 15-53

OCINumberFromText(), 15-54

OCINumberHypCos(), 15-55

OCINumberHypSin(), 15-56

OCINumberHypTan(), 15-57

OCINumberIntPower(), 15-58

OCINumberIsZero(), 15-59

OCINumberLn(), 15-60

OCINumberLog(), 15-61

OCINumberMod(), 15-62

OCINumberMul(), 15-63

OCINumberNeg(), 15-64

OCINumberPower(), 15-65

OCINumberRound(), 15-66

OCINumberSetZero(), 15-67

OCINumberSign(), 15-68

OCINumberSin(), 15-69

OCINumberSqrt(), 15-70

OCINumberSub(), 15-71

OCINumberTan(), 15-72

OCINumberToInt(), 15-73

OCINumberToReal(), 15-74

OCINumberToText(), 15-75

OCINumberTrunc(), 15-76

OCIObjectArrayPin(), 14-17

OCIObjectCopy(), 14-18

OCIObjectExists(), 14-20

OCIObjectFlush(), 14-21

OCIObjectFree(), 14-22

OCIObjectGetAttr(), 14-24

OCIObjectGetInd(), 14-26

OCIObjectGetObjectRef(), 14-27

OCIObjectGetTypeRef(), 14-28

OCIObjectIsDirty(), 14-29

OCIObjectIsLocked(), 14-30

OCIObjectLock(), 14-31

OCIObjectMarkDelete(), 14-32

OCIObjectMarkDeleteByRef(), 14-33

OCIObjectMarkUpdate(), 14-34

OCIObjectNew(), 14-35

OCIObjectPin(), 14-38

OCIObjectPinCountReset(), 14-40

OCIObjectPinTable(), 14-41

OCIObjectRefresh(), 14-42

OCIObjectSetAttr(), 14-44

OCIObjectUnmark(), 14-46

OCIObjectUnmarkByRef(), 14-47

OCIObjectUnpin(), 14-48

OCIParamGet(), 13-80

used for describing, 4-9

OCIParamSet(), 13-81

OCIPasswordChange(), 13-82

OCIRaw, 9-17

binding and defining, 9-17, 10-6

OCIRaw manipulation

code example, 9-18

OCIRawAllocSize(), 15-77

OCIRawAssignBytes(), 15-78

OCIRawAssignRaw(), 15-79

OCIRawPtr(), 15-80

OCIRawResize(), 15-81

OCIRawSize(), 15-82

OCIRef, 9-23

binding and defining, 9-23

usage example, 9-24

OCIRefAssign(), 15-83

OCIRefClear(), 15-84

OCIRefFromHex(), 15-85

OCIRefHexSize(), 15-86

OCIRefIsEqual(), 15-87

OCIRefIsNull(), 15-88

OCIRefToHex(), 15-89

OCISBreak()

use of, 2-30

OCIServerAttach(), 13-84

OCIServerDetach(), 13-86

OCIServerVersion(), 13-87

OCISessionBegin(), 13-88

OCISessionEnd(), 13-91

OCIStmtExecute(), 13-92

prefetch during, 4-6

use of iters parameter, 4-6

OCIStmtFetch(), 13-95

OCIStmtGetBind(), 13-96

OCIStmtGetPieceInfo(), 13-98

OCIStmtPrepare(), 13-99

preparing SQL statements, 4-4

OCIStmtSetPieceInfo(), 13-100

OCIString, 9-16

binding and defining, 9-16, 10-6

OCIString manipulation

code example, 9-16

OCIStringAllocSize(), 15-90

OCIStringAssign(), 15-91

OCIStringAssignText(), 15-92

OCIStringPtr(), 15-93

OCIStringResize(), 15-94

OCIStringSize(), 15-95

OCISvcCtxBreak(), 13-25

OCISvcCtxToLda(), 13-101

OCITable, 9-18

binding and defining, 9-18, 10-6

OCITableDelete(), 15-96

OCITableExists(), 15-97

OCITableFirst(), 15-98

OCITableLast(), 15-99

OCITableNext(), 15-100

OCITablePrev(), 15-101

OCITableSize(), 15-102

OCITransCommit(), 13-102

OCITransDetach(), 13-103

OCITransForget(), 13-104

OCITransPrepare(), 13-105

OCITransRollback(), 13-106

OCITransStart(), 13-107

OCITypeArrayByName(), 13-109

OCITypeArrayByRef(), 13-111

OCITypeByName(), 13-112

OCITypeByRef(), 13-114

OID. See object identifier, 8-6

Oracle Call Interface. See OCI, 1-10

Oracle datatypes, 3-2

mapping to C, 9-3

Oracle Security Services, 7-33

Oracle8 datatypes

binding and defining, 10-6

oratypes.h

contents, 3-28

ORE. See object runtime environment, 8-10

OTT

command line, 12-6

command line syntax, 12-22

creating types in the database, 12-5

datatype mappings, 12-10

providing an intype file, 12-8

reference, 12-22

restrictions, 12-37

using, 12-1-12-2

OTT parameters

CASE, 12-27

CODE, 12-25

where they appear, 12-28

OTT. See object type translator, 8-8

outtype file, 12-29

when running OTT, 12-16

OUTTYPE OTT parameter, 12-25

P

packages

attributes, 6-7

describing, 6-2

parameter descriptor, 2-14

attributes, B-28

parameter descriptor object, 9-25

parameter descriptors

attributes, 6-5

parameters

attributes, 6-5

modes, 13-7, 16-3

passing strings, 2-28

string length, 13-6

password management, 7-11-7-12

PDO. See parameter descriptor object, 9-25

persistent objects, 8-6

meta-attributes, 8-17

piecewise fetch, 7-21

piecewise operations, 7-18

valid datatypes, 7-18

pin duration

pinning objects, 11-7

PL/SQL, 1-7

binding and defining nested tables, 5-29

binding and defining ref cursors, 5-29

binding placeholders, 2-32

defining output variables, 5-17

piecewise operations, 7-21

uses in OCI applications, 2-32

using in OCI applications, 2-32

using in OCI programs, 5-7

positioned deletes, 2-31

positioned updates, 2-31

prefetching

during OCIStmtExecute(), 4-6

setting prefetch memory size, 4-13

setting row count, 4-13

procedures

attributes, 6-7

Q

query

explicit describe, 4-11

query. See SQL query, 4-12, 5-14, 10-4

Quick reference to OCI relational functions, 13-3

R

RAW

external datatype, 3-14

REF

binding, 5-10, 10-3

defining, 5-17, 10-4

external data types, 3-18

indicator variable for, 2-28

retrieving from server, 8-11

ref cursor variables

binding, 5-12

ref cursors

binding and defining, 5-29

reference. See REF, 8-11

refreshing, 11-11

refreshing objects, 11-11

REFs

indicator variables for, 2-30

relational functions

server roundtrips, E-7

release 8.0 enhancements, F-2

reserved namespaces, C-11

reserved words, C-2

resuming branches, 7-7

RETRNING clause

error handling, 5-24

return values

navigational functions, 14-4

RETURNING clause

in object applications, 11-14

roundtrips

See server roundtrips, E-2

ROWID

external data type, 3-13

used for positioned updates and

deletes, 2-31

ROWID descriptor, 2-14

S

sb1

definition, 3-28

sb2

definition, 3-28

sb4

definition, 3-28

SCHEMA_NAMES OTT parameter, 12-28

usage, 12-33

secondary memory

of object, 11-16

security handle, 2-10

select-list

sequences

server handle

multiple, 2-21

setting in service context, 2-9

server roundtrips

cache functions, E-4

datatype mapping and manipulation

functions, E-6

describe operation, E-5

LOB functions, E-2

object functions, E-4

relational functions, E-7

service context handle

attributes, B-15

for standard arrays, 5-20

elements of, 2-8

multiple, 2-21

sessions

creating, 2-18, 2-19, 2-21, 7-11, 7-12

credentials, 7-12

migratable & non-migratable, 7-11, 7-12

single-task linking

support, A-10

skip parameter

skip parameters

for arrays of structures, 5-19

snapshot descriptor, 2-12

snapshots

executing against, 4-7

SQL Command Codes

listing, B-16

SQL processing

code example, D-2

SQL query

binding placeholders. See bind

operation, 4-12

defining output variables, 4-12, 5-14, 10-4

defining output variables. See define

operation, 4-12

fetching results, 4-12

statement type, 1-6

SQL statements, 1-4

binding placeholders in, 4-5, 5-2, 10-2

determining type prepared, 4-4

executing, 4-6

preparing for execution, 4-4

processing, 4-2

types

control statements, 1-5

data definition language, 1-4

data manipulation language, 1-5

PL/SQL, 1-7

SQLT_NTY

define example, 10-15

SQLT_REF

statement handle

static arrays

stored functions

stored procedures

STRING

external datatype, 3-11

strings

passing as parameters, 2-28

structures

sword

synonyms

T

tables

TDO

terminology

navigational functions, 14-4

used in this manual, 1-8

thread safety, 7-13

advantages of, 7-13

and three-tier architectures, 7-14

basic concepts, 7-14

implementing with OCI, 7-14

mixing 7.x and 8.0 calls, 7-16

required OCI calls, 7-14

three-tier architectures

and thread safety, 7-14

top-level memory

of object, 11-16

transaction handle

attributes, B-20

description, 2-9

transaction identifier, 7-5

transactional complexity

transactions

global, 7-4

one-phase commit, 7-8

transaction identifier, 7-5

two-phase commit, 7-8

global examples, 7-9

initialization parameters, 7-10

local, 7-4

multiple, 2-21

OCI functions for

transient objects, 8-7

LOB attributes, 7-26

meta-attributes, 8-18

type attributes

attributes, 6-9

type descriptor object, 9-25

type descriptor object. See also TDO, 9-25

type functions

type procedures

types

U

ub1

ub2

ub4

unmarking objects, 11-10

unpinning, 8-25, 11-9

unpinning objects, 11-9

UNSIGNED

update

piecewise, 7-16, 7-18

updates

positioned, 2-31

upgrading

7.x to 8.0, A-5

7.x to 8.0 OCI, A-6

user authentication, 7-11

user memory

allocating, 2-15

user session handle

attributes, B-20

setting in service context, 2-9

multiple, 2-21

user session. See session.

USERID OTT parameter, 12-24

V

values, 8-6

in object applications, 8-7

VARCHAR

external datatype, 3-13

VARCHAR2

external datatype, 3-8

VARNUM

external datatype, 3-12

VARRAW