Query XMLTABLE Is Not Working On 11.2.0.4 (Doc ID 2016441.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

Xmlquery on 11.2.0.4 and on 11.2.0.3 it worked properly on both , but result
on 11.2.0.4 are different,

 on 11.2.0.3:
-----------------------------------
select why_not_null
  , val
  , node
 from xmltable('/root/tier1/*'
  passing
xmltype('v1t1a1
v2t2a2>v3t3a33>')
  columns why_not_null varchar2(10) path '/im_not_valid'
  , val varchar2(10) path '/value'
  , node xmltype path '.');




result on 11.2.0.4
-----------------------------------
WHY_NOT_NU VAL NODE
---------- ----------
------------------------------------------------------------
v1 v1 v1
t1a1 t1a1 t1a1
v2 v2 v2
t2a2 t2a2 t2a2
v3 v3 v3
t3a3 t3a3 t3a3
------------------------------------------------------------------------------
-----
result on 11.2.0.3
-----------------------------------

WHY_NOT_NU VAL NODE
---------- ----------
----------------------------------------------------------
  v1 v1
  t1a1
  v2 v2
  t2a2
  v3 v3
  t3a3

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