Oracle Solution for Error ora-30965

Solution for Oracle Error ORA-30965

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

What triggered the Error:

The fragment size exceeded the max size.

What should we do to fix it:

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