General Information |
Source |
{ORACLE_HOME}/rdbms/admin/dbmsany.sql |
Constants |
Name |
Data Type |
Value |
NO_DATA (1) |
PLS_INTEGER |
100 |
SUCCESS (operation succeeded) |
PLS_INTEGER |
0 |
TYPECODE_BDOUBLE |
PLS_INTEGER |
101 |
TYPECODE_BFILE |
PLS_INTEGER |
114 |
TYPECODE_BFLOAT |
PLS_INTEGER |
100 |
TYPECODE_BLOB |
PLS_INTEGER |
113 |
TYPECODE_CFILE |
PLS_INTEGER |
115 |
TYPECODE_CHAR |
PLS_INTEGER |
96 |
TYPECODE_CLOB |
PLS_INTEGER |
112 |
TYPECODE_DATE |
PLS_INTEGER |
12 |
TYPECODE_INTERVAL_DS |
PLS_INTEGER |
190 |
TYPECODE_INTERVAL_YM |
PLS_INTEGER |
189 |
TYPECODE_MLSLABEL |
PLS_INTEGER |
105 |
TYPECODE_NAMEDCOLLECTION (varray/nested table) |
PLS_INTEGER |
122 |
TYPECODE_NCHAR |
PLS_INTEGER |
286 |
TYPECODE_NCLOB |
PLS_INTEGER |
288 |
TYPECODE_NUMBER |
PLS_INTEGER |
2 |
TYPECODE_NVARCHAR2 |
PLS_INTEGER |
287 |
TYPECODE_OBJECT |
PLS_INTEGER |
108 |
TYPECODE_OPAQUE |
PLS_INTEGER |
58 |
TYPECODE_RAW |
PLS_INTEGER |
95 |
TYPECODE_REF |
PLS_INTEGER |
110 |
TYPECODE_TABLE (nested
table collection) |
PLS_INTEGER |
248 |
TYPECODE_TIMESTAMP |
PLS_INTEGER |
187 |
TYPECODE_TIMESTAMP_LTZ |
PLS_INTEGER |
232 |
TYPECODE_TIMESTAMP_TZ |
PLS_INTEGER |
188 |
TYPECODE_UROWID |
PLS_INTEGER |
104 |
TYPECODE_VARCHAR2 |
PLS_INTEGER |
9 |
TYPECODE_VARCHAR |
PLS_INTEGER |
1 |
TYPECODE_VARRAY |
PLS_INTEGER |
247 |
|
|
(1) 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. |
|
Dependencies |
DBMS_ANYDATA_LIB |
DBMS_ANYTYPE_LIB |
DBMS_ANYDATASET_LIB |
MGMT_DELTA |
|
Exceptions |
|