Oracle DBMS_INDEXING
Version 11.2.0.3
 
General Information
Note: Contains specs. for packages and types used in DBMS extensibility infrastructure (Indexing, optimizer etc.). Not built by the default installation.
Source {ORACLE_HOME}/rdbms/admin/dbmsindx.sql
Constants
Name Data Type Value
 Data Types
TYPECODE_DATE BINARY_INTEGER 12
TYPECODE_NUMBER BINARY_INTEGER 2
TYPECODE_RAW BINARY_INTEGER 95
TYPECODE_CHAR BINARY_INTEGER 96
TYPECODE_VARCHAR2 BINARY_INTEGER 9
TYPECODE_VARCHAR BINARY_INTEGER 1
TYPECODE_MLSLABEL BINARY_INTEGER 105
TYPECODE_BLOB BINARY_INTEGER 113
TYPECODE_BFILE BINARY_INTEGER 114
TYPECODE_CLOB BINARY_INTEGER 112
TYPECODE_CFILE BINARY_INTEGER 115
RowType.RT_AddUserType() Types
TYPECODE_REF BINARY_INTEGER 110
TYPECODE_OBJECT BINARY_INTEGER 108
TYPECODE_VARRAY BINARY_INTEGER 247
TYPECODE_TABLE BINARY_INTEGER 248
Exceptions
Exception Description
ORA-22369 invalid_parameters
ORA-22370 incorrect_usage
Security Model Execute is granted to PUBLIC
 
Related Topics
Data Types & Sub Types
 
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-2013 Daniel A. Morgan All Rights Reserved