Oracle | DBMS_METADATA

Oracle DBMS_METADATA_HACK Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose The following comment is in the creation file script:
Register XML schemas for SXML docs. When XDK is created by catproc.sql, this code can go into dbms_metadata_util. For now we keep it here.

AUTHID DEFINER

Dependencies

DBMS_ASSERT	DBMS_XMLSCHEMA	V$DATABASE
DBMS_SYSTEM	DIRNAMESMH

Documented No

First Available 10.2

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/catxdbh.sql

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

      

      Session altered.

      

      Session altered.

      

      SP2-0808: Package created with compilation warnings

      

      Errors for PACKAGE DBMS_METADATA_HACK:

      

      LINE/COL ERROR

      -------- -----------------------------------------------------------------

      8/26 PLW-06010: keyword "NAME" used as a defined name

      

      Type created.

      

      SP2-0810: Package Body created with compilation warnings

      

      Errors for PACKAGE BODY DBMS_METADATA_HACK:

      

      LINE/COL ERROR

      -------- -----------------------------------------------------------------

      66/3 PLW-06006: uncalled procedure "GET_SCHEMA_DIR" is removed.

      153/26 PLW-06010: keyword "NAME" used as a defined name

      157/18 PLW-06009: procedure "DELETESCHEMA" OTHERS handler does not end in RAISE

      175/3 PLW-06006: uncalled procedure "GET_XML_DIR" is removed.

      

      Session altered.

      

      Session altered.

      

      SQL> sho err

      Errors for PACKAGE BODY DBMS_METADATA_HACK:

      

      LINE/COL ERROR

      -------- -----------------------------------------------------------------

      66/3 PLW-06006: uncalled procedure "GET_SCHEMA_DIR" is removed.

      153/26 PLW-06010: keyword "NAME" used as a defined name

      157/18 PLW-06009: procedure "DELETESCHEMA" OTHERS handler does not end in RAISE

      

      175/3 PLW-06006: uncalled procedure "GET_XML_DIR" is removed.

Subprograms

CRE_DIR	DROP_DIR	GET_XML_BFILE
CRE_XML_DIR	DROP_XML_DIR	GET_XML_DIRNAME
DELETESCHEMA	GET_BFILE	LOAD_XSD

CRE_DIR

Undocumented
Assumes directory is rdbms/xml/schema dbms_metadata_hack.cre_dir;

exec dbms_metadata_hack.cre_dir;

      

      PL/SQL procedure successfully completed.

CRE_XML_DIR

Undocumented
needed for rdbms/xml access dbms_metadata_hack.procedure cre_xml_dir;

exec dbms_metadata_hack.procedure cre_xml_dir;

      

      PL/SQL procedure successfully completed.

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;

      

      PL/SQL procedure successfully completed.

DROP_XML_DIR

Undocumented
Needed for rdbms/xml access dbms_metadata_hack.drop_dir;

exec dbms_metadata_hack.drop_xml_dir;

      

      PL/SQL procedure successfully completed.

GET_BFILE

Undocumented
Assumes directory is rdbms/xml/schema dbms_metadata_hack.get_bfile(filename IN VARCHAR2) RETURN BFILE;

TBD

GET_XML_BFILE

Returns the full BFILE based on its target file name dbms_metadata_hack.get_xml_bfile(filename IN VARCHAR2) RETURN BFILE;

conn sys@pdbdev as sysdba

      

      GRANT read, write ON DIRECTORY ctemp TO uwclass;

      

      Grant succeeded.

      

      conn uwclass/uwclass@pdbdev

      

      CREATE TABLE uw_files (

      file_id   NUMBER,

      file_name BFILE);

      

      Table created.

      

      INSERT INTO uw_files

      (file_id, file_name)

      VALUES

      (1, BFILENAME('CTEMP', 'testfile.xml'));

      

      1 row created.

      

      COMMIT;

      

      Commit complete.

      

      conn sys@pdbdev as sysdba

      

      SELECT dbms_metadata_hack.get_xml_bfile('testfile.xml');

      

      DBMS_METADATA_HACK.GET_XML_BFILE('TESTFILE.XML')

      -------------------------------------------------

      bfilename('XMLDIR', 'testfile.xml')

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;

      

      GET_XML_DIRNAME

      ----------------

      XMLDIR

LOAD_XSD

Undocumented
Assumes directory is rdbms/xml/schema dbms_metadata_hack.load_xsd( filename IN VARCHAR2, gentypes1 IN BOOLEAN := FALSE);

TBD