General Information
Library Note
Morgan's Library Page Header
Purpose
Constants used in the declaration of built-in data types
AUTHID
DEFINER
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
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
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
Created 05/22/2000
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Source
{ORACLE_HOME}/rdbms/admin/dbmsany.sql