11g version does not recognise content of a database field of XMLTYPE as XML (for BI Publisher this
I’m having the following problem with the 11g version (in 10g this worked fine).
CASE:
- database table "test_hbu" with a field "factuur_xml" of XMLTYPE
- Data set query: SELECT t.xml_factuur.getclobval() factuur_xml FROM test_hbu t
PROBLEM: when i extract the XML data in BI Publisher, the XML content stored in the table test_hbu is not recognized as XML by BI Publisher, it is interpreted as a text string instead
EXAMPLE: table containing the value <test_hbu><a>a</a><b>b</b><c>c</c></test_hbu> in a XMLTYPE field
gives as result in BI Publisher: