68
DBMS_TYPES

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

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