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
installation, 2.2
interfaces, 1.3.2.3
key characteristics, 1.1
method, 1.3.1.1.1
naming conventions, 2.4.1
Oracle Multimedia, 1.2.1
Oracle Spatial, 1.2.1
Oracle Text, 1.2.1
scope, 1.2.1
suggested development approach, 2.4.9
data objects, 1.2
data types
collection, 1.3.1.1.2
extensibility, 1.3.1.1
REF (relationship), 1.3.1.1.3
reference, 1.3.1.1.3
specifying, 5.5.2
user-defined type, 1.3.1.1.1
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
data types, 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
data types, 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 data types, 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
Oracle Multimedia, 1.2.1
Oracle Spatial, 1.2.1
Oracle Text, 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

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
Oracle Mutimedia, 1.2.1
Oracle Spatial cartridge, 1.2.1
Oracle Text, 1.2.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
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
tables
index-organized, 7.2
termination, ODCIAggregate, 11.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

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