[Bug] Formatting XMLElement

Łukasz

Member³
When I add .getBlobVal(nls_charset_id('AL32UTF8')) to this query beautifier format this query to one line

SQL:
select XMLElement("ns3:Tag1", xmlattributes('http://someexampledomain.pl/someLongName' as "xmlns", 'http://someexampledomain.pl/someLongName/someLongName2' as "xmlns:ns2", 'http://someexampledomain.pl/someLongName/someLongName/someLongName3' as "xmlns:ns3"), XMLElement("ns3:Tag2", XMLElement("Tag3", 'Tag3 value'), XMLElement("Tag4", XMLElement("ns2:Tag5", 'Tag5 Value')))).getBlobVal(nls_charset_id('AL32UTF8'))
  from dual

Without this section everything works fine:

SQL:
select XMLElement("ns3:Tag1",
                  xmlattributes('http://someexampledomain.pl/someLongName' as "xmlns",
                                'http://someexampledomain.pl/someLongName/someLongName2' as "xmlns:ns2",
                                'http://someexampledomain.pl/someLongName/someLongName/someLongName3' as "xmlns:ns3"),
                  XMLElement("ns3:Tag2", XMLElement("Tag3", 'Tag3 value'), XMLElement("Tag4", XMLElement("ns2:Tag5", 'Tag5 Value'))))
  from dual
 
Back
Top