Oracle | DBMS_AW

Oracle DBMS_AW_XML Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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