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 will be available on generic Linux platforms in January and soon on AIX and Windows

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