Oracle Error ORA-19023: The first argument to UPDATEXML operator has to be an XMLTYPE

Oracle Error Message

ORA-19023: The first argument to UPDATEXML operator has to be an XMLTYPE

Reason for the Error

The first argument passed to the update value operator was not an XMLTYPE.

Solution

Rewrite the query so that the first argument to the UPDATEXML operator is XMLTYPE.