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
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_AW
DBMS_AW_STATS
DBMS_CUBE
DBMS_CUBE_LOG
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx