ORA-64203:destination buffer too small to hold to hold clob data after character set conversation
Summary:
I was using below logic for getting job profile responsibilities and it was throwing the error "ora-64203:destination buffer too small to hold to hold clob data after character set conversation"
regexp_replace(replace(translate(substr(regexp_replace(regexp_replace(susbtr(responsibilities,1,4000),'<[^>]>'),' '),1,4000),CHR(10) || CHR(13) || CHR(9)
,' '),';'), '<[^>]')
Is there any way to resolve the issue.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0