Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
10g Release 2 (10.2)

Part Number B14258-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

115 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


Constants

The following table lists the constants in the DBMS_TYPES package.

Table 115-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_NUMBER A NUMBER 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_VARCHAR2 A VARCHAR2 type
TYPECODE_VARCHAR A VARCHAR type
TYPECODE_VARRAY A VARRAY collection type


Exceptions