Oracle DBMS_AW_XML
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 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;
SELECT dbms_aw_xml.execute('Test String');

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;
SELECT dbms_aw_xml.executeFile('XMLDIR', 'uwfile.xml');
*
ORA-22285: non-existent directory or file for FILEOPEN operation
 
READAWMETADATA
Undocumented dbms_aw_xml.readAWMetadata(
input  IN VARCHAR2,
input2 IN VARCHAR2)
RETURN sys.genWStringSequence;
TBD
 
READAWMETADATA1
Undocumented dbms_aw_xml.readAWMetadatga1(
byteparams IN sys.genRawSequence,
wstrparams IN sys.genWStringSequence);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_AW
DBMS_AW_EXP
DBMS_AW_INTERNAL
DBMS_AW_STATS
DBMS_CUBE
DBMS_CUBE_LOG
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved