Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)
Part Number A96612-01

Go To Documentation Library

Go To Product List

Go To Table Of Contents

Go To Index

78
DBMS_TYPES

The DBMS_TYPES package consists of constants, which represent the built-in and user-defined types. See Oracle interMedia User's Guide and Reference 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.

Table 78-1 DBMS_TYPES Constants

Constant	Description
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

Go to previous page

Go to next page

Oracle

Copyright © 2000, 2002 Oracle Corporation.
All Rights Reserved.

Go To Documentation Library

Go To Product List

Go To Table Of Contents

Go To Index