Oracle Error ORA-18150: SQL input value cannot be modified in updating expression

Oracle Error Message

ORA-18150: SQL input value cannot be modified in updating expression

Reason for the Error

Updating expression was specified as top-level XMLQuery expression.

Solution

Use XQuery TRANSFORM expression to copy input value and modify it.