Does Oracle XE 11.2 Support XMLTABLE / XQuery?
989611Feb 6 2013 — edited Feb 6 2013All,
I have a column which is of data type CLOB.
the data is in XML format and i am attempting to convert them into relational-data (creating a view from the CLOB data)
I am trying to use XMLTABLE as mentioned in
http://docs.oracle.com/cd/E11882_01/appdev.112/e23094/xdb_xquery.htm#BABJCHCC
But I get a 00932 exception
ORA-00932: inconsistent datatypes: expected - got CLOB
00932. 00000 - "inconsistent datatypes: expected %s got %s"
Sample Query
SELECT
x."WarehouseId", x."WarehouseName"
FROM ENGINE_ENTITIES,
XMLTABLE('/Warehouse'
PASSING engine_entities.xml_data
COLUMNS
"LEI" varchar2(20) PATH '/WarehouseId',
"HIERARCHY" varchar2(20) PATH '/WarehouseName')
x;
Can some one confirm to me if Oracle XE 11.2 Support XMLTABLE / XQuery