Forum Discussion

LP280388's avatar
LP280388
Icon for Resolver II rankResolver II
3 years ago

ORA-22835 Error

Hi Team,   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 ?  
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi LP280388 ,

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)

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.