Oracle | DBMS_AW

Oracle DBMS_AW_XML Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented OLAP utilities

AUTHID CURRENT_USER

Data Types sys.genRawSequence VARRAY(32767) OF RAW(32767) sys.genWStringSequence VARRAY(32767) OF NVARCHAR2(10922)

Dependencies

DBMS_LOB	GENRAWSEQUENCE	INTERACTIONEXECUTE
DBMS_STANDARD	GENWSTRINGSEQUENCE	PLITBLM

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/olap/admin/dbmsawx.sql

Subprograms

EXECUTE	READAWMETADATA	READAWMETADATA1
EXECUTEFILE

EXECUTE

Undocumented dbms_aw_xml.execute(input IN CLOB) RETURN VARCHAR2; PRAGMA SUPPLEMENTAL_LOG_DATA(execute, UNSUPPORTED);

SELECT dbms_aw_xml.execute('Test String')

      FROM dual;

      

      DBMS_AW_XML.EXECUTE('TESTSTRING')

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

      Success <Line 1, Column 1>: XML-20108: (Fatal Error) Start of root element 
      expected.

EXECUTEFILE

Executes the named file at the location specified by a Directory object dbms_aw_xml.executeFile( dirname IN VARCHAR2, fname IN VARCHAR2) RETURN VARCHAR2; PRAGMA SUPPLEMENTAL_LOG_DATA(executefile, UNSUPPORTED);

SELECT dbms_aw_xml.executeFile('XMLDIR', 'uwfile.xml')

      FROM dual;

      SELECT dbms_aw_xml.executeFile('XMLDIR', 'uwfile.xml')

      *

      ERROR at line 1:

      ORA-22285: non-existent directory or file for FILEOPEN operation

      ORA-06512: at "SYS.DBMS_LOB", line 822

      ORA-06512: at "SYS.DBMS_AW_XML", line 37

READAWMETADATA

Undocumented dbms_aw_xml.readAWMetadata( input IN VARCHAR2, input2 IN VARCHAR2) RETURN sys.genWStringSequence; pragma supplemental_log_data(readAWMetadata, READ_ONLY);

TBD

READAWMETADATA1

Undocumented dbms_aw_xml.readAWMetadatga1( byteparams IN sys.genRawSequence, wstrparams IN sys.genWStringSequence); pragma supplemental_log_data(readAWMetadata1, READ_ONLY);

TBD