BI Publisher (MOSC)

MOSC Banner

11g version does not recognise content of a database field of XMLTYPE as XML (for BI Publisher this

edited Mar 3, 2011 11:50PM in BI Publisher (MOSC) 1 commentAnswered
Hello,

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center