Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Andreas.

Asked: April 21, 2021 - 6:55 am UTC

Last updated: April 28, 2021 - 3:16 am UTC

Version: 20.2

Viewed 100+ times

You Asked

Hi, I've developed an application in APEX which provides a feature to maintain files stored in a CLOB (well, actually it's a BLOB but I know how to handle this). This works very well as long as the size of the content doesn't exceed the 32k limit. If a file is bigger than this limit an error 'ORA-06502: PL/SQL: numeric or value error' is raised.
Is there any solution which I can use to handle files with more then 32k chars in an apex app?

and we said...

I don't think you can do this natively. People have worked around it via plugins, either

open source

https://github.com/OraOpenSource/apex-plugin-clob-load

or commercial

http://dgielis.blogspot.com/2021/02/the-best-rich-text-html-editor-for.html

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.