My Oracle Support Banner

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 OCTOBER 17, 2022

Applies to:

JDBC - Version to [Release 11.2 to 12.1]
Oracle XML Developers Kit - Version to [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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.