Oracle8i Data Cartridge Developer's Guide
Release 8.1.5

A68002-01

Library

Product

Contents

Prev

Index

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


A

alias library, 4-2
attributes of object type, 1-15, 11-2
referencing in method, 5-5

B

binary large object, see BLOB
BLOB, 6-2
EMPTY_BLOB function, 6-4
braces, xix

C

C and C++
debugging DLLs, 4-15
differences from PL/SQL, 5-9
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-7
configuration files for external procedures, 4-5
constructor method, 3-4
context
WITH CONTEXT clause, 4-9
conventions
naming, 2-8
corruption of package, 5-10
CREATE TYPE BODY statement, 5-2
CREATE TYPE with OID statement, 3-3
curly brackets, xix

D

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-8
DBMS interfaces, 1-14
DBMS_LOB package, 6-10
compared with OCI, 6-7
DDL
for LOBs, 6-2
debugging
C code in DLLs, 4-15
common errors, 5-9
PL/SQL, 5-8
demo directory (PL/SQL), 4-10
demo file (extdemo1.sql)
extensible indexing in power demand example, 11-15
directories
installation, 2-6
DLL
debugging, 4-15
naming conventions, 2-7
domain index
creating, 11-15
domain of data cartridge, 1-4

E

electric utility example, 11-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), 11-15
extensibility
datatypes, 1-7
interfaces, 1-13
server execution environment, 1-10, 2-5
services, 1-6
extensible indexing
queries benefitting, 11-14
external library, 1-17
linkage, 1-16
external LOB, 6-2
external procedure
configuration files for, 4-5
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-6
registering, 4-3
specifying datatypes, 4-7
WITH CONTEXT clause, 4-9
extproc process, 4-4

G

globals
naming conventions, 2-5

I

index
domain
creating, 11-15
metadata for, 11-37
indexing
extensible
queries benefitting, 11-14
queries not benefitting, 11-14
index-organized table
not used in power demand example, 11-48
indextype implememntation methods, 11-22
installation directory
naming conventions, 2-6
installation of data cartridge, 2-4
interfaces
data cartridge, 1-14
DBMS, 1-14
extensibility, 1-13
service, 1-14
internal LOB, 6-2

L

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
locator
LOB, 6-3

M

map methods, 3-5
member method, 3-2, 5-2
message files
naming conventions, 2-6
metadata
index, 11-37
method, 1-8, 1-15, 11-2
constructor, 3-4
implementing, 5-2
invoking, 5-4
map, 3-5
member, 3-2, 5-2
order, 3-5
referencing attributes, 5-5

N

name registration, 2-10
naming conventions, 2-8
configuration files, 2-7
error messages, 2-6
globals, 2-5
installation directory, 2-6
message files, 2-6
name format, 2-9
need for, 2-8
registering a name with Oracle, 2-10
schema, 2-5
shared libraries, 2-7
national language support (NLS), 2-12
NCLOB, 6-2
NLS (national language support), 2-12
notation
conventions, xix
rules for, xix

O

object identifier (OID)
with CREATE TYPE, 3-3
object type, 1-8
attributes, 1-15, 11-2
body code, 1-16
comparisons, 3-5
methods, 11-2
specification, 1-15
OCI
LOB manipulation functions, 6-6
OCIExtProcAllocCallmemory(), 13-2, 13-3, 13-4
OCIExtProcAllocMemory routine, 4-12
OCIExtProcRaiseExcp routine, 4-13
OCIExtProcRaiseExcp(), 13-3
OCIExtProcRaiseExcpWithMsg routine, 4-13
OCIExtProcRaiseExcpWithMsg(), 13-4
OCILob...() functions, 6-6
ODCIGetInterfaces method, 11-25
ODCIIndexClose method, 11-33
ODCIIndexCreate method, 11-25
ODCIIndexDelete method, 11-34
ODCIIndexDrop method, 11-27
ODCIIndexFetch method, 11-32
ODCIIndexGetMetadata method, 11-37
ODCIIndexInsert method, 11-33
ODCIIndexStart method, 11-28, 11-30
ODCIIndexUpdate method, 11-35
OID
with CREATE TYPE, 3-3
order methods, 3-5

P

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-10
differences from C and C++, 5-9
packages, 5-5
power demand cartridge example, 11-1
demo file (extdemo1.sql), 11-15
pragma RESTRICT_REFERENCES, 5-6
privileges
required to create procedures, 5-7
purity level, 5-6

R

REF operator, 1-8
registering a data cartridge name, 2-10
registering an external procedure, 4-3
RESTRICT_REFERENCES pragma, 5-6
routine
service, 4-12
RPC time out, 4-14, 5-10

S

schema
naming conventions, 2-5
SELF parameter, 5-4, 5-5
service interfaces, 1-14
service routine, 4-12
examples, 4-12
services
extensibility, 1-6
shared library, 4-2
naming conventions, 2-7
side effect, 5-6
signature mismatch, 5-9
.so files
naming conventions, 2-7
Spatial cartridge
use in power demand example, 11-54
suggested development approach for data cartridge, 2-14

T

Time Series cartridge
use in power demand example, 11-48
triggers
with LOBs, 6-12

W

WITH CONTEXT clause and external procedure, 4-9


Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents