Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Not able to print all clob data from BIP report
Summary:
I'm creating one report for requisition and in that im fetching clob attributes and using group by function below trying to use To_char(irtl.EXTERNAL_DESC_HTML)
,TO_CHAR(irtl.EXTERNAL_RESP_HTML)
,TO_CHAR(irtl.EXTERNAL_QUAL_HTML) this attributes but getting error like
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4726, maximum: 4000)
can anyone provide solution i want to print that data, at least till 4k is fine
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):
0