Oracle9i Data Cartridge Developer's Guide -- Index

aggregate functions, user-defined, 11-1 to 11-13

analytic functions and, 11-9

creating, 11-4

parallel evaluation of, 11-6

Alias library, 4-2

ALTER INDEX statement, 7-24

ANYDATA type, 12-28

ANYDATASET type, 12-28

ANYTYPE type, 12-27

Associating the Extensible Optimizer Methods with Database Objects, 13-63

attributes of object type, 1-16, 13-2

referencing in method, 5-5

binary large object, see BLOB

BLOB, 6-2

EMPTY_BLOB function, 6-4

C and C++

debugging DLLs, 4-15

differences from PL/SQL, 5-9

callback

restrictions, 4-11

Callback Restrictions, 4-11

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

configuration files for external procedures, 4-6

constructor method, 3-5

context

WITH CONTEXT clause, 4-10

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), 13-40

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

Datatypes, Specifying, 4-7

DBMS interfaces, 1-14

DBMS_LOB package, 6-10

compared with OCI, 6-7

DDL

for LOBs, 6-2

DEBUG_EXTPROC, Using, 4-15

debugging

C code in DLLs, 4-15

common errors, 5-9

PL/SQL, 5-8

Debugging External Procedures, 4-14

demo directory (PL/SQL), 4-11

demo file (extdemo1.sql)

extensible indexing in power demand example, 13-15

directories

installation, 2-6

DLL

debugging, 4-15

naming conventions, 2-7

domain indexes, 7-11, 7-24

altering, 7-24

creating, 13-15

parallelizing, with table functions, 12-25

exporting and importing, 7-27

loading, 7-47

moving, 7-28

domain of data cartridge, 1-4

electric utility example, 13-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), 13-15

extensibility

datatypes, 1-7

interfaces, 1-14

server execution environment, 1-10, 2-5

services, 1-7

extensible indexing

queries benefitting, 13-14

external library, 1-17

linkage, 1-16

external LOB, 6-2

external procedure

configuration files for, 4-6

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

registering, 4-3

specifying datatypes, 4-7

WITH CONTEXT clause, 4-10

External Procedures, Debugging, 4-14

extproc process, 4-5, 4-6, 4-15

features, new, xxxii

generic types

See ANYTYPE type

Globalization Support, 2-12

globals

naming conventions, 2-5

index

domain

creating, 13-15

metadata for, 13-37

index scan, 7-34

indexing

extensible

queries benefitting, 13-14

queries not benefitting, 13-14

indextype, 7-17

indextype implementation methods, 13-22

indextypes, 7-11, 14-2

operators and, 7-31

installation directory

naming conventions, 2-6

installation of data cartridge, 2-4

interfaces

data cartridge, 1-14

DBMS, 1-14

extensibility, 1-14

service, 1-14

internal LOB, 6-2

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

local domain indexes, 7-42 to 7-47, 14-2

locator

LOB, 6-3

Maintaining Context - Java, 15-3

map methods, 3-5

materialized views, 11-9

member method, 3-2, 5-2

message files

naming conventions, 2-6

metadata

index, 13-37

method, 1-8, 1-16, 13-2

constructor, 3-5

implementing, 5-2

invoking, 5-4

map, 3-5

member, 3-2, 5-2

order, 3-5

referencing attributes, 5-5

naming conventions, 2-8

configuration files, 2-6

error messages, 2-6

globals, 2-5

installation directory, 2-6

message files, 2-6

name format, 2-9

need for, 2-8

schema, 2-5

shared libraries, 2-7

national language support (NLS). See Globalization Support

NCLOB, 6-2

new features, xxxii

NLS (national language support). See Globalization Support

object identifier (OID)

with CREATE TYPE, 3-3

object type, 1-8

attributes, 1-16, 13-2

body code, 1-16

comparisons, 3-5

methods, 13-2

specification, 1-16

OCI

LOB manipulation functions, 6-6

OCIExtProcAllocMemory routine, 4-13

OCIExtProcRaiseExcp routine, 4-13

OCIExtProcRaiseExcpWithMsg routine, 4-13

OCILob...() functions, 6-6

ODCIAggregate interface, 11-3

ODCIArgDesc, 16-36

ODCIArgDescList, 16-36

ODCIArgDescRef, 16-36

ODCIColInfo, 16-36

ODCIColInfoList, 16-36

ODCIColInfoRef, 16-36

ODCICost, 16-36

ODCICostRef, 16-36

ODCIFuncInfo, 16-36

ODCIFuncInfoRef, 16-36

ODCIGetInterfaces method, 13-25

ODCIIndexClose method, 13-33

ODCIIndexCreate method, 13-25

ODCIIndexCtx, 16-36

ODCIIndexCtxRef, 16-36

ODCIIndexDelete method, 13-35

ODCIIndexDrop method, 13-27

ODCIIndexFetch method, 13-32

ODCIIndexGetMetadata method, 13-37

ODCIIndexInfo, 16-36

ODCIIndexInfoRef, 16-36

ODCIIndexInsert method, 13-34

ODCIIndexStart method, 13-28, 13-30

ODCIIndexUpdate method, 13-36

ODCIObject, 16-36

ODCIObjectList, 16-36

ODCIObjectRef, 16-36

ODCIPredInfo, 16-36

ODCIPredInfoRef, 16-36

ODCIQueryInfo, 16-36

ODCIQueryInfoRef, 16-36

ODCIRidList, 16-36

ODCIStatsOptions, 16-36

ODCIStatsOptionsRef, 16-36

OID

with CREATE TYPE, 3-3

order methods, 3-5

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 clause with external procedure, 4-9

PL/SQL

DBMS_LOB package compared with OCI, 6-7

debugging, 5-8

demo directory, 4-11

differences from C and C++, 5-9

packages, 5-5

power demand cartridge example, 13-1

demo file (extdemo1.sql), 13-15

pragma RESTRICT_REFERENCES, 5-6

privileges

required to create procedures, 5-7

purity level, 5-6

REF operator, 1-9

registering an external procedure, 4-3

RESTRICT_REFERENCES pragma, 5-6

Restrictions on Callbacks, 4-11

routine

service, 4-12

RPC time out, 4-14, 5-10

schema

naming conventions, 2-5

SELF parameter, 5-4, 5-5

service interfaces, 1-14

service routine, 4-12

examples, 4-13

services

extensibility, 1-7

shared library, 4-2

naming conventions, 2-7

side effect, 5-6

signature mismatch, 5-9

.so files

naming conventions, 2-7

suggested development approach for data cartridge, 2-14

table functions, 12-2 to ??

parallel execution of, 12-6, 12-17, 12-23

partitioning input, 12-21

pipelined, 12-5, 12-7, 12-9

querying, 12-14

REF CURSOR arguments to, 12-5

table functions, 12-29

transient types

See ANYTYPE type

triggers

with LOBs, 6-12

WITH CONTEXT clause and external procedure, 4-10