*XML Being Stored In The Wrong Way (Doc ID 2893219.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

White space character is not preserved when inserting xml data into an XML column which is stored in a binary format.

Example:

create table test_xml (id number, b_xml xmltype, c_xml xmltype) XMLTYPE COLUMN "B_XML" STORE AS SECUREFILE BINARY XML XMLTYPE COLUMN "C_XML" STORE AS BASICFILE CLOB;

insert into test_xml (id,b_xml,c_xml) values (2, xmltype('<root> </root>'),xmltype('<root> </root>'));

select * from test_xml where id = 2;

<root/>
<root> </root>

Changes

Cause

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