Oracle DBMS_TYPES
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Constants used in the declaration of built-in data types
AUTHID NULL
Constants

* 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 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_LOB_AM_PRIVATE SDO_RDF_INTERNAL
DBMS_DBFS_CONTENT_ADMIN DBMS_STREAMS_LCR_INT SEM_MATCH_NL_IMPL_T
DBMS_DBFS_SFS RDF_MATCH_IMPL_T SPARQL_SERVICE_IMPL_T
DBMS_FUSE    
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
Source {ORACLE_HOME}/rdbms/admin/dbmsany.sql

Related Topics
Data Types & Subtypes
DBMS_UTILITY
Packages
What's New In 12cR1
What's New In 12cR2

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