Index

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

---

Symbols

• .so files
  • naming conventions 2.3.6

---

A

• aggregate function, user-defined 12.1
  • analytic functions 12.5.2, 12.5.4
  • analytic functions and external context 12.5.4
  • creating 12.2
  • defining 12.1, 12.2
  • example 12.7
  • external context 12.5.4
  • external context and parallel aggregation 12.5.1
  • implementing 12.2
  • large aggregation contexts 12.5
  • ODCIAggregateDelete 12.5.3, 22.1.1
  • ODCIAggregateInitialize 12.1, 22.1.2
  • ODCIAggregate interface 12.1, 22
  • ODCIAggregateIterate 12.1, 22.1.3
  • ODCIAggregateMerge 12.1, 22.1.4
  • ODCIAggregateTerminate 12.1, 22.1.5
  • ODCIAggregateWrapContext 12.5.1, 22.1.6
  • parallel evaluation 12.4
  • reuse for analytic functions 12.5.3
  • using 12.3
  • using materialized views 12.6
• aggregate interface 22
• Alias library 5.1
• ALL_INDEXTYPE_COMMENTS view 8.3.3.1
• analytic functions 12.5.2, 12.5.4
• ancillary binding 9.2.3.2
• 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 6.1
• binding 8.1, 9.1.1
• BLOB 6.1
  • EMPTY_BLOB function 6.4
• B-tree indexing algorithm 7.1.4.1

---

C

• callback
  • restrictions 5.5.1
• Callback Restrictions 5.5.1
• C and C++
  • debugging DLLs 5.7.2
  • differences from PL/SQL 4.2.1
• character large object, see CLOB 6.1
• 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.4
• constructor method 3.3
• content 1.2.1
• content of data cartridge 1.2.1
• context
  • inline 12.5.1
  • WITH CONTEXT clause 5.4.6
• conventions
  • naming 2.4.1
• corruption of package 4.2.2.3
• cost model 1.3.1.4
• CREATE FUNCTION statement 22, 22.1
• CREATE LIBRARY
  • CREDENTIAL option 5.1.1
  • DIRECTORY object option 5.1.1
• CREATE TYPE
  • syntax 1.3.2
• 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.8
  • installation 2.2
  • interfaces 1.3.2
  • key characteristics 1.1
  • method 1.3.1.1.1
  • naming conventions 2.4.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.4.4
  • user-defined type 1.3.1.1.1
• DBA_INDEXTYPE_COMMENTS view 8.3.3.1
• DBA_SECONDARY_OBJECTS view 8.4.6
• DBMS_LOB package 6.6
  • compared with OCI 6.5
• DBMS_STATS package
  • used in optimizer 1.3.1.4
• DBMS interfaces 1.3.2
• DDL
  • for LOBs 6.1, 6.2
• DEBUG_EXTPROC, Using 5.7.1
• debugging
  • C code in DLLs 5.7.2
  • common errors 4.2.2
  • PL/SQL 4.2
• Debugging External Procedures 5.7
• demo directory (PL/SQL) 18.1.4
• demo file (extdemo1.sql)
  • extensible indexing in power demand example 15.4
• directories
  • installation 2.3.4
• DIRECTORY Object Option 5.1.1.3
• DLL
  • debugging 5.7.2
  • naming conventions 2.3.6
• domain index 7.2, 8.1
• domain indexes 7.2, 8.4
  • creating 15.4
    • parallelizing, with table functions 13.6
  • definition 1.3.1.3
  • exporting and importing 8.4.4
  • loading 8.7.10
  • 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 indexing framework 7.2
• extensible optimizer 1.3.1.4
• external context 12.5.4
• external context and parallel aggregation 12.5.1
• external LOB 6.1
• external procedure
  • configuration files for 5.4
  • guidelines 5.8
  • guidelines for using with data cartridge 5.8
  • how PL/SQL calls 5.3
  • LOBs in 6.7
  • OCI access functions 18.1
  • overview 5.2
  • PARAMETERS clause 5.4.5
  • passing parameters to 5.4.3
  • registering 5.2.1
  • specifying data types 5.4.4
  • WITH CONTEXT clause 5.4.6
• External Procedures, Debugging 5.7
• extproc process 5.8

---

F

• foundational data cartridges
  • 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.6.11
• indexing
  • extensible
    • queries benefitting 15.3.2
    • queries not benefitting 15.3.1
• index-organized table 7.2
• index scan 9.2.1.3
• 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 12.1
• inline, context 12.5.1
• installation directory
  • naming conventions 2.3.4
• installation of data cartridge 2.2
• interfaces
  • data cartridge 1.3.2
  • DBMS 1.3.2
  • extensibility 1.3.2
  • service 1.3.2
• internal LOB 6.1
• iteration, ODCIAggregate 12.1

---

J

• join order 1.3.1.4

---

K

• Knuth 7.1.4.1

---

L

• large aggregation contexts 12.5
• large object, see LOB 6.1
• library
  • alias 5.1
  • shared 2.3.6, 5.1
• LOB
  • DDL for 6.1, 6.2
  • external 6.1
  • external procedure use 6.7
  • internal 6.1
  • 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

---

M

• Maintaining Context - Java 18.3
• map methods 3.4
• materialized views
  • user-defined aggregate function 12.6
• member method 3.1, 4.1
• merge, ODCIAggregate 12.1
• message files
  • naming conventions 2.3.5
• metadata
  • index 15.4.6.11
• 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 2.4.7
• NCLOB 6.1
• NLS (national language support). See Globalization Support 2.4.7

---

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
• ODCIAggregateDelete 12.5.3, 22.1.1
• ODCIAggregateInitialize 12.1, 22.1.2
• ODCIAggregate interface 12.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 12.1
• ODCIAggregateIterate 12.1, 22.1.3
• ODCIAggregateMerge 12.1, 22.1.4
• ODCIAggregateTerminate 12.1, 22.1.5
• ODCIAggregateWrapContext 12.5.1, 22.1.6
• ODCIGetInterfaces method 15.4.6.1
• ODCIIndexClose method 15.4.6.7
• ODCIIndexCreate method 15.4.6.2
• ODCIIndexDelete method 15.4.6.9
• ODCIIndexDrop method 15.4.6.3
• ODCIIndexFetch method 15.4.6.6
• ODCIIndexGetMetadata method 15.4.6.11
• ODCIIndexInsert method 15.4.6.8
• ODCIIndexStart method 15.4.6.4, 15.4.6.5
• ODCIIndexUpdate method 15.4.6.10
• OID
  • with CREATE TYPE 3.2
• operator 7.2
• Oracle Extensibility Architecture 1.1
• Oracle Spatial cartridge 1.2.1
• Oracle Text 1.2.1
• order methods 3.4
• overview , 1

---

P

• packages
  • corruption 4.2.2.3
• parallel aggregation and external context 12.5.1
• Parallel evaluation of user-defined aggregates 12.4
• PARAMETERS clause with external procedure 5.4.5
• partitioning method
  • HASH 13.4.2
  • RANGE 13.4.2
• PL/SQL
  • DBMS_LOB package compared with OCI 6.5
  • debugging 4.2
  • demo directory 18.1.4
  • differences from C and C++ 4.2.1
• power demand cartridge example 15
  • demo file (extdemo1.sql) 15.4
• primary binding 9.2.3.1

---

R

• reference type 1.3.1.1.3
• REF operator 1.3.1.1.3
• registering an external procedure 5.2.1
• Restrictions on Callbacks 5.5.1
• routine
  • service 18.1
• RPC time out 4.2.2.2, 5.6.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 routine 18.1
  • examples 18.1.1
• shared library 5.1
  • naming conventions 2.3.6
• signature 9.1.1
• signature mismatch 4.2.2.1
• statistics type
  • definition 1.1
• suggested development approach for data cartridge 2.4.9

---

T

• table functions
  • parallel execution of 13.2.4, 13.4
  • partitioning input 13.4.2
  • pipelined 13.2.3, 13.3.1, 13.3.4
  • querying 13.3.7
• tables
  • index-organized 7.2
• termination, ODCIAggregate 12.1
• transient types
  • See: ANYTYPE type
• triggers
  • with LOBs 6.8

---

U

• USER_INDEXTYPE_COMMENTS view 8.3.3.1
• user-defined operator 9.1
• user-defined type 1.3.1.1.1

---

V

• view
  • ALL_INDEXTYPE_COMMENTS 8.3.3.1
  • DBA_INDEXTYPE_COMMENTS 8.3.3.1
  • DBA_SECONDARY_OBJECTS 8.4.6
  • USER_INDEXTYPE_COMMENTS 8.3.3.1

---

W

• WITH CONTEXT clause and external procedure 5.4.6