My Oracle Support Banner

XMLTABLE Function Does Not Return Values If Relative Path Is Used After Database Upgrade To 19c (Doc ID 2731499.1)

Last updated on DECEMBER 31, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.8.0.0.0 to 20.3.0.0.0 Preview [Release 19 to 20.0]
Information in this document applies to any platform.

Symptoms

On : 19.8.0.0.0 version, XML Database

ACTUAL BEHAVIOR
---------------
Wrong result using XMLTABLE after upgrade to 19.8 for the following query:

1 SELECT
2 fnma_ln_id AS fnma_ln,
3 serviceGroup.id,
4 serviceGroup.receiveDate,
5 serviceGroup.receiveTime,
6 serviceGroup.sendDate,
7 serviceGroup.sendTime
8 FROM USER1.TEST1 hist,
9 XMLTABLE('/DataPackage/ServiceResponse/ServiceGroup'
10 PASSING hist.response
11 COLUMNS

12 id VARCHAR2(51) PATH './../../@id',
13 receiveDate VARCHAR2(20) PATH './../../@receiveDate',
14 receiveTime VARCHAR2(20) PATH './../../@receiveTime',
15 sendDate VARCHAR2(20) PATH './../../@sendDate',
16 sendTime VARCHAR2(10) PATH './../../@sendTime',

17 serviceGroup_name VARCHAR2(100) PATH '@name',
18 serviceGroup_id VARCHAR2(20) PATH '@id',
19 serviceGroup_status VARCHAR2(10) PATH '@status',
20 serviceItems xmltype PATH './ServiceItem'
21 ) serviceGroup
22 WHERE response IS NOT null
23 AND SUBMITTED_DATE >= '01-JAN-2019'
24* AND TASK_ID >= 2000

12.1.0.2:
FNMA_LN ID RECEIVEDATE RECEIVETIME SENDDATE SENDTIME
---------- --------------------------------------------------- -------------------- -------------------- -------------------- ----------
4020501737 000902010540205017379374847520200827080824652 20200827 080824652 20200827 080747584

19.8.0.0:
FNMA_LN ID RECEIVEDATE RECEIVETIME SENDDATE SENDTIME
---------- --------------------------------------------------- -------------------- -------------------- -------------------- ----------
4015638230
4015638230

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
References


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