“Additional Spaces and Line Feed Added When Extracting Element With ExtractValue() [ID 369934.1] ”
The XML function ExtractValue in 10g Oracle strips spaces and line feeds but in Oracle 11g preserves. Oracle 11g behavior is according to the standard. Oracle 10g is wrong. However the pl/sql code written for 10g fails on 11g.
One of possible workarrounds is to modify the source code to trim spaces and line feeds:
RTRIM(TRIM(RTRIM(TRIM(extractValue(c, xpath, namespace)),chr(10))),chr(10))
Another possible solution would be to overload extractValue. However extractValue seems to be inbuilt SQL function meaning overloading failed (for me.)