René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

dbms_types

Constants

dbms_types doesn't seem to exhibit any functionality, only constants. These are:

no_data

success

typecode_bdouble

typecode_bfile

typecode_bfloat

typecode_blob

typecode_cfile

typecode_char

typecode_clob

typecode_date

typecode_interval_ds

typecode_interval_ym

typecode_mlslabel

typecode_namedcollection

typecode_number

typecode_object

typecode_opaque

typecode_raw

typecode_ref

typecode_table

typecode_timestamp

typecode_timestamp_ltz

typecode_timestamp_tz

typecode_varchar2

typecode_varchar

typecode_varray

Misc

Find an example here where dbms_types is used.
See also Oracle data types.