Adding multiple nodes with appendChildXML or insertChildXML gives LPX-00245
696575Apr 16 2009 — edited Apr 20 2009Hi,
the 10gR2 documentation says, e.g. for appendChildXML:
"child-data (XMLType) – Child data to be inserted: one or more nodes of any kind. The order of the nodes is preserved after the insertion."
In my understanding, this means that in an existing document with nodes
<toplevel>
<elem>a</elem>
<elem>b</elem>
</toplevel>
it is not only possiby to add one elem node, but also two or more.
However, how do you get to an XMLType data type with two nodes lacking a hierarchy?
Constructing an XMLType with this
<elem>c</elem>
<elem>d</elem>
always returns LPX-00245: extra data after end of document
I need to pass the XML data to XMLType as a CLOB (which I fetch with a subselect). but I guess this is not relevant.
Thanks and best regards,
Carsten