we try to publish xml document but special characters are not correctly transformed by the stored procedure publish_lob_ref.
The query string gets column like comments which contain some special character like < > ' " & . When we use the publish_lob_ref procedure with the query, the result of the xml document doesn't transform the special character and so the xml document is not valid.
Special character should become like that :
< should be transformed in < > should be transformed in > ...
does anyone know the solution to correctly transform those characters ? is there a special configuration to use publish_lob_ref to get a valid xml document ?