Oracle Error ORA-19045: character set id specified for XMLSerialize not valid

Oracle Error Message

ORA-19045: character set id specified for XMLSerialize not valid

Reason for the Error

An XMLSerialize function was called with an invalid value for the caracter set id.

Solution

Modify the query so that the character set id is valid.