Need to fetch more than 4000 bytes of data from CLOB data type field

Summary: The column COMMENT_TEXT / COMMENTS from the table HRA_EVAL_RATINGS contains more than 4000 bytes of data for some of the cases and we want to find a way to fetch more than 4000 byte of data in our report. Currently, it is not extracting any data exceeding 4000 bytes.

Code Snippet (add any code snippets that support your topic, if applicable):

Query used-
select DBMS_LOB.SUBSTR(REGEXP_REPLACE(REGEXP_REPLACE(substr(ER.COMMENT_TEXT,1,4000),'<[^<>]*>',''), CHR(38)||'nbsp;', '')) AS COMMENTS
from
HRA_EVAL_RATINGS ER
where 1=1
AND ER.ROLE_TYPE_CODE IN ('WORKER')
AND ER.REFERENCE_TYPE = 'SECTION'