Index

A  B  C  D  E  G  I  J  L  M  N  O  P  R  S  T  W 

---

A

Alias library, 4-2

Associating the Extensible Optimizer Methods with Database Objects, 11-62

attributes of object type, 1-15, 11-2

referencing in method, 5-5

---

B

binary large object, see BLOB

BLOB, 6-2

EMPTY_BLOB function, 6-4

braces, xxi

---

C

C and C++

debugging DLLs, 4-15

differences from PL/SQL, 5-9

callback

restrictions, 4-11

Cartridge Services -- File I/O Interface, 13-72

character large object, see CLOB

character sets

support for, 2-12

CLOB, 6-2

EMPTY_CLOB function, 6-4

collection types, 1-8

configuration files

naming conventions, 2-7

configuration files for external procedures, 4-5

constructor method, 3-4

context

WITH CONTEXT clause, 4-9

conventions

naming, 2-8

corruption of package, 5-10

CREATE TYPE BODY statement, 5-2

CREATE TYPE with OID statement, 3-3

Creating Statistics Table (PowerCartUserStats), 11-39

curly brackets, xxi

---

D

data cartridge

definition, 1-2

development process, 2-2

domains, 1-4

external procedures (guidelines), 4-15

installation, 2-4

interfaces, 1-14

method, 1-8

naming conventions, 2-8

suggested development approach, 2-14

datatypes

collection, 1-8

extensibility, 1-7

object type, 1-8

REF (relationship), 1-8

DBMS interfaces, 1-14

DBMS_LOB package, 6-10

compared with OCI, 6-7

DDL

for LOBs, 6-2

debugging

C code in DLLs, 4-15

common errors, 5-9

PL/SQL, 5-8

demo directory (PL/SQL), 4-10

demo file (extdemo1.sql)

extensible indexing in power demand example, 11-15

directories

installation, 2-6

DLL

debugging, 4-15

naming conventions, 2-7

domain index

creating, 11-15

domain of data cartridge, 1-4

---

E

electric utility example, 11-1

EMPTY_BLOB function, 6-4

EMPTY_CLOB function, 6-4

error messages

naming conventions, 2-6

exception

raising (OCIExtProcRaiseExcp), 4-13

raising (OCIExtProcRaiseExcpWithMsg), 4-13

extdemo1.sql demo file (extensible indexing in power demand example), 11-15

extdemo3a.java Demonstration Script, A-31

extdemo3.java Demonstration Script, A-21

extdemo3.sql Demonstration Script, A-13

extensibility

datatypes, 1-7

interfaces, 1-13

server execution environment, 1-10, 2-5

services, 1-6

extensible indexing

queries benefitting, 11-14

external library, 1-17

linkage, 1-16

external LOB, 6-2

external procedure

configuration files for, 4-5

guidelines, 4-15

guidelines for using with data cartridge, 4-15

how PL/SQL calls, 4-4

LOBs in, 6-11

OCI access functions, 4-12

overview, 4-2

PARAMETERS clause, 4-9

passing parameters to, 4-6

registering, 4-3

specifying datatypes, 4-7

WITH CONTEXT clause, 4-9

external procedure functions

return codes, 13-2

with_context type, 13-3

extproc process, 4-4

---

G

globals

naming conventions, 2-5

---

I

index

domain

creating, 11-15

metadata for, 11-37

indexing

extensible

queries benefitting, 11-14

queries not benefitting, 11-14

index-organized table

not used in power demand example, 11-75

indextype implememntation methods, 11-22

installation directory

naming conventions, 2-6

installation of data cartridge, 2-4

interfaces

data cartridge, 1-14

DBMS, 1-14

extensibility, 1-13

service, 1-14

internal LOB, 6-2

---

J

Java Demo, A-13

Java Demo Script, A-13

---

L

large object, see LOB

library

alias, 4-2

shared, 2-7, 4-2

LOB

DDL for, 6-2

external, 6-2

external procedure use, 6-11

internal, 6-2

locator, 6-3

OCI use with, 6-6

overview, 1-9

triggers and, 6-12

value, 6-2

locator

LOB, 6-3

---

M

Maintaining Context - Java, 14-3

map methods, 3-5

member method, 3-2, 5-2

message files

naming conventions, 2-6

metadata

index, 11-37

method, 1-8, 1-15, 11-2

constructor, 3-4

implementing, 5-2

invoking, 5-4

map, 3-5

member, 3-2, 5-2

order, 3-5

referencing attributes, 5-5

---

N

name registration, 2-10

naming conventions, 2-8

configuration files, 2-7

error messages, 2-6

globals, 2-5

installation directory, 2-6

message files, 2-6

name format, 2-9

need for, 2-8

registering a name with Oracle, 2-10

schema, 2-5

shared libraries, 2-7

national language support (NLS), 2-12

NCLOB, 6-2

NLS (national language support), 2-12

notation

conventions, xxi

rules for, xxi

---

O

object identifier (OID)

with CREATE TYPE, 3-3

object type, 1-8

attributes, 1-15, 11-2

body code, 1-16

comparisons, 3-5

methods, 11-2

specification, 1-15

OCI

LOB manipulation functions, 6-6

OCI relational functions

guide to reference entries, 13-2

OCI_DURATION_SESSION, 13-13

OCI_DURATION_STATEMENT, 13-13

OCIContextClearValue(), 13-27

OCIContextGenerateKey(), 13-29

OCIContextGetValue(), 13-25

OCIContextSetValue(), 13-23

OCIDurationBegin(), 13-13

OCIDurationEnd(), 13-15

OCIExtProcAllocCallmemory(), 13-5, 13-6, 13-7, 13-9

OCIExtProcAllocMemory routine, 4-12

OCIExtProcGetEnv(), 13-11

OCIExtProcRaiseExcp routine, 4-13

OCIExtProcRaiseExcpWithMsg routine, 4-13

OCIExtProcRaiseExcpWithMsg(), 13-9

OCIExtractFromFile(), 13-38

OCIExtractFromList(), 13-51

OCIExtractFromStr(), 13-40

OCIExtractInit(), 13-31

OCIExtractReset(), 13-33

OCIExtractSetKey(), 13-35

OCIExtractSetNumKeys(), 13-34

OCIExtractTerm(), 13-32

OCIExtractToBool(), 13-44

OCIExtractToInt(), 13-42

OCIExtractToList(), 13-50

OCIExtractToOCINum(), 13-48

OCIFileClose(), 13-59

OCIFileExists(), 13-67

OCIFileInit(), 13-54

OCIFileObject, 13-53

OCIFileRead(), 13-61

OCIFileSeek(), 13-65

OCIFileTerm(), 13-55

OCIFileWrite(), 13-63

OCILob...() functions, 6-6

OCIMemoryAlloc(, 13-17

OCIMemoryFree(), 13-21

OCIMemoryResize(), 13-19

ODCIArgDesc, 15-33

ODCIArgDescList, 15-33

ODCIArgDescRef, 15-33

ODCIColInfo, 15-33

ODCIColInfoList, 15-33

ODCIColInfoRef, 15-33

ODCICost, 15-33

ODCICostRef, 15-33

ODCIFuncInfo, 15-33

ODCIFuncInfoRef, 15-33

ODCIGetInterfaces method, 11-25

ODCIIndexClose method, 11-33

ODCIIndexCreate method, 11-25

ODCIIndexCtx, 15-33

ODCIIndexCtxRef, 15-33

ODCIIndexDelete method, 11-34

ODCIIndexDrop method, 11-27

ODCIIndexFetch method, 11-32

ODCIIndexGetMetadata method, 11-37

ODCIIndexInfo, 15-33

ODCIIndexInfoRef, 15-33

ODCIIndexInsert method, 11-33

ODCIIndexStart method, 11-28, 11-30

ODCIIndexUpdate method, 11-35

ODCIObject, 15-33

ODCIObjectList, 15-33

ODCIObjectRef, 15-33

ODCIPredInfo, 15-33

ODCIPredInfoRef, 15-33

ODCIQueryInfo, 15-33

ODCIQueryInfoRef, 15-33

ODCIRidList, 15-33

ODCIStatsOptions, 15-33

ODCIStatsOptionsRef, 15-33

OID

with CREATE TYPE, 3-3

order methods, 3-5

---

P

package body, 5-5

package specification, 5-5

packages

corruption, 5-10

in PL/SQL, 5-5

privileges required to create procedures in, 5-7

parameters

modes, 13-2

PARAMETERS clause with external procedure, 4-9

PL/SQL

DBMS_LOB package compared with OCI, 6-7

debugging, 5-8

demo directory, 4-10

differences from C and C++, 5-9

packages, 5-5

power demand cartridge example, 11-1

demo file (extdemo1.sql), 11-15

pragma RESTRICT_REFERENCES, 5-6

privileges

required to create procedures, 5-7

purity level, 5-6

---

R

REF operator, 1-8

registering a data cartridge name, 2-10

registering an external procedure, 4-3

RESTRICT_REFERENCES pragma, 5-6

routine

service, 4-12

RPC time out, 4-14, 5-10

---

S

schema

naming conventions, 2-5

SELF parameter, 5-4, 5-5

service interfaces, 1-14

service routine, 4-12

examples, 4-12

services

extensibility, 1-6

shared library, 4-2

naming conventions, 2-7

side effect, 5-6

signature mismatch, 5-9

.so files

naming conventions, 2-7

Spatial

use in power demand example, 11-81

suggested development approach for data cartridge, 2-14

---

T

Time Series cartridge

use in power demand example, 11-74

triggers

with LOBs, 6-12

---

W

WITH CONTEXT clause and external procedure, 4-9

with_context

argument to external procedure functions, 13-3