| 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 |
METAFILTER$ |
| DBMS_METADATA_DPBUILD |
DBMS_SYS_ERROR |
PLITBLM |
|
| Exceptions |
| Error Code |
Exception Name |
Reason |
| 31600 |
invalid_argval
|
Invalid argument |
| 31601 |
invalid_operation |
invalid operation |
|
| 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 |
| Set debugging
parameters |
dbms_metadata_build.set_debug_param(
name IN VARCHAR2, -- defaults to DATA_PUMP_DIR/debug.trc
value IN VARCHAR2); |
| TBD |
| |
| SET_FILTER_PARAM |
Set filter attribute parameters
Overload 1 |
dbms_metadata_build.set_filter_param(
handle IN NUMBER, -- handle returned by CREATE_FILTER
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 |
