Oracle Error ORA-30965: fragment does not fit into the VARCHAR2 VALUE column

Oracle Error Message

ORA-30965: fragment does not fit into the VARCHAR2 VALUE column

Reason for the Error

The fragment size exceeded the max size.

Solution

Re-create the XML Index with values stored in CLOB.