SQL & PL/SQL

Hi experts,

Am facing user function result value was too large issue while i extract and insert the XML in oracle table. I.e., It's working fine when the xml size less than 4000 character, but the issue will be raise when the xml size more than 4000 character.
I can't able to sort out the issue kindly help to get out from the issue.

This is my code:-

INSERT INTO ENDORSEMETN (Endorsement_name)
SELECT 
      EXTRACTVALUE (COLUMN_VALUE, '//Table1/Endorsement')
                 FROM TABLE (XMLSEQUENCE (EXTRACT (SYS.XMLTYPE (p_xmlDetails),'/NewDataSet/Table1')));

Thanks and regards
Arun