ODCICONST
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose This package is only a specification used to define constants. The constants are the defintions of the object types that are used as parameter datatypes in extensibility routines used for extensible indexing/statistics and external tables. According to Oracle the following ODCIExtTable related definitions should not be documented (internal use only).
AUTHID DEFINER
Constants
Name Data Type Value
Constants for Return Status
Success INTEGER 0
Error INTEGER 1
Warning INTEGER 2
ErrContinue INTEGER 3
Fatal INTEGER 4
Constants for ODCIPredInfo.Flags
PredExactMatch INTEGER 1
PredPrefixMatch INTEGER 2
PredIncludeStart INTEGER 4
PredIncludeStop INTEGER 8
PredObjectFunc INTEGER 16
PredObjectPkg INTEGER 32
PredObjectType INTEGER 64
PredMultiTable INTEGER 128
PredNotEqual INTEGER 256
Constants for ODCIQueryInfo.Flags
QueryFirstRows INTEGER 1
QueryAllRows INTEGER 2
QuerySortAsc INTEGER 4
QuerySortDesc INTEGER 8
QueryBlocking INTEGER 16
Constants for ScnFlg(Func /w Index Context)
CleanupCall INTEGER 1
RegularCall INTEGER 2
Constants for ODCIFuncInfo.Flags
ObjectFunc INTEGER 1
ObjectPkg INTEGER 2
ObjectType INTEGER 4
Constants for ODCIArgDesc.ArgType
ArgOther INTEGER 1
ArgCol INTEGER 2
ArgLit INTEGER 3
ArgAttr INTEGER 4
ArgNull INTEGER 5
ArgCursor INTEGER 6
Constants for ODCIStatsOptions.Options
PercentOption INTEGER 1
RowOption INTEGER 2
Constants for ODCIStatsOptions.Flags
EstimateStats INTEGER 1
ComputeStats INTEGER 2
Validate INTEGER 4
Constants for ODCIIndexAlter parameter alter_option
AlterIndexNone INTEGER 0
AlterIndexRename INTEGER 1
AlterIndexRebuild INTEGER 2
AlterIndexRebuildOnline INTEGER 3
AlterIndexModifyCol INTEGER 4
AlterIndexUpdBlockRefs INTEGER 5
AlterIndexRenameCol INTEGER 6
AlterIndexRenameTab INTEGER 7
AlterIndexMigrate INTEGER 8
Constants for ODCIIndexInfo.IndexInfoFlags
Local INTEGER 1
RangePartn INTEGER 2
HashPartn INTEGER 4
Online INTEGER 8
Parallel INTEGER 16
Unusable INTEGER 32
IndexOnIOT INTEGER 64
TransTblspc INTEGER 128
FunctionIdx INTEGER 256
ListPartn INTEGER 512
UpdateGlobalIndexes INTEGER 1024
RefPartn INTEGER 2048
CompPartn INTEGER 8192
SubPartn INTEGER 16384
Constants for ODCIIndexInfo.IndexParaDegree
DefaultDegree INTEGER 32767
Constants for ODCIEnv. Envflags
DebuggingOn INTEGER 1
NoData INTEGER 2
UserParamString INTEGER 4
RowMigration INTEGER 8
IndexKeyChanged INTEGER 16
Constants for ODCIEnv.CallProperty
None INTEGER 0
FirstCall INTEGER 1
IntermediateCall INTEGER 2
FinalCall INTEGER 3
RebuildIndex INTEGER 4
RebuildPMO INTEGER 5
StatsGlobal INTEGER 6
StatsGlobalAndPartition INTEGER 7
StatsPartition INTEGER 8
Constants for ODCIExtTableInfo.OpCode
FetchOp INTEGER 1
PopulateOp INTEGER 2
Constants for ODCIExtTableInfo.Flag
Sample INTEGER 1
SampleBlock INTEGER 2
Constants for ODCIExtTableQCInfo.IntraSourceConcurrency (OUT) argument
False INTEGER 0
True INTEGER 1
Constants (bit definitions) for 'flag' (IN) argument to ODCIExtTableOpen
QueryCoordinator INTEGER 1
Shadow INTEGER 2
Slave INTEGER 4
Constants (bit definitons) for ODCIExtTableFetch 'flag' OUT argument
FetchEOS INTEGER 1
Constants (bit definitions) for ODCIColInfo.Flags
CompFilterByCol INTEGER 1
CompOrderByCol INTEGER 2
CompOrderDscCol INTEGER 4
CompUpdatedCol INTEGER 8
CompRenamedCol INTEGER 16
CompRenamedTopADT INTEGER 32
CompReferencedCol INTEGER 64
Constants for ODCIOrderByInfo.ExprType
ColumnExpr INTEGER 1
AncOpExpr INTEGER 2
Constants for ODCIOrderByInfo.SortOrder
SortAsc INTEGER 1
SortDesc INTEGER 2
NullsFirst INTEGER 4
Constants for ODCIPartInfo.PartOpt
AddPartition INTEGER 1
DropPartition INTEGER 2
Dependencies
AGGRCENTROID ODCIPREDINFODUMP SDO_STATISTICS
AGGRCONVEXHULL ODCIQUERYINFODUMP SDO_TPIDX
AGGRLRSCONCAT ODCISTATSOPTIONSDUMP SEMCONTEXTINDEXMETHODS
AGGRLRSCONCAT3D ORACLE_BIGDATA SEM_INDEXTYPE_IM
AGGRMBR ORACLE_DATAPUMP SEM_MATCH_NL_IMPL_T
AGGRUNION ORACLE_HDFS SEM_RDFCTX_DR
AVTUNE_LOG_LISTAGGCLOBTYPE ORACLE_HIVE SEM_RDFCTX_IR
CATINDEXMETHODS ORACLE_LOADER SPARQL_GROUP_CONCAT
DBMS_STATS ORA_FI_T SPARQL_GROUP_CONCAT_VC
DBMS_STATS_INTERNAL PRLLIDX_CREATE SPARQL_MAX
DRICON PRVT_IDX SPARQL_MAX_VC
DRIEXP PRVT_SAM SPARQL_MIN
DRISGP QRY2OPT SPARQL_MIN_VC
DRIXMD RDF$DOMSALABEL SPARQL_SAMPLE
DRVDDL RDF_MATCH_IMPL_T SPARQL_SAMPLE_VC
DRVDML RTREE_INDEX_METHOD SPARQL_SERVICE_IMPL_T
DRVLSB RULEINDEXMETHODS TEXTINDEXMETHODS
FUNCSTATS SAMCLUST_IMP_T TEXTOPTSTATS
MDPRVT_IDX SCHEDULER$_BATCHERR_VIEW_T TKHCS_LOG_LISTAGGCLOBTYPE
MVAGGRAWBITOR_TYP SDOAGGR V_LBRECSETIMPL_T
ODCICOLINFOFLAGSDUMP SDO_INDEX_METHOD_10I V_RANGERECSETIMPL_T
ODCIENVDUMP SDO_JOIN XDBHI_IM
ODCIINDEXALTEROPTIONDUMP SDO_PRIDX XDBPI_IM
ODCIINDEXCALLPROPERTYDUMP SDO_SAM XMLIDXSTATSMETHODS
ODCIINDEXINFODUMP SDO_SEM_OPERATOR XMLINDEXMETHODS
ODCIINDEXINFOFLAGSDUMP SDO_SEM_STATS XPATHINDEXMETHODS
ODCIPARTINFODUMP    
Documented No
First Available (1997)
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/catodci.sql
 
Usage Examples
catxdbeo.sql CREATE OR REPLACE TYPE BODY xdb.funcstats IS
 STATIC FUNCTION ODCIGetInterfaces(ifclist OUT sys.ODCIObjectList)
 RETURN NUMBER IS
  BEGIN
    ifclist := sys.ODCIObjectList(sys.ODCIObject('SYS','ODCISTATS2'));
    RETURN ODCIConst.Success;
  END ODCIGetInterfaces;
END;
/
sho err
Errors for TYPE BODY XDB.FUNCSTATS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/35     PLW-07203: parameter 'IFCLIST' may benefit from use of the NOCOPY
         compiler hint

Related Topics
Built-in Functions
Built-in Packages
DBMS_ODCI
OdciVarchar2List
Packages
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx