I'm having an issue with hex values being stored in an oracle database. The fields containing the hex values appear to be null whenever I search for null values in the database. The oracle data is being written to an XML file. However, when I try to validate the XML, I receive the following error:
', hexadecimal value 0x0C, is an invalid character
Is there anyway to identify and replace hex characters in oracle? I would like to fix this in my stored procedure before the data is accessed by the .net application.
Thanks
http://en.wikipedia.org/wiki/ASCII#ASCII_control_characters
As slightwv says, "space" includes a form feed character
http://psoug.org/reference/regexp.html