Index

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

A

aggregate function, user-defined, 11.1, 22

analytic functions, 11.5.2, 11.5.4

analytic functions and external context, 11.5.4

CREATE FUNCTION statement, 11.1

creating, 11.2

defining, 11.1, 11.2

example, 11.7

external context, 11.5.4

external context and parallel aggregation, 11.5.1

implementing, 11.2

large aggregation contexts, 11.5

ODCIAggregate interface, 11.1, 22

ODCIAggregateDelete, 11.5.3, 22.1.1

ODCIAggregateInitialize, 11.1, 22.1.2

ODCIAggregateIterate, 11.1, 22.1.3

ODCIAggregateMerge, 11.1, 22.1.4

ODCIAggregateTerminate, 11.1, 22.1.5

ODCIAggregateWrapContext, 11.5.1, 22.1.6

parallel evaluation, 11.4

reuse for analytic functions, 11.5.3

using, 11.3

using materialized views, 11.6

aggregate function,user-defined

ODCI_AGGREGATE_REUSE_CTX, 11.5.4, 22.1.5

aggregate interface, 22

Alias library, 5.2

ALL_INDEXTYPE_COMMENTS view, 8.3.3

ALL_SECONDARY_OBJECTS view, 8.4.6

ALTER INDEX statement, 8.4.1.2

analytic functions, 11.5.2, 11.5.4

ancillary binding, 9.2.3.2

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

B+trees, 1.3.1.3

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

complex data objects, 1.2

configuration files

naming conventions, 2.3.5

configuration files for external procedures, 5.5

constructor method, 3.3

content, 1.2.1

content of data cartridge, 1.2.1

context

inline, 11.5.1

WITH CONTEXT clause, 5.5.4

conventions

naming, 2.4.1

corruption of package, 4.5.2.3

cost model, 1.3.1.4

CREATE FUNCTION statement, 22, 22.1

aggregate function, 11.1

CREATE TYPE

syntax, 1.3.2.1

CREATE TYPE BODY statement, 4.1.1

CREATE TYPE with OID statement, 3.2

Creating Statistics Table (PowerCartUserStats), 15.5.1

D

data cartridge

complex data objects, 1.2

content, 1.2.1

definition, 1, 1.1

development process, 2.1

domains, 1.2.1

external procedures (guidelines), 5.9

Image, 1.2.1

installation, 2.2

interfaces, 1.3.2.3

key characteristics, 1.1

method, 1.3.1.1.1

naming conventions, 2.4.1

scope, 1.2.1

Spatial, 1.2.1

suggested development approach, 2.4.9

Text, 1.2.1

Video, 1.2.1

data objects, 1.2

datatypes

collection, 1.3.1.1.2

extensibility, 1.3.1.1

REF (relationship), 1.3.1.1.3

reference, 1.3.1.1.3

user-defined type, 1.3.1.1.1

Datatypes, Specifying, 5.5.2

DBA_INDEXTYPE_COMMENTS view, 8.3.3

DBA_SECONDARY_OBJECTS view, 8.4.6

DBMS interfaces, 1.3.2.1

DBMS_LOB package, 6.6

compared with OCI, 6.5

DBMS_STATS package

used in optimizer, 1.3.1.4

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

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

creating, 15.4

parallelizing, with table functions, 13.6

definition, 1.3.1.3

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

execution plan

defintition, 1.3.1.4

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

extensibility

datatypes, 1.3.1.1

indexing, 1.3.1.3

interfaces, 1.3.2

optimizer, 1.3.1.4

server execution environment, 1.3.1.2, 2.3

services, 1.3.1

collections, 1.3.1.1.2

datatypes, 1.3.1.1, 1.3.1.1.1

method, 1.3.1.1.1

reference type, 1.3.1.1.3

extensibility interfaces, 1.1

extensibility services, 1.3.1

extensible database, 1.1

extensible indexing, 1.3.1.3

necessary application processes, 1.3.1.3

necessary database processes, 1.3.1.3

queries benefitting, 15.3.1, 15.3.2

extensible optimizer, 1.3.1.4

external context, 11.5.4

external context and parallel aggregation, 11.5.1

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

foundational data cartridges

Image, 1.2.1

Spatial, 1.2.1

Text, 1.2.1

Video, 1.2.1

G

generic types

See ANYTYPE type

Globalization Support, 2.4.7

globals

naming conventions, 2.3.2

H

hash index, 1.3.1.3

I

Image cartridge, 1.2.1

implementation type, 8.1

index

domain

creating, 15.4

metadata for, 15.4.5.12

index scan, 9.2.1.3

indexing

extensible

queries benefitting, 15.3.2

queries not benefitting, 15.3.1

index-organized table, 7.2

indextype, 8.1

definition, 1.1, 1.3.1.3

indextype implementation methods, 15.4.5

indextypes, 7.2, 16.2

operators and, 9.2

initialization, ODCIAggregate, 11.1

inline, context, 11.5.1

installation directory

naming conventions, 2.3.4

installation of data cartridge, 2.2

interfaces

data cartridge, 1.3.2.3

DBMS, 1.3.2.1

extensibility, 1.3.2

service, 1.3.2.2

internal LOB, 6.1

iteration, ODCIAggregate, 11.1

J

join order, 1.3.1.4

K

Knuth, 7.1.4.1

L

large aggregation contexts, 11.5

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

triggers and, 6.8

value, 6.1

LOBs

overview, 1.3.1.1.4

local domain indexes, 8.7, 16.1

locator

LOB, 6.3

M

Maintaining Context - Java, 18.3

map methods, 3.4

materialized views

user-defined aggregate function, 11.6

member method, 3.1, 4.1

merge, ODCIAggregate, 11.1

message files

naming conventions, 2.3.5

metadata

index, 15.4.5.12

method, 1.3.1.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

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, 11.1, 11.1, 11.1, 22

ODCIAggregateDelete, 22.1.1

ODCIAggregateInitialize, 22.1.2

ODCIAggregateIterate, 22.1.3

ODCIAggregateMerge, 22.1.4

ODCIAggregateTerminate, 22.1.5

ODCIAggregateWrapContext, 22.1.6

overview, 11.1

ODCIAggregateDelete, 11.5.3, 22.1.1

ODCIAggregateInitialize, 11.1, 22.1.2

ODCIAggregateIterate, 11.1, 22.1.3

ODCIAggregateMerge, 11.1, 22.1.4

ODCIAggregateTerminate, 11.1, 22.1.5

ODCIAggregateWrapContext, 11.5.1, 22.1.6

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

Oracle Extensibility Architecture, 1.1

order methods, 3.4

overview, 0

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

parallel aggregation and external context, 11.5.1

Parallel evaluation of user-defined aggregates, 11.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.1.4

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

privileges

required to create procedures, 4.4

purity level, 4.3

R

REF operator, 1.3.1.1.3

reference type, 1.3.1.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

R-trees, 1.3.1.3

S

schema

naming conventions, 2.3.1

scope, 1.2.1

scope of data cartridge, 1.2.1

selectivity, 1.3.1.4

SELF parameter, 4.1.2, 4.1.3

service interfaces, 1.3.2.2

service routine, 18.1

examples, 18.1.1

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

Spatial cartridge, 1.2.1

statistics type

definition, 1.1

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

termination, ODCIAggregate, 11.1

Text cartridge, 1.2.1

transient types

See ANYTYPE type

triggers

with LOBs, 6.8

U

USER_INDEXTYPE_COMMENTS view, 8.3.3

USER_SECONDARY_OBJECTS view, 8.4.6

user-defined operator, 9.1

user-defined type, 1.3.1.1.1

V

Video cartridge, 1.2.1

view

ALL_INDEXTYPE_COMMENTS, 8.3.3

ALL_SECONDARY_OBJECTS, 8.4.6

DBA_INDEXTYPE_COMMENTS, 8.3.3

DBA_SECONDARY_OBJECTS, 8.4.6

USER_INDEXTYPE_COMMENTS, 8.3.3

USER_SECONDARY_OBJECTS, 8.4.6

W

WITH CONTEXT clause and external procedure, 5.5.4