The DBMS_TYPES
package consists of constants, which represent the built-in and user-defined types. See the Oracle interMedia User's Guide for a complete discussion of types.
This chapter discusses the following topics:
Constants for DBMS_TYPES
The following table lists the constants in the DBMS_TYPES
package.
TYPECODE_DATE |
A DATE type |
TYPECODE_NUMBER |
A NUMBER type |
TYPECODE_RAW |
A RAW type |
TYPECODE_CHAR |
A CHAR type |
TYPECODE_VARCHAR2 |
A VARCHAR2 type |
TYPECODE_VARCHAR |
A VARCHAR type |
TYPECODE_MLSLABEL |
An MLSLABEL type |
TYPECODE_BLOB |
A BLOB type |
TYPECODE_BFILE |
A BFILE type |
TYPECODE_CLOB |
A CLOB type |
TYPECODE_CFILE |
A CFILE type |
TYPECODE_TIMESTAMP |
A TIMESTAMP type |
TYPECODE_TIMESTAMP_TZ |
A TIMESTAMP_TZ type |
TYPECODE_TIMESTAMP_LTZ |
A TIMESTAMP_LTZ type |
TYPECODE_INTERVAL_YM |
A INTERVAL_YM type |
TYPECODE_INTERVAL_DS |
An INTERVAL_DS type |
TYPECODE_REF |
A REF type |
TYPECODE_OBJECT |
An OBJECT type |
TYPECODE_VARRAY |
A VARRAY collection type |
TYPECODE_TABLE |
A nested table collection type |
TYPECODE_NAMEDCOLLECTION |
|
TYPECODE_OPAQUE |
An OPAQUE type |
SUCCESS |
|
NO_DATA |
|
Exceptions
- INVALID_PARAMETERS
- INCORRECT_USAGE
- TYPE_MISMATCH