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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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