CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and 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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [61 users online]    © 2010 psoug.org