XML Parsing Difference for NULL Elements In 11.2.0.2 and 11.2.0.3 (Doc ID 1511341.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Standard Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

 In 11.2.0.2 and before, null values would not generate an XML element. Sub-queries that did not return any rows would not generate a parent element. In 11.2.0.3, both of those cases now generate an empty element (see example below) -


11.2.0.2
<PARENT>
 <ID>1</ID>
 <FK_R_ID>1</FK_R_ID>
 <SOME_NON_NULL_VALUE>1</SOME_NON_NULL_VALUE>
 <FK>
   <ID>1</ID>
   <VAL>1</VAL>
</FK>
 <CHILD>
   <ID>1</ID>
   <PAR_ID>1</PAR_ID>
   <CHILD_TYPE>R</CHILD_TYPE>
   <VAL>1</VAL>
 </CHILD>
</PARENT>


11.2.0.3
<PARENT>
 <ID>1</ID>
 <FK_O_ID/>
 <FK_R_ID>1</FK_R_ID>
 <SOME_NULL_VALUE/>
 <SOME_NON_NULL_VALUE>1</SOME_NON_NULL_VALUE>
 <OPTIONAL_FK/>
 <FK>
   <ID>1</ID>
   <VAL>1</VAL>
 </FK>
 <CHILD>
   <ID>1</ID>
   <PAR_ID>1</PAR_ID>
   <CHILD_TYPE>R</CHILD_TYPE>
   <VAL>1</VAL>
 </CHILD>
</PARENT>

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