MySQL Forums
Forum List  »  Sybase

Error in Using XMLTable function
Posted by: Siddharth Singh
Date: July 14, 2011 08:22AM

Hi Everyone,

I am using ASE 15.0 and connected to Sybase DB.

I want to use XMLTable() to load an XML file to a table.
Since I am using below query for testing it's not working:

select * from xmltable('/doc/item'
passing '<doc><item><id>1</id><name>Box</name></item>'
+'<item><id>2</id><name>Jar</name></item></doc>'
columns id int path 'id',name varchar(20) path 'name') as items_table

Error: 11:52:07 [SELECT - 0 row(s), 0.000 secs] [Error Code: 102, SQL State: 37000] Incorrect syntax near '('.
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]

Any help regarding this issue its killing me.
I have enable the xml using sp_configure to "1";

Thanks in Advance,
Siddharth

Options: ReplyQuote


Subject
Views
Written By
Posted
Error in Using XMLTable function
5919
July 14, 2011 08:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.