AW: xQuery question

From: Willy Klotz <>
Date: Tue, 22 Dec 2020 07:51:31 +0100
Message-ID: <!&!>

Hi Stefan,  

i am not an xml-guy, however we had problems with xml after upgrading from 12.2 to 19.6. One of the fixes was patch 31895670. Maybe this is something which fits in your case.  



Von: [] Im Auftrag von Stefan Knecht Gesendet: Dienstag, 22. Dezember 2020 03:28 An: oracle-l-freelists <> Betreff: xQuery question  

Hi all  

Been wrapping my head around this for too long and need a fresh set of eyes :)  

Simple case:  

select xmlquery('xquery version "1.0"; copy $d := . modify insert nodes $parent/$child as last into $d/root return $d ' passing xmltype('<root></root>'), xmltype('<child>123</child>') as "child", xmltype('<parent>456</parent>') as "parent" returning content ) as x from dual;

What I'd expect:  



But it's ignoring the parent and giving me only:  



I can't see why, but I must be missing something obvious.  


Received on Tue Dec 22 2020 - 07:51:31 CET

Original text of this message