My Oracle Support Banner

XML data format changed after upgrade to 12c (Doc ID 2390885.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


There is a table with column of XMLTYPE:
recid VARCHAR2(255) not null,
xmlrecord SYS.XMLTYPE
The XMLTYPE data of the table  before reinsertion  is as follows :

<c9 m='2'></c9>;
After deleting the table data and reinserting  data ; the format of the same row is changed to:

<c9 m="2"/>




To view full details, 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 a vibrant support community of peers and Oracle experts.