MSCEWI3010

XMLTABLE is not supported.

This EWI was removed and replaced by MSCEWI1084

Severity

High

Description

XMLTABLE function is not currently supported.

Example Code

Input Code:

SELECT x.*
FROM XmlTableTest t,
XMLTABLE ('/Employees/Employee'
PASSING t.xmldata
COLUMNS firstname VARCHAR2(30) PATH 'firstname',
lastname VARCHAR2(30) PATH 'lastname') x;

Output Code:

SELECT x.*
FROM MYDB.PUBLIC.XmlTableTest t, /*** MSC-ERROR - MSCEWI3010 - XMLTABLE IS NOT SUPPORTED ***/
XMLTABLE ('/Employees/Employee'
PASSING t.xmldata
COLUMNS firstname VARCHAR(30) PATH 'firstname',
lastname VARCHAR(30) PATH 'lastname') x;

Recommendations