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!

ORA 31001 XML parsing failed

user649990Nov 15 2016 — edited Nov 16 2016

select

XMLELEMENT("BUSINESENTITIES",

XMLAGG(

 XMLELEMENT("BUSINESSENTITY",

                 XMLELEMENT("ENTITYTYPE",ENTITY\_TYPE),

                 XMLELEMENT("ACCREDITATIONNUMBER",ACCREDITATIONNUMBER),

                 XMLELEMENT("SITENUMBER",SITENUMBER),

                 XMLELEMENT("DEPTNUMBER",DEPTNUMBER),

                 XMLELEMENT("NAME",NAME)

 ) ) )   result

from tmp

When I am trying to xmlagg it throwing this error.

Can someone help me in this. is there any other way of doing this

I check codepage. it this WE8MSWIN1252 ( SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET'

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2016

Added on Nov 15 2016

#xml

5 comments

1,002 views