ORA-22835 Error

Question

Hi Team,&nbsp;I have the below error while trying to get data from an oracle sql query. I know it says maximum limit is 4000. is there a way to increase this limit ?&nbsp;

v-yanjiang-msft · Answer

Hi&nbsp;LP280388&nbsp;,
By my lots of research, I'm afraid you can't increase the limit, but here're similar threads, you can refer to the solution.
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 764123, maximum: 400 — oracle-tech
Oracle 12cR1 ORA-22835 Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: string, maximum: string) (oraexcel.com)
&nbsp;
Best Regards,Community Support Team _ kalyj
If this post&nbsp;helps,&nbsp;then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

ORA-22835 Error

1 Reply

Related content

error message

network error

RDL Error

Underlying Error: OnPremiseServiceException

ORA-22835 Error