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_TYPES
Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/dbmsany.sql
Constants
Name Data Type Value
NO_DATA (1) PLS_INTEGER 100
SUCCESS (operation succeeded) PLS_INTEGER 0
TYPECODE_BDOUBLE PLS_INTEGER 101
TYPECODE_BFILE PLS_INTEGER 114
TYPECODE_BFLOAT PLS_INTEGER 100
TYPECODE_BLOB PLS_INTEGER 113
TYPECODE_CFILE PLS_INTEGER 115
TYPECODE_CHAR PLS_INTEGER 96
TYPECODE_CLOB PLS_INTEGER 112
TYPECODE_DATE PLS_INTEGER 12
TYPECODE_INTERVAL_DS PLS_INTEGER 190
TYPECODE_INTERVAL_YM PLS_INTEGER 189
TYPECODE_MLSLABEL PLS_INTEGER 105
TYPECODE_NAMEDCOLLECTION (varray/nested table) PLS_INTEGER 122
TYPECODE_NCHAR PLS_INTEGER 286
TYPECODE_NCLOB PLS_INTEGER 288
TYPECODE_NUMBER PLS_INTEGER 2
TYPECODE_NVARCHAR2 PLS_INTEGER 287
TYPECODE_OBJECT PLS_INTEGER 108
TYPECODE_OPAQUE PLS_INTEGER 58
TYPECODE_RAW PLS_INTEGER 95
TYPECODE_REF PLS_INTEGER 110
TYPECODE_TABLE (nested table collection) PLS_INTEGER 248
TYPECODE_TIMESTAMP PLS_INTEGER 187
TYPECODE_TIMESTAMP_LTZ PLS_INTEGER 232
TYPECODE_TIMESTAMP_TZ PLS_INTEGER 188
TYPECODE_UROWID PLS_INTEGER 104
TYPECODE_VARCHAR2 PLS_INTEGER 9
TYPECODE_VARCHAR PLS_INTEGER 1
TYPECODE_VARRAY PLS_INTEGER 247
(1) Is only relevant if PieceWise is called, for a collection or anydataset. Denotes the end of collection/anydataset when all the elements have been accessed.
Dependencies
DBMS_ANYDATA_LIB DBMS_ANYTYPE_LIB
DBMS_ANYDATASET_LIB MGMT_DELTA
Exceptions
Error Code Reason
ORA-22369 Invalid parameters
ORA-22370 Incorrect usage
ORA-22626 Type mismatch
 
Related Topics
Data Types & Subtypes
DBMS_UTILITY
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [66 users online]    © 2010 psoug.org