Unanswered: Problems with invalid character in dbms_xmlsave and XMLType
Please, help me to find a solution.
Here is the short description:
I pull out record using dbms_xmlquery.getxml(). The string field of table contains the following characters: chr(24), chr(0), chr(1), chr(11), chr(8).
"Pulls out" works well!
The I try to load pulled XML text with such characters in XMLType - I get the error,for example, LPX-00216: invalid character 8 (0x8).
When I try to perform dbms_xmlsave.UPDATEXML for this XML text I get the same error XML-20221: (Fatal Error) Invalid char in text.
All works well when this characters is absent in text.