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

Helios-GunesEROL

Hi;

Please see below link:
http://ksadba.wordpress.com/2008/06/10/how-to-show-arabic-characters-in-your-client-app/

If its not help than For your issue its better to ask this question at toad forum site

Regard
Helios

1 person found this helpful

706103

Thanks Helios.
Checked those things in the link,but cudnt solve it.

706103

Ya got it.
Just changed the 'Current format' to Arabic(Saudi Arabia) in 'Regional and Language Options' in "Control Panel" .
Now everything works good.

1 - 3

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2013

Added on Feb 6 2013

#for, #oracle, #support, #xe

5 comments

439 views

SQL & PL/SQL

Does Oracle XE 11.2 Support XMLTABLE / XQuery?

Comments

Post Details