All Forums Database
kathir_chaser 9 posts Joined 10/11
18 Jul 2016
Convert the data in the Table into XML format

HI All,
I'm trying to convert the data in a table to XML format for an application. And the output I get is <Error>.
Also , when i try to run the below statement i am gettting the same:
SELECT XMLELEMENT(NAME "Item", XMLATTRIBUTES('001' AS ID));.
Looks like I am missing something. Can someone helpme out in resolving the same. 

Fred 1096 posts Joined 08/04
18 Jul 2016

Don't use a quoted identifier for the XML Element Name.

kathir_chaser 9 posts Joined 10/11
19 Jul 2016

Tried that as well. But doesn't help...

You must sign in to leave a comment.