Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Does Oracle XE 11.2 Support XMLTABLE / XQuery?

989611Feb 6 2013 — edited Feb 6 2013
All,

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 6 2013
Added on Feb 6 2013
5 comments
464 views