Oracle DBMS_TYPES
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Constants used in the declaration of built-in data types
AUTHID NULL
Constants

Note: 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.
Name Data Type Value
SUCCESS (operation succeeded) PLS_INTEGER 0
TYPECODE_VARCHAR PLS_INTEGER 1
TYPECODE_NUMBER PLS_INTEGER 2
TYPECODE_VARCHAR2 PLS_INTEGER 9
TYPECODE_DATE PLS_INTEGER 12
TYPECODE_OPAQUE PLS_INTEGER 58
TYPECODE_RAW PLS_INTEGER 95
TYPECODE_CHAR PLS_INTEGER 96
NO_DATA (1) PLS_INTEGER 100
TYPECODE_BFLOAT PLS_INTEGER 100
TYPECODE_BDOUBLE PLS_INTEGER 101
TYPECODE_UROWID PLS_INTEGER 104
TYPECODE_MLSLABEL PLS_INTEGER 105
TYPECODE_OBJECT PLS_INTEGER 108
TYPECODE_REF PLS_INTEGER 110
TYPECODE_CLOB PLS_INTEGER 112
TYPECODE_BLOB PLS_INTEGER 113
TYPECODE_BFILE PLS_INTEGER 114
TYPECODE_CFILE PLS_INTEGER 115
TYPECODE_NAMEDCOLLECTION (varray/nested table) PLS_INTEGER 122
TYPECODE_TIMESTAMP PLS_INTEGER 187
TYPECODE_TIMESTAMP_TZ PLS_INTEGER 188
TYPECODE_INTERVAL_YM PLS_INTEGER 189
TYPECODE_INTERVAL_DS PLS_INTEGER 190
TYPECODE_TIMESTAMP_LTZ PLS_INTEGER 232
TYPECODE_VARRAY PLS_INTEGER 247
TYPECODE_TABLE (nested table collection) PLS_INTEGER 248
TYPECODE_NCHAR PLS_INTEGER 286
TYPECODE_NVARCHAR2 PLS_INTEGER 287
TYPECODE_NCLOB PLS_INTEGER 288
Dependencies
DBMS_DBFS_CONTENT DBMS_FUSE WWV_FLOW_AJAX
DBMS_DBFS_CONTENT_ADMIN DBMS_LOB_AM_PRIVATE WWV_FLOW_PLUGIN_UTIL
DBMS_DBFS_SFS DBMS_STREAMS_LCR_INT  
Documented Yes
Exceptions
Error Code Reason
ORA-22369 Invalid parameters
ORA-22370 Incorrect usage
ORA-22626 Type mismatch
Security Model Owned by SYS with EXECUTE granted to PUBLIC and the APEX_040200 role
Source {ORACLE_HOME}/rdbms/admin/dbmsany.sql

Related Topics
Data Types & Subtypes
DBMS_UTILITY
Packages

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-2014 Daniel A. Morgan All Rights Reserved