19 Extensibility Constants, Types, and Mappings
System Defined Constants and System Defined Types apply generically to all supported languages, as well as mappings that are specific to the PL/SQL, C, and Java languages.
Parent topic: Reference
19.1 System Defined Constants
Consider the constants defined in the ODCIConst
package installed as part of the catodci.sql
script. There are equivalent definitions for use within C routines in odci.h
. You should use these constants instead of hard coding their underlying values in your routines.
The system defined constants fall into two broad categories:
-
Bit-field values that may be combined using the
OR
operator: Table 19-3, Table 19-4, Table 19-5, Table 19-6, Table 19-7, Table 19-8, Table 19-9, Table 19-10 -
Distinct values, where only one option may be specified: Table 19-1, Table 19-2, Table 19-12, Table 19-11
- ODCIArgDesc.ArgType System Defined Constants
- ODCIEnv.CallProperty System Defined Constants
- ODCIIndexAlter System Defined Constants
- ODCIIndexInfo.Flags System Defined Constants
- ODCIIPartInfo.PartOp System Defined Constants
- ODCIIPredInfo.Flags System Defined Constants
- ODCIFuncInfo.Flags System Defined Constants
- ODCIQueryInfo.Flags System Defined Constants
- ODCIStatsOptions.Flags System Defined Constants
- ODCIStatsOptions.Options System Defined Constants
- Return Status System Defined Constants
- ScnFlg System Defined Constants
Parent topic: Extensibility Constants, Types, and Mappings
19.1.1 ODCIArgDesc.ArgType System Defined Constants
Table 19-1 ODCIArgDesc.ArgType Values
Name | Description |
---|---|
ArgOther |
Argument is other expression |
ArgCol |
Argument is a column name |
ArgLit |
Argument is a literal value |
ArgAttr |
Argument is an ADT |
ArgCursor |
Argument is a |
ArgNull |
Argument is |
Parent topic: System Defined Constants
19.1.2 ODCIEnv.CallProperty System Defined Constants
Table 19-2 ODCIEnv.CallProperty Values
Name | Description |
---|---|
None |
Default option |
FirstCall |
First partition call |
Intermediate Call |
Intermediate partition call |
FinalCall |
Final call after last partition |
StatsGlobal |
Used to specify global statistics gathering |
StatsGlobalAndPartition |
Used to specify global and partition-level statistics gathering |
StatsPartition |
Used to specify partition-level statistics gathering |
Parent topic: System Defined Constants
19.1.3 ODCIIndexAlter System Defined Constants
Table 19-3 ODCIIndexAlter Options
Name | Description |
---|---|
AlterIndexNone |
Default option |
AlterIndexRename |
Rename Partition option |
AlterIndexRebuild |
Rebuild Index option |
AlterIndexUpdBlockRefs |
IOT update block references |
AlterIndexMigrate |
Migrate user-managed domain index to a system-managed domain index. |
AlterIndexRenameCol |
Rename the column on which the domain index is based |
AlterIndexRenameTab |
Rename the table on which the domain index is based |
Parent topic: System Defined Constants
19.1.4 ODCIIndexInfo.Flags System Defined Constants
Table 19-4 ODCIIndexInfo.Flags Bits
Name | Bits Value | Description |
---|---|---|
Local |
|
Indicates a local domain index |
Parallel |
|
Indicates that a parallel degree was specified for the index creation or alter operation |
Unusable |
|
Indicates that |
IndexOnIOT |
|
Indicates that the domain index is defined on an index-organized table |
RangePartn |
|
For a local domain index, indicates that the base table is range-partitioned. Is set only in conjunction with the |
ListPartn |
|
For a local domain index, indicates that the base table is list-partitioned. Is set only in conjunction with the |
HashPartn |
|
For a local domain index, indicates that the base table is hash-partitioned. Is set only in conjunction with the |
TransTblspc |
|
Indicates that the domain index is created in a transportable tablespace session. |
FunctionIdx |
|
Indicates that the index is a function-based domain index |
Online |
|
Indicates an online domain index |
UpdateGlobalIndexes |
|
Indicates that the index is an updated global domain index |
RefPartn |
|
For a local domain index, indicates that the base table is reference-partitioned. Is set only in conjunction with the |
CompPartn |
|
For a local domain index, indicates that the base table is composite partitioned. Is set in conjunction with the Local bit and the |
SubPartn |
|
For a local domain index, indicates that the partition information for the current call refers to a subpartition. Is set in conjunction with the |
Parent topic: System Defined Constants
19.1.5 ODCIIPartInfo.PartOp System Defined Constants
Table 19-5 Description of the ODCIIPartInfo.PartOp System Defined Constant
Name | Description |
---|---|
AddPartition |
The partition to be added |
DropPartition |
The partition to be dropped |
Parent topic: System Defined Constants
19.1.6 ODCIIPredInfo.Flags System Defined Constants
Table 19-6 ODCIIPredInfo.Flags Bits
Name | Description |
---|---|
PredExactMatch |
Equality predicate |
PredPrefixMatch |
|
PredIncludeStart |
Include start value in index range scan |
PredIncludeStop |
Include stop value in index range scan |
PredObjectFunc |
Left hand side of predicate is a standalone function |
PredObjectPkg |
Left hand side of predicate is a package function |
PredObjectType |
Left hand site of predicate is a type method |
PredMultiTable |
Predicate contains columns from several tables |
PredNotEqual |
Inequality predicate |
Parent topic: System Defined Constants
19.1.7 ODCIFuncInfo.Flags System Defined Constants
Table 19-7 ODCIFuncInfo.Flags Bits
Name | Description |
---|---|
ObjectFunc |
Standalone function |
ObjectPkg |
Package function |
ObjectType |
Type method |
Parent topic: System Defined Constants
19.1.8 ODCIQueryInfo.Flags System Defined Constants
Table 19-8 ODCIQueryInfo.Flags Bits
Name | Description |
---|---|
QueryFirstRows |
Optimizer mode is |
QueryAllRows |
Optimizer mode is |
Parent topic: System Defined Constants
19.1.9 ODCIStatsOptions.Flags System Defined Constants
Table 19-9 ODCIStatsOptions.Flags Bits
Name | Description |
---|---|
EstimateStats |
Estimate statistics option |
ComputeStats |
Compute exact statistics option |
Validate |
Validate index option |
Parent topic: System Defined Constants
19.1.10 ODCIStatsOptions.Options System Defined Constants
Table 19-10 ODCIStatsOptions.Options Bits
Name | Description |
---|---|
PercentOption |
Compute statistics by sampling |
RowOption |
Compute statistics based on all rows |
Parent topic: System Defined Constants
19.1.11 Return Status System Defined Constants
Table 19-11 Return Status Values
Name | Description |
---|---|
Success |
Indicates a successful operation. |
Error |
Indicates an error. |
Warning |
Indicates a warning. |
ErrContinue |
Indicates that there is an error in an index partition, but continues to work on the next partition. |
Fatal |
Indicates that all dictionary entries of the index are cleaned up, and that the |
Parent topic: System Defined Constants
19.1.12 ScnFlg System Defined Constants
Table 19-12 ScnFlg Values; Function with Index Context
Name | Description |
---|---|
RegularCall |
User defined operator regular call |
CleanupCall |
User defined operator cleanup call |
Parent topic: System Defined Constants
19.2 System-Defined Types
Several system-defined types are defined by Oracle and must be created by running the catodci.sql
catalog script. The C mappings for these object types are defined in odci.h
. The ODCIIndex
and ODCIStats
routines described in Extensible Indexing Interface and Extensible Optimizer Interface use these types as parameters.
Unless otherwise mentioned, the names parsed as type attributes are unquoted identifiers.
- ODCIArgDesc
- ODCIArgDescList
- ODCIRidList
- ODCIColInfo
- ODCIColInfoList
- ODCICost
- ODCIEnv
- ODCIFuncInfo
- ODCIIndexInfo
- ODCIIndexCtx
- ODCIObject
- ODCIObjectList
- ODCIPartInfo
- ODCIPartInfoList
- ODCIPredInfo
- ODCIQueryInfo
- ODCIStatsOptions
- ODCITabFuncStats
- ODCITabStats
- ODCIBFileList
- ODCITabFuncInfo
- ODCIDateList
- ODCINumberList
- ODCIRawList
- ODCIVarchar2List
- ODCIFuncCallInfo
Parent topic: Extensibility Constants, Types, and Mappings
19.2.1 ODCIArgDesc
Object type. Stores function or operator arguments.
Table 19-13 ODCIArgDesc Function and Operator Argument Description - Attributes
Name | Data Type | Description |
---|---|---|
ArgType |
NUMBER |
Argument type |
TableName |
VARCHAR2(30) |
Name of table |
TableSchema |
VARCHAR2(30) |
Schema containing the table |
ColName |
VARCHAR2(4000) |
Name of column. This could be top level column name such as "A", or a nested column "A"."B" Note that the column name are quoted identifiers. |
TablePartitionLower |
VARCHAR2(30) |
Contains the name of the lowest table partition that is accessed in the query |
TablePartitionUpper |
VARCHAR2(30) |
Contains the name of the highest table partition that is accessed in the query |
Cardinality |
NUMBER |
Cardinality value for |
Parent topic: System-Defined Types
19.2.2 ODCIArgDescList
Contains a list of argument descriptors
Data Type
VARRAY(32767) of ODCIArgDesc
Parent topic: System-Defined Types
19.2.3 ODCIRidList
Stores list of rowids. The rowids are stored in their character format.
Data Type
VARRAY(32767) OF VARCHAR2("M_URID_SZ")
Parent topic: System-Defined Types
19.2.4 ODCIColInfo
Stores column related information.
Data Type
Object type.
Table 19-14 ODCIColInfo Column Related Information - Attributes
Name | Data Type | Purpose |
---|---|---|
TableSchema |
VARCHAR2(30) |
Schema containing table |
TableName |
VARCHAR2(30) |
Name of table |
ColName |
VARCHAR2(4000) |
Name of column. This could be top level column name such as "A", or a nested column "A"."B" Note that the column name are quoted identifiers. |
ColTypeName |
VARCHAR2(30) |
Data Type of column |
ColTypeSchema |
VARCHAR2(30) |
Schema containing data type if user-defined data type |
TablePartition |
VARCHAR2(30) |
For a local domain index, contains the name of the specific base table partition |
TablePartitionIden |
NUMBER |
Base table partition physical identifier |
TablePartitionTotal |
NUMBER |
Total number of partitions in a table |
Parent topic: System-Defined Types
19.2.5 ODCIColInfoList
Stores information related to a list of columns.
Data Type
VARRAY(32) OF ODCIColInfo
Parent topic: System-Defined Types
19.2.6 ODCICost
Object type. Stores cost information.
Table 19-15 ODCICost Cost Information - Attributes
Name | Data Type | Purpose |
---|---|---|
|
|
CPU cost |
|
|
I/O cost |
|
|
Communication cost |
|
|
Optional user-supplied information about the domain index for display in the |
Parent topic: System-Defined Types
19.2.7 ODCIEnv
Object type. Contains general information about the environment in which the extensibility routines are executing.
Table 19-16 ODCIEnv Environment Variable Descriptor Information - Attributes
Name | Data Type | Purpose |
---|---|---|
|
|
|
|
|
|
|
|
Indicates the level of debugging |
Usage Notes
CallProperty
is used only for CREATE INDEX
, DROP INDEX
, TRUNCATE TABLE
, and for some extensible optimizer-related calls. In all other cases, including DML and query routines for local domain indexes, it is set to 0
.
Parent topic: System-Defined Types
19.2.8 ODCIFuncInfo
Object type. Stores functional information.
Table 19-17 ODCIFuncInfo Function Information - Attributes
Name | Data Type | Purpose |
---|---|---|
|
|
Object schema name |
|
|
Function/package/type name |
|
|
Method name for package/type |
|
|
Function flags - see |
Parent topic: System-Defined Types
19.2.9 ODCIIndexInfo
Object type. Stores the metadata information related to a domain index. It is passed as a parameter to all ODCIIndex
routines.
Table 19-18 ODCIIndexInfo Index Related Information - Attributes
Name | Data Type | Purpose |
---|---|---|
IndexSchema |
|
Schema containing domain index |
IndexName |
|
Name of domain index |
IndexCols |
ODCIColInfoList |
List of indexed columns |
IndexPartition |
VARCHAR2(30) |
For a local domain index, contains the name of the specific index partition |
IndexInfoFlags |
NUMBER |
Possible flags are:
|
IndexParaDegree |
NUMBER |
The degree of parallelism, if one is specified when creating or rebuilding a domain index or local domain index partition in parallel |
IndexPartitionIden |
NUMBER |
The index partition object identifier, for local domain indexes |
IndexPartitionTotal |
NUMBER |
The total number of partitions in an index |
Parent topic: System-Defined Types
19.2.10 ODCIIndexCtx
Object type. Stores the index context, including the domain index metadata and the rowid. It is passed as parameter to the functional implementation of an operator that expects index context.
Table 19-19 ODCIIndexCtx Index Context Related Information - Attributes
Name | Data Type | Purpose |
---|---|---|
|
|
Stores the metadata information about the domain index |
|
|
Row identifier of the current row |
Parent topic: System-Defined Types
19.2.11 ODCIObject
Object type. Stores information about a schema object.
Table 19-20 ODCIObject Index Context Related Information - Attributes
Name | Data Type | Purpose |
---|---|---|
|
|
Name of schema in which object is located |
|
|
Name of object |
Parent topic: System-Defined Types
19.2.12 ODCIObjectList
Stores information about a list of schema objects.
Data Type
VARRAY(32) OF ODCIObject
Parent topic: System-Defined Types
19.2.13 ODCIPartInfo
Object type. Contains the names of both the table partition and the index partition.
Table 19-21 ODCIPartInfo Index-Related Information - Attributes
Name | Data Type | Purpose |
---|---|---|
TablePartition |
|
Table partition name |
IndexPartition |
|
Index partition name |
IndexPartitionIden |
NUMBER |
Index partition object identifier |
PartOp |
NUMBRER |
Partition operation that is being performed |
Parent topic: System-Defined Types
19.2.14 ODCIPartInfoList
Stores information related to a list of partitions.
Data Type
VARRAY(64000) OF ODCIPartInfo
Parent topic: System-Defined Types
19.2.15 ODCIPredInfo
Object type. Stores the metadata information related to a predicate containing a user-defined operator or function. It is also passed as a parameter to the ODCIIndexStart() query routine.
Table 19-22 ODCIPredInfo Operator Related Information - Attributes
Name | Data Type | Purpose |
---|---|---|
ObjectSchema |
|
Schema of operator/function |
ObjectName |
|
Name of operator/function |
MethodName |
|
Name of method, applies only to package methods type |
Flags |
|
Possible flags are:
|
Parent topic: System-Defined Types
19.2.16 ODCIQueryInfo
Object type. Stores information about the context of a query. It is passed as a parameter to the ODCIIndexStart() routine.
Table 19-23 ODCIQueryInfo Index Context Related Information - Attributes
Name | Data Type | Purpose |
---|---|---|
|
|
The following flags can be set:
|
|
|
Ancillary operators referenced in the query |
Parent topic: System-Defined Types
19.2.17 ODCIStatsOptions
Object type. Stores options information for DBMS_STATS
.
Parent topic: System-Defined Types
19.2.18 ODCITabFuncStats
Object type. Stores cardinality information for a table function.
Table 19-25 ODCITabFuncStats Parameter
Parameter | Data Type | Purpose |
---|---|---|
|
|
Contains the number of rows expected to be returned by the table function |
Parent topic: System-Defined Types
19.2.19 ODCITabStats
Stores table statistics for a table function.
Data Type
NUMBER
Table 19-26 ODCITabStats - Attributes
Name | Data Type | Purpose |
---|---|---|
|
|
Number of rows in table |
Parent topic: System-Defined Types
19.2.20 ODCIBFileList
Stores varray
s of BFILE
s.
Data Type
VARRAY(32767) OF BFILE
Parent topic: System-Defined Types
19.2.21 ODCITabFuncInfo
Object type. Stores information on which attributes of user-defined types in a collection must be set by a table function.
Table 19-27 ODCITabFuncInfo Parameters
Name | Data Type | Purpose |
---|---|---|
|
|
Indicates the attributes that must be set |
|
|
For |
Parent topic: System-Defined Types
19.2.22 ODCIDateList
Stores varray
s of DATE
s.
Data Type
VARRAY(32767) OF DATE
Parent topic: System-Defined Types
19.2.23 ODCINumberList
Stores varray
s of NUMBER
s.
Data Type
VARRAY(32767) OF NUMBER
Parent topic: System-Defined Types
19.2.24 ODCIRawList
Stores varray
s of Raw
s.
Data Type
VARRAY(32767) OF Raw(2000)
Parent topic: System-Defined Types
19.2.25 ODCIVarchar2List
Stores varray
s of VARCHAR2
s
Data Type
VARRAY(32767) OF VARCHAR2(4000)
Parent topic: System-Defined Types
19.2.26 ODCIFuncCallInfo
Object type. Stores information about the functional implementation of an operator.
Table 19-28 ODCIFuncCallInfo - Attributes
Name | Data Type | Purpose |
---|---|---|
|
|
Information about the column on which the operator is invoked |
Usage Notes
A functional implementation can be defined with this parameter only if the operator binding is declared WITH COLUMN CONTEXT
. This is useful if the functional implementation requires information about the column it was invoked on, and there is no domain index defined on the column. This argument is only populated in the function invocation if the first argument of the operator invocation is a column and there is no domain index defined on that column.
Parent topic: System-Defined Types
19.3 Mappings of Constants and Types
Consider language-specific constant and type mappings.
19.3.1 Mappings in PL/SQL
A variety of PL/SQL mappings are common to both Extensible Indexing and the Extensible Optimizer.
-
Constants are defined in the
ODCIConst
package found incatodci.sql
-
Types are defined as object types found in
catodci.sql
Parent topic: Mappings of Constants and Types
19.3.2 Mappings in C
Mappings of constants and types are defined for C in the public header file odci.h
. Each C structure to which a type is mapped has a corresponding indicator structure called structname_ind
and a reference definition called structname_ref
.
Parent topic: Mappings of Constants and Types