How to fix the Oracle error ORA-31059: Cannot insert root XML document node if it already exists?

In this post, you’ll learn more about the Oracle ErrorORA-31059: Cannot insert root XML document node if it already exists with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-31059: Cannot insert root XML document node if it already exists

Reason for the Error ORA-31059: Cannot insert root XML document node if it already exists

An attempt was made to insert a root node into an XML document that already had a root node.

How to fix the Error ORA-31059: Cannot insert root XML document node if it already exists ?

You can fix this error in Oracle by following the below steps

Call the appropriate replace function to replace the node instead of inserting it anew.