Index

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

A

aggregate functions, user-defined, 12

analytic functions and, 12.5.2

creating, 12.2

parallel evaluation of, 12.4

Alias library, 5.2

ALTER INDEX statement, 8.4.1

ancillary binding, 9.2.3

ANYDATA type, 13.7

ANYDATASET type, 13.7

ANYTYPE type, 13.7

Associating the Extensible Optimizer Methods with Database Objects, 15.5.3

attributes of object type, 15.1

referencing in method, 4.1.3

autonomous transaction restriction, 13.3.5

B

binary large object, see BLOB

binding, 8.1, 9.1.1

BLOB, 6.1

EMPTY_BLOB function, 6.4

B-tree indexing algorithm, 7.1.4.1

C

C and C++

debugging DLLs, 5.8.2

differences from PL/SQL, 4.5.1

callback

restrictions, 5.6.1

Callback Restrictions, 5.6.1

character large object, see CLOB

character sets

support for, 2.4.7

CLOB, 6.1

EMPTY_CLOB function, 6.4

collection types, 1.4.1.2

configuration files

naming conventions, 2.3.5

configuration files for external procedures, 5.5

constructor method, 3.3

context

WITH CONTEXT clause, 5.5.4

conventions

naming, 2.4.1

corruption of package, 4.5.2.3

CREATE TYPE BODY statement, 4.1.1

CREATE TYPE with OID statement, 3.2

Creating Statistics Table (PowerCartUserStats), 15.5.1

D

data cartridge

definition, 1.1

development process, 2.1

domains, 1.2.1

external procedures (guidelines), 5.9

installation, 2.2

interfaces, 1.5.3

method, 1.4.1.1

naming conventions, 2.4.1

suggested development approach, 2.4.9

datatypes

collection, 1.4.1.2

extensibility, 1.4.1

REF (relationship), 1.4.1.3

user-defined type, 1.4.1.1

Datatypes, Specifying, 5.5.2

DBMS interfaces, 1.5.1

DBMS_LOB package, 6.6

compared with OCI, 6.5

DDL

for LOBs, 6.1, 6.2

DEBUG_EXTPROC, Using, 5.8.1

debugging

C code in DLLs, 5.8.2

common errors, 4.5.2

PL/SQL, 4.5

Debugging External Procedures, 5.8

demo directory (PL/SQL), 18.2

demo file (extdemo1.sql)

extensible indexing in power demand example, 15.4

directories

installation, 2.3.4

DLL

debugging, 5.8.2

naming conventions, 2.3.6

domain index, 7.2, 8.1

domain indexes, 7.2, 8.4

altering, 8.4.1

creating, 15.4

parallelizing, with table functions, 13.6

exporting and importing, 8.4.4

loading, 8.7.7

moving, 8.4.5

domain of data cartridge, 1.2.1

E

electric utility example, 15

EMPTY_BLOB function, 6.4

EMPTY_CLOB function, 6.4

error messages

naming conventions, 2.3.3

exception

raising (OCIExtProcRaiseExcp), 18.1.2

raising (OCIExtProcRaiseExcpWithMsg), 18.1.3

extdemo1.sql demo file (extensible indexing in power demand example), 15.4

extensibility

datatypes, 1.4.1

interfaces, 1.5

server execution environment, 1.4.2, 2.3

services, 1.4

extensible indexing

queries benefitting, 15.3.1, 15.3.2

external LOB, 6.1

external procedure

configuration files for, 5.5

guidelines, 5.9

guidelines for using with data cartridge, 5.9

how PL/SQL calls, 5.4

LOBs in, 6.7

OCI access functions, 18.1

overview, 5.1

PARAMETERS clause, 5.5.3

passing parameters to, 5.5.1

registering, 5.3

specifying datatypes, 5.5.2

WITH CONTEXT clause, 5.5.4

External Procedures, Debugging, 5.8

extproc process, 5.4, 5.4, 5.4, 5.4, 5.4, 5.4, 5.4, 5.4, 5.4, 5.8, 5.9

F

features, new, Preface

G

generic types

See ANYTYPE type

Globalization Support, 2.4.7

globals

naming conventions, 2.3.2

I

implementation type, 8.1

index

domain

creating, 15.4

metadata for, 15.4.5.12

index scan, 9.2.1

indexing

extensible

queries benefitting, 15.3.2

queries not benefitting, 15.3.1

index-organized table, 7.2

indextype, 8.1

indextype implementation methods, 15.4.5

indextypes, 7.2, 16.2

operators and, 9.2

installation directory

naming conventions, 2.3.4

installation of data cartridge, 2.2

interfaces

data cartridge, 1.5.3

DBMS, 1.5.1

extensibility, 1.5

service, 1.5.2

internal LOB, 6.1

K

Knuth, 7.1.4.1

L

large object, see LOB

library

alias, 5.2

shared, 2.3.6, 5.2

LOB

DDL for, 6.1, 6.2

external, 6.1

external procedure use, 6.7

internal, 6.1

locator, 6.3

OCI use with, 6.5

overview, 1.4.1.4

triggers and, 6.8

value, 6.1

local domain indexes, 8.7, 16.1

locator

LOB, 6.3

M

Maintaining Context - Java, 18.4

map methods, 3.4

materialized views, 12.6

member method, 3.1, 4.1

message files

naming conventions, 2.3.5

metadata

index, 15.4.5.12

method, 1.4.1.1, 15.1

constructor, 3.3

implementing, 4.1.1

invoking, 4.1.2

map, 3.4

member, 3.1, 4.1

order, 3.4

referencing attributes, 4.1.3

N

naming conventions, 2.4.1

configuration files, 2.3.5

error messages, 2.3.3

globals, 2.3.2

installation directory, 2.3.4

message files, 2.3.5

name format, 2.4.1.2

need for, 2.4.1.1

schema, 2.3.1

shared libraries, 2.3.6

national language support (NLS). See Globalization Support

NCLOB, 6.1

new features, Preface

NLS (national language support). See Globalization Support

O

object identifier (OID)

with CREATE TYPE, 3.2

object type

attributes, 15.1

comparisons, 3.4

methods, 15.1

OCI

LOB manipulation functions, 6.5

OCIExtProcAllocMemory routine, 18.1.1

OCIExtProcRaiseExcp routine, 18.1.2

OCIExtProcRaiseExcpWithMsg routine, 18.1.3

OCILob...() functions, 6.5

ODCIAggregate interface, 12.1

ODCIGetInterfaces method, 15.4.5.2

ODCIIndexClose method, 15.4.5.8

ODCIIndexCreate method, 15.4.5.3

ODCIIndexDelete method, 15.4.5.10

ODCIIndexDrop method, 15.4.5.4

ODCIIndexFetch method, 15.4.5.7

ODCIIndexGetMetadata method, 15.4.5.12

ODCIIndexInsert method, 15.4.5.9

ODCIIndexStart method, 15.4.5.5, 15.4.5.6

ODCIIndexUpdate method, 15.4.5.11

OID

with CREATE TYPE, 3.2

operator, 7.2

order methods, 3.4

P

package body, 4.2

package specification, 4.2

packages

corruption, 4.5.2.3

in PL/SQL, 4.2

privileges required to create procedures in, 4.4

PARAMETERS clause with external procedure, 5.5.3

PL/SQL

DBMS_LOB package compared with OCI, 6.5

debugging, 4.5

demo directory, 18.2

differences from C and C++, 4.5.1

packages, 4.2

power demand cartridge example, 15

demo file (extdemo1.sql), 15.4

pragma RESTRICT_REFERENCES, 4.3

primary binding, 9.2.3

privileges

required to create procedures, 4.4

purity level, 4.3

R

REF operator, 1.4.1.3

registering an external procedure, 5.3

RESTRICT_REFERENCES pragma, 4.3

Restrictions on Callbacks, 5.6.1

routine

service, 18.1

RPC time out, 4.5.2.2, 5.7.2

S

schema

naming conventions, 2.3.1

SELF parameter, 4.1.2, 4.1.3

service interfaces, 1.5.2

service routine, 18.1

examples, 18.1.1

services

extensibility, 1.4

shared library, 5.2

naming conventions, 2.3.6

side effect, 4.3

signature, 9.1.1

signature mismatch, 4.5.2.1

.so files

naming conventions, 2.3.6

suggested development approach for data cartridge, 2.4.9

T

table functions, 13.1

parallel execution of, 13.2.4, 13.4, 13.4.3

partitioning input, 13.4.2

pipelined, 13.2.3, 13.3.1, 13.3.4

querying, 13.3.7

REF CURSOR arguments to, 13.2.3

transient types

See ANYTYPE type

triggers

with LOBs, 6.8

U

user-defined operator, 9.1

user-defined type, 1.4.1.1

W

WITH CONTEXT clause and external procedure, 5.5.4