Hi everyone,

I am using Sybase DB ASE 15.0 version.
And I am trying to load XML to a table and hence found XMLTable() function.

But on running the query its giving the error.

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 at ( . I think I need some access to run the query for XML functions.

Any light........please@@@

Thanks in Advance,
Siddharth