Some Characters in XML Comments Tag Get Replaced With a Hyphen or Replacement Character Upon Insertion Into Database (Doc ID 2014569.1)

Last updated on MARCH 08, 2017

Applies to:

JDBC - Version 11.2.0.1.0 to 12.1.0.2.0 [Release 11.2 to 12.1]
Oracle XML Developers Kit - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

ENVIRONMENT
-----------------
Oracle JDBC driver (either JDBC Thin or JDBC OCI)
Oracle XML Parser / RDBMS version 11.2

 

PROBLEM DESCRIPTION
-----------------------------
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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms