Oracle® Database Data Cartridge Developer's Guide 11g Release 1 (11.1) Part Number B28425-01 |
|
|
View PDF |
This chapter describes System Defined Constants and System Defined Types, which apply generically to all supported languages. It also describes mappings that are specific to the PL/SQL, C, and Java languages.
This chapter contains these topics:
All the constants referred to in this chapter are 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. To ensure that the database or packet state are not inadvertently corrupted, the following statement is always used with these methods to restrict reads and writes:
pragma restrict_references(ODCIConst, WNDS, RNDS, WNPS, RNPS);
The options described in this section fall into two categories:
Bit-field values that can be combined using the OR
operator: ODCIIndexAlter Options, ODCIIndexInfo.Flags Bits, ODCIIPartInfo.PartOp, ODCIIPredInfo.Flags Bits, ODCIFuncInfo.Flags Bits, ODCIQueryInfo.Flags Bits, ODCIStatsOptions.Flags Bits, ODCIStatsOptions.Options Bits
Distinct values, where only one option can be specified: ODCIArgDesc.ArgType Values, ODCIEnv.CallProperty Values, ScnFlg Values; Function with Index Context, Return Status Values
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 |
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 |
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 |
Table 19-4 ODCIIndexInfo.Flags Bits
Name | Description |
---|---|
Local |
Indicates a local domain index |
RangePartn |
For a local domain index, indicates that the base table is range-partitioned. Is set only in conjunction with the |
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 |
TransTblspc |
Indicates that the domain index is created in a transportable tablespace session. |
FunctionIdx |
Indicates that the index is a function-based domain index |
Table 19-5 ODCIIPartInfo.PartOp
Name | Description |
---|---|
AddPartition |
The partition to be added |
DropPartition |
The partition to be dropped |
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 |
PredObjectTable |
Predicate contains columns from more than one table |
Table 19-7 ODCIFuncInfo.Flags Bits
Name | Description |
---|---|
ObjectFunc |
Standalone function |
ObjectPkg |
Package function |
ObjectType |
Type method |
Table 19-8 ODCIQueryInfo.Flags Bits
Name | Description |
---|---|
QueryFirstRows |
Optimizer mode is |
QueryAllRows |
Optimizer mode is |
Table 19-9 ODCIStatsOptions.Flags Bits
Name | Description |
---|---|
EstimateStats |
Estimate statistics option |
ComputeStats |
Compute exact statistics option |
Validate |
Validate index option |
Table 19-10 ODCIStatsOptions.Options Bits
Name | Description |
---|---|
PercentOption |
Compute statistics by sampling |
RowOption |
Compute statistics based on all rows |
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 |
A number of system-defined types are defined by Oracle and need to 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 Chapter 20 and Chapter 21 use these types as parameters.
Unless otherwise mentioned, the names parsed as type attributes are unquoted identifiers.
Object type. Stores function or operator arguments.
Table 19-13 DCIArgDesc Function and Operator Argument Description - Attributes
Name | Datatype | 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 |
Stores list of rowids. The rowids are stored in their character format.
Datatype
VARRAY(32767) OF VARCHAR2("M_URID_SZ")
Stores column related information.
Datatype
Object type.
Table 19-14 ODCIColInfo Column Related Information - Attributes
Name | Datatype | 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) |
Datatype of column |
ColTypeSchema |
VARCHAR2(30) |
Schema containing datatype if user-defined datatype |
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 |
Object type. Stores cost information.
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 | Datatype | Purpose |
---|---|---|
|
|
|
|
|
|
|
|
Indicates the level of debugging |
Usage Notes
CallProperty
is used only for CREATE INDEX
, DROP INDEX
, TRUNCATE TABLE
, and for some of the extensible optimizer-related calls. In all other cases, including DML and query routines for local domain indexes, it is set to 0
.
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 | Datatype | Purpose |
---|---|---|
IndexSchema |
VARCHAR2(30) |
Schema containing domain index |
IndexName |
VARCHAR2(30) |
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 |
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.
Object type. Contains the names of both the table partition and the index partition.
Table 19-21 ODCIPartInfo Index-Related Information - Attributes
Name | Datatype | Purpose |
---|---|---|
TablePartition |
|
Table partition name |
IndexPartition |
|
Index partition name |
IndexPartitionIden |
NUMBER |
Index partition object identifier |
PartOp |
NUMBRER |
Partition operation that is being performed |
Stores information related to a list of partitions.
Datatype
VARRAY(64000) OF ODCIPartInfo
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 | Datatype | Purpose |
---|---|---|
ObjectSchema |
VARCHAR2(30) |
Schema of operator/function |
ObjectName |
VARCHAR2(30) |
Name of operator/function |
MethodName |
VARCHAR2(30) |
Name of method, applies only to package methods type |
Flags |
NUMBER |
Possible flags are:
|
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 | Datatype | Purpose |
---|---|---|
Flags |
NUMBER |
The following flags can be set:
|
AncOps |
ODCIObjectList |
Ancillary operators referenced in the query |
Object type. Stores options information for DBMS_STATS
.
Table 19-24 ODCIStatsOptions Cost Information - Attributes
Name | Datatype | Purpose |
---|---|---|
Sample |
NUMBER |
Sample size |
Options |
NUMBER |
|
Flags |
NUMBER |
|
Object type. Stores information on which attributes of user-defined types in a collection need to be set by a table function.
Object type. Stores information about the functional implementation of an operator.
Table 19-28 ODCIFuncCallInfo - Attributes
Name | Datatype | 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.
This section describes language-specific mappings.