XML data format changed after upgrade to 12c
(Doc ID 2390885.1)
Last updated on APRIL 12, 2022
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
There is a table with column of XMLTYPE:
create table XIBINTG_TEST.FLCN_CUSTOMER
(
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"/>
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |