| 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 |
| Error Code |
Reason |
| ORA-22369 |
Invalid parameters |
| ORA-22370 |
Incorrect usage |
| ORA-22626 |
Type mismatch |
|