XMLTABLE-expressions Do Not Work on 12.1.0.2 after upgrade from 11.2.0.4
(Doc ID 2278459.1)
Last updated on MARCH 24, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Before 12c, below query worked
SELECT nd.id_stage,
TrimContribution."Quarter",
TrimContribution."ContributionType"
FROM nd_vwr_formAIndependent nd,
XMLTABLE (
XMLNAMESPACES ('http://ws.nd.dgine.minsoc.fed.be' AS "x"),
'//x:TrimContribution'
PASSING nd.stateofneed
COLUMNS "Quarter" PATH '*:Quarter',
"ContributionType" PATH '*:ContributionType'
) AS TrimContribution
WHERE TrimContribution."Quarter" NOT IN ('11111');
Since 12c, the query returns no records.
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 |
Cause |
Solution |
References |