CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
HOME | BROWSE | GROUPS | REFERENCE | ADD CODE | LINKS | SPONSORS
It's time to sign up for your 2010 PSOUG membership!
Click here to join PSOUG now!
Search the Reference Library pages:  
Help us help you! Take our 1-minute PSOUG survey. Free Oracle Magazines & Oracle White Papers

Oracle DBMS_INDEXING
Version 11.1
 
General
Note: Contains specs. for packages and types used in DBMS extensibility infrastructure (Indexing, optimizer etc.).
Source {ORACLE_HOME}/rdbms/admin/dbmsindx.sql
Data Types CREATE OR REPLACE TYPE 

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

-22369

invalid_parameters

-22370

incorrect_usage
Security Model Execute is granted to PUBLIC
 
Related Topics
Data Types & Sub Types
 
Contact Us Legal Notices and Terms of UsePrivacy Statement
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [48 visitors online]    © 2009 psoug.org