Oracle Error ORA-31072: Too many child nodes in XMLType fragment for updateXML

Oracle Error Message

ORA-31072: Too many child nodes in XMLType fragment for updateXML

Reason for the Error

An attempt was made to pass an XMLType fragment with multiple children as new data for the updateXML operator.

Solution

Extract the desired child from the XMLType before passing it to updateXML as the desired new XML node.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...