140 DBMS_TYPES

The DBMS_TYPES package consists of constants, which represent the built-in and user-defined types.

This chapter contains the following topics:

Using DBMS_TYPES

The following table lists the constants in the DBMS_TYPES package.

Table 140-1 DBMS_TYPES Constants

Constant	Description
`NO_DATA`	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
`SUCCESS`	The operation succeeded
`TYPECODE_BDOUBLE`	A `NUMBER` type
`TYPECODE_BFILE`	A `BFILE` type
`TYPECODE_BFLOAT`	A `NUMBER` type
`TYPECODE_BLOB`	A `BLOB` type
`TYPECODE_CFILE`	A `CFILE` type
`TYPECODE_CHAR`	A `CHAR` type
`TYPECODE_CLOB`	A `CLOB` type
`TYPECODE_DATE`	A `DATE` type
`TYPECODE_INTERVAL_DS`	An `INTERVAL_DS` type
`TYPECODE_INTERVAL_YM`	A `INTERVAL_YM` type
`TYPECODE_MLSLABEL`	An `MLSLABEL` type
`TYPECODE_NAMEDCOLLECTION`	A named collection (`VARRAY`/nested table) type
`TYPECODE_NCHAR`	A `NCHAR` type
`TYPECODE_NCLOB`	A `NCLOB` type
`TYPECODE_NUMBER`	A `NUMBER` type
`TYPECODE_NVARCHAR2`	A `NVARCHAR2` type
`TYPECODE_OBJECT`	An `OBJECT` type
`TYPECODE_OPAQUE`	An `OPAQUE` type
`TYPECODE_RAW`	A `RAW` type
`TYPECODE_REF`	A `REF` type
`TYPECODE_TABLE`	A nested table collection type
`TYPECODE_TIMESTAMP`	A `TIMESTAMP` type
`TYPECODE_TIMESTAMP_LTZ`	A `TIMESTAMP_LTZ` type
`TYPECODE_TIMESTAMP_TZ`	A `TIMESTAMP_TZ` type
`TYPECODE_UROWID`	A `UROWID` type
`TYPECODE_VARCHAR2`	A `VARCHAR2` type
`TYPECODE_VARCHAR`	A `VARCHAR` type
`TYPECODE_VARRAY`	A `VARRAY` collection type