Some Characters in XML Comments Tag Get Replaced With a Hyphen or Replacement Character Upon Insertion Into Database
Last updated on MARCH 08, 2017
Applies to:JDBC - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 11.2 to 12.1]
Oracle XML Developers Kit - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Information in this document applies to any platform.
Oracle JDBC driver (either JDBC Thin or JDBC OCI)
Oracle XML Parser / RDBMS version 11.2
When uploading an XML file to an 11g database table containing an XMLTYPE datatype stored as SECUREFILE BINARY XML, then very rarely, one of the characters contained within a comments tag will be replaced with a replacement character, such as the hyphen character '-'.
This is seen when fetching that stored XML back out into an output file.
No error is returned; the problem consists of unexpected and unwanted character replacement in the uploaded data as stored in the database.
The problem reproduces with any 11g or 12c version of the JDBC driver; it happens while using either the JDBC Thin or the JDBC OCI driver.
The problem does not reproduce when connecting to a 12c database.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms