Oracle | DBMS

Oracle DBMS_TYPES Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose

Constants used in the declaration of built-in data types

AUTHID

NULL

Constants

* 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.

Name	Data Type	Value
SUCCESS (operation succeeded)	PLS_INTEGER	0
TYPECODE_VARCHAR	PLS_INTEGER	1
TYPECODE_NUMBER	PLS_INTEGER	2
TYPECODE_VARCHAR2	PLS_INTEGER	9
TYPECODE_DATE	PLS_INTEGER	12
TYPECODE_OPAQUE	PLS_INTEGER	58
TYPECODE_RAW	PLS_INTEGER	95
TYPECODE_CHAR	PLS_INTEGER	96
NO_DATA	PLS_INTEGER	100
TYPECODE_BFLOAT	PLS_INTEGER	100
TYPECODE_BDOUBLE	PLS_INTEGER	101
TYPECODE_UROWID	PLS_INTEGER	104
TYPECODE_MLSLABEL	PLS_INTEGER	105
TYPECODE_OBJECT	PLS_INTEGER	108
TYPECODE_REF	PLS_INTEGER	110
TYPECODE_CLOB	PLS_INTEGER	112
TYPECODE_BLOB	PLS_INTEGER	113
TYPECODE_BFILE	PLS_INTEGER	114
TYPECODE_CFILE	PLS_INTEGER	115
TYPECODE_NAMEDCOLLECTION (varray/nested table)	PLS_INTEGER	122
TYPECODE_TIMESTAMP	PLS_INTEGER	187
TYPECODE_TIMESTAMP_TZ	PLS_INTEGER	188
TYPECODE_INTERVAL_YM	PLS_INTEGER	189
TYPECODE_INTERVAL_DS	PLS_INTEGER	190
TYPECODE_TIMESTAMP_LTZ	PLS_INTEGER	232
TYPECODE_VARRAY	PLS_INTEGER	247
TYPECODE_TABLE (nested table collection)	PLS_INTEGER	248
TYPECODE_NCHAR	PLS_INTEGER	286
TYPECODE_NVARCHAR2	PLS_INTEGER	287
TYPECODE_NCLOB	PLS_INTEGER	288

Dependencies

DBMS_DBFS_CONTENT	DBMS_LOB_AM_PRIVATE	SDO_RDF_INTERNAL
DBMS_DBFS_CONTENT_ADMIN	DBMS_STREAMS_LCR_INT	SEM_MATCH_NL_IMPL_T
DBMS_DBFS_SFS	ORA_FI_T	SPARQL_SERVICE_IMPL_T
DBMS_FUSE	RDF_MATCH_IMPL_T

Documented

Yes

Exceptions

Error Code	Reason
ORA-22369	Invalid parameters
ORA-22370	Incorrect usage
ORA-22626	Type mismatch

First Available

Not Known

Security Model

Owned by SYS with EXECUTE granted to PUBLIC

Source

{ORACLE_HOME}/rdbms/admin/dbmsany.sql