Oracle DBMS_METADATA_HACK
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. 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.
Note This package, built with unwrapped source code is undocumented and is not built during the default installation. Here's what it looks like when it is built.

SQL> @?/rdbms/admin/catxdbh.sql

SP2-0808: Package created with compilation warnings

Errors for PACKAGE DBMS_METADATA_HACK:

LINE/COL ERROR
-------- ------------------------------------------------------------------------------
    7/26 PLW-06010: keyword "NAME" used as a defined name
Type created.
SP2-0810: Package Body created with compilation warnings
    66/3 PLW-06006: uncalled procedure "GET_SCHEMA_DIR" is removed.
  152/26 PLW-06010: keyword "NAME" used as a defined name
  156/18 PLW-06009: procedure "DELETESCHEMA" OTHERS handler does not end in RAISE or RAISE_APPLICATION_ERROR
   174/3 PLW-06006: uncalled procedure "GET_XML_DIR" is removed.
AUTHID DEFINER
Constants
Name Data Type Value
kolfuseslf VARCHAR2(4000) 'FALSE'
XML_DIR BINARY_INTEGER 1
SCHEMA_DIR BINARY_INTEGER 2
RDBMS_DIR DIRNAMESMH DIRNAMESMH(NULL, 'schema')
LOGIC_DIR DIRNAMESMH DIRNAMESMH('XMLDIR', 'XSDDIR')
PLATFORM_WINDOWS32 BINARY_INTEGER 7
PLATFORM_WINDOWS64 BINARY_INTEGER 8
PLATFORM_OPENVMS BINARY_INTEGER 15
Dependencies
DBMS_ASSERT DBMS_XMLSCHEMA V$DATABASE
DBMS_SYSTEM DIRNAMESMH  
Documented No
First Available 10.2.0.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/catxdbh.sql
Subprograms
 
CRE_DIR
Undocumented
Assumes directory is rdbms/xml/schema
dbms_metadata_hack.cre_dir;
exec dbms_metadata_hack.cre_dir;
 
CRE_XML_DIR
Undocumented
needed for rdbms/xml access
dbms_metadata_hack.procedure cre_xml_dir;
exec dbms_metadata_hack.procedure cre_xml_dir;
 
DELETESCHEMA
Undocumented
Assumes directory is rdbms/xml/schema
dbms_metadata_hack.deleteSchema(name IN VARCHAR2);
TBD
 
DROP_DIR
Undocumented
Assumes directory is rdbms/xml/schema
dbms_metadata_hack.drop_dir;
exec dbms_metadata_hack.drop_dir;
 
DROP_XML_DIR
Undocumented
needed for rdbms/xml access
dbms_metadata_hack.drop_dir;
exec dbms_metadata_hack.drop_xml_dir;
 
GET_BFILE
Undocumented
Assumes directory is rdbms/xml/schema
dbms_metadata_hack.get_bfile(filename IN VARCHAR2) RETURN BFILE;
TBD
 
GET_XML_BFILE
Undocumented
Assumes directory is rdbms/xml/schema
dbms_metadata_hack.get_xml_bfile(filename IN VARCHAR2) RETURN BFILE;
TBD
 
GET_XML_DIRNAME
Undocumented
Assumes directory is rdbms/xml/schema
dbms_metadata_hack.get_xml_dirname RETURN VARCHAR2;
SELECT dbms_metadata_hack.get_xml_dirname
FROM dual;
 
LOAD_XSD
Undocumented
Assumes directory is rdbms/xml/schema
dbms_metadata_hack.load_xsd(filename IN VARCHAR2, gentypes1 IN BOOLEAN := FALSE);
TBD

Related Topics
DBMS_METADATA
DBMS_METADATA_BUILD
DBMS_METADATA_DIFF
DBMS_METADATA_DPBUILD
DBMS_METADATA_INT
DBMS_METADATA_UTIL
Packages

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved