Oracle DBMS_METADATA_BUILD
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Implements lower-level functions for defining heterogeneous object types
AUTHID CURRENT_USER
Constants
Name Data Type Value
TOP_LEVEL_TYPE NUMBER 0
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
Dependencies
DBMS_METADATA DBMS_OUTPUT DBMS_UTILITY
DBMS_METADATA_DPBUILD DBMS_SYS_ERROR PLITBLM
DBMS_METADATA_UTIL    
Documented No
Exceptions
Error Code Reason
31600 invalid_argval: Invalid argument
31601 invalid_operation: Invalid operation
First Available 9.0.1
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmsmetb.sql
Subprograms
 
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

Related Topics
DBMS_METADATA
DBMS_METADATA_DIFF
DBMS_METADATA_DPBUILD
DBMS_METADATA_HACK
DBMS_METADATA_INT
DBMS_METADATA_UTIL
Packages