SQL Function to allow more than 4000 characters

Summary

Need SQL Function to allow more than 4000 characters

Content

Hi,

I have built sql custom report and my requirement is to bring employee overall comments using BI Report. i have used DBMS_LOB.SUBSTR Function but i am getting buffer size error. For example one employee is having more than 4000 characters, if i ran this report system is not allowing more than 4000 character.

 

(SELECT  dbms_lob.substr(REGEXP_REPLACE(REGEXP_REPLACE(EvalRatingEO.COMMENT_TEXT,'<[^<>]*>',''), CHR(38)||'nbsp;', ''))      
                                FROM     HRA_EVALUATIONS EvaluationEO,
                                    HRA_EVAL_SECTIONS EvalSectionEO,
                                    HRA_EVAL_RATINGS  EvalRatingEO,
                                    HRA_EVAL_PARTICIPANTS  EvalParticipantEO,
                                    HRA_TMPL_PERIODS_VL PERIOD