| General |
|
Note: Contains specs. for packages and types used in DBMS extensibility infrastructure (Indexing, optimizer etc.).
|
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsindx.sql |
| Data Types |
CREATE OR REPLACE TYPE |
Constants |
|
Name |
Data Type |
Value |
| Data Types |
| TYPECODE_DATE |
BINARY_INTEGER |
12 |
| TYPECODE_NUMBER |
BINARY_INTEGER |
2 |
| TYPECODE_RAW |
BINARY_INTEGER |
95 |
| TYPECODE_CHAR |
BINARY_INTEGER |
96 |
| TYPECODE_VARCHAR2 |
BINARY_INTEGER |
9 |
| TYPECODE_VARCHAR |
BINARY_INTEGER |
1 |
| TYPECODE_MLSLABEL |
BINARY_INTEGER |
105 |
| TYPECODE_BLOB |
BINARY_INTEGER |
113 |
| TYPECODE_BFILE |
BINARY_INTEGER |
114 |
| TYPECODE_CLOB |
BINARY_INTEGER |
112 |
| TYPECODE_CFILE |
BINARY_INTEGER |
115 |
| RowType.RT_AddUserType()
Types |
| TYPECODE_REF |
BINARY_INTEGER |
110 |
| TYPECODE_OBJECT |
BINARY_INTEGER |
108 |
| TYPECODE_VARRAY |
BINARY_INTEGER |
247 |
| TYPECODE_TABLE |
BINARY_INTEGER |
248 |
|
| Exceptions |
| Exception |
Description |
|
-22369 |
invalid_parameters |
|
-22370 |
incorrect_usage |
|
| Security Model |
Execute is granted to PUBLIC |