XMLTABLE Function Does Not Return Values If Relative Path Is Used After Database Upgrade To 19c
(Doc ID 2731499.1)
Last updated on JULY 20, 2024
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 |