SQL Function to allow more than 4000 characters
Summary
Need SQL Function to allow more than 4000 charactersContent
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