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
Contains specifications for packages and types used in DBMS extensibility infrastructure (Indexing, optimizer etc.). Not built by the default installation.
AUTHID
DEFINER
Constants
Name
Data Type
Value
Data Types
TYPECODE_VARCHAR
BINARY_INTEGER
1
TYPECODE_NUMBER
BINARY_INTEGER
2
TYPECODE_VARCHAR2
BINARY_INTEGER
9
TYPECODE_DATE
BINARY_INTEGER
12
TYPECODE_RAW
BINARY_INTEGER
95
TYPECODE_CHAR
BINARY_INTEGER
96
TYPECODE_MLSLABEL
BINARY_INTEGER
105
TYPECODE_CLOB
BINARY_INTEGER
112
TYPECODE_BLOB
BINARY_INTEGER
113
TYPECODE_BFILE
BINARY_INTEGER
114
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
Dependencies
STANDARD (only)
Documented
No
Exceptions
Error Code
Reason
ORA-22369
invalid_parameters
ORA-22370
incorrect_usage
First Available
Not known
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Source
{ORACLE_HOME}/rdbms/admin/dbmsindx.sql
SQL> @?/rdbms/admin/dbmsindx.sql
Library created.
SP2-0808: Package created with compilation warnings
Synonym created.
Grant succeeded.
SP2-0816: Type created with compilation warnings
Synonym created.
Grant succeeded.
SQL> sho err
Errors for TYPE ROWTYPE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/1 PLW-05018: unit ROWTYPE omitted optional AUTHID clause; default
value DEFINER used
139/13 PLW-07203: parameter 'SCHEMA_NAME' may benefit from use of the NOCOPY compiler hint
139/39 PLW-07203: parameter 'TYPE_NAME' may benefit from use of the NOCOPY compiler hint
140/13 PLW-07203: parameter 'VERSION' may benefit from use of the NOCOPY compiler hint
