| General Information |
| Purpose |
Implements lower-level functions for defining heterogeneous object types |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsmetb.sql |
| First Available |
9.0.1 |
|
Constants
|
| Name |
Data Type |
Value |
| DATATYPE_MIN |
NUMBER |
1 |
| DATATYPE_BOOLEAN |
NUMBER |
1 |
| DATATYPE_NUMERIC |
NUMBER |
2 |
| DATATYPE_TEXT |
NUMBER |
3 |
| DATATYPE_CUSTOM_FILTER |
NUMBER |
3 |
| DATATYPE_TEXT_EXPR |
NUMBER |
4 |
| DATATYPE_OBJNUM |
NUMBER |
5 |
| DATATYPE_MAX |
NUMBER |
5 |
| TYPE_HETEROGENEOUS |
BOOLEAN |
TRUE |
| TYPE_HOMOGENEOUS |
BOOLEAN |
FALSE |
| TOP_LEVEL_TYPE |
NUMBER |
0 |
|
|
Dependencies
|
| DBMS_METADATA |
DBMS_METADATA_UTIL |
PLITBLM |
| DBMS_METADATA_DPBUILD |
DBMS_SYS_ERROR |
|
|
Exceptions |
| Exception Name |
Error Code |
Reason |
| invalid_argval
|
31600 |
Invalid argument |
| invalid_operation |
31601 |
invalid operation |
x
|
| Security Model |
Execute is granted to the EXECUTE_CATALOG_ROLE
role |
| |
| CLOSE |
| Updates the data dictionary with the changes. |
dbms_metadata_build.close(handle IN NUMBER); |
| TBD |
| |
| CREATE_FILTER |
Begins creation of a filter for a type.
The filter will not be inserted into the dictionary until CLOSE is called. If the owning type (designated by
'handle') is not heterogeneous, then the filter must already be defined in sys.metafilter$. |
dbms_metadata_build.create_filter(
handle IN NUMBER,
name IN VARCHAR2,
datatype IN NUMBER)
RETURN NUMBER; |
| TBD |
| |
| CREATE_TYPE |
Begins creation of a type. The type will not be inserted into the dictionary until CLOSE is called. |
dbms_metadata_build.create_type(
parent_handle IN NUMBER,
name IN VARCHAR2,
type IN BOOLEAN DEFAULT TYPE_HETEROGENEOUS)
RETURN NUMBER; |
|
TBD |
| |
| DROP_TYPE |
| Drops a heterogeneous type. This deletes the type definition
and all dependent types, filters, etc. |
dbms_metadata_build.drop_type(name IN VARCHAR2); |
| TBD |
| |
| SET_DEBUG |
| Sets the internal debug switch |
dbms_metadata_build.set_debug(on_off IN BOOLEAN); |
| exec dbms_metadata_build.set_debug(TRUE); |
| |
| SET_DEBUG_PARAM |
| R |
dbms_metadata_build.set_debug_param(
name IN VARCHAR2,
value IN VARCHAR2); |
| TBD |
| |
| SET_FILTER_PARAM |
R
Overload 1 |
dbms_metadata_build.set_filter_param(
handle IN NUMBER,
name IN VARCHAR2,
value IN VARCHAR2); |
| TBD |
| Overload 2 |
dbms_metadata_build.set_filter_param(
handle IN NUMBER,
name IN VARCHAR2,
value IN BOOLEAN); |
| TBD |
| Overload 3 |
dbms_metadata_build.set_filter_param(
handle IN NUMBER,
name IN VARCHAR2,
value IN NUMBER); |
| TBD |
| |
| SET_TYPE_PARAM |
Uses CONSTANTS, above, to set the data type
Overload 1 |
dbms_metadata_build.set_type_param(handle IN NUMBER,
name IN VARCHAR2,
value IN VARCHAR2 ); |
| TBD |
| Overload 2 |
dbms_metadata_build.set_type_param(
handle IN NUMBER,
name IN VARCHAR2,
value IN BOOLEAN); |
| TBD |
| Overload 3 |
dbms_metadata_build.set_type_param(
handle IN NUMBER,
name IN VARCHAR2,
value IN NUMBER); |
| TBD |
