CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_METADATA_BUILD
Version 11.1
 
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

x

Exception Name Error Code Reason
invalid_argval 31600 Invalid argument
invalid_operation 31601 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
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
 
Related Topics
DBMS_METADATA_DIFF
DBMS_METADATA
DBMS_METADATA_UTIL
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [105 users online]    © 2010 psoug.org