Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-01

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

Oracle

Copyright © 1996-2001, Oracle Corporation.
All Rights Reserved.