Skip to Main Content
  • Questions
  • Loading CLOB data (more than 32k char) into Oracle DB through Apex

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Murugananth.

Asked: August 05, 2020 - 3:57 am UTC

Last updated: August 11, 2020 - 9:25 am UTC

Version: 20.1

Viewed 1000+ times

You Asked

Hi,
I am currently working on developing apex web application which requires to capture CLOB data and save it to DB.
I am using Rich text editor to capture the content and noticed that only max of 32k characters can be loaded through the page item.
when I try to push data more than 32k char, no data is being sent to the DB.
Please suggest me a way to capture data more than 32k through apex page item.
Oracle DB Version: 12c
Apex version:20.1
Kindly let me know if I am missing any details

Thanks,
Murugananth

and Connor said...

APEX natively can't handle more than 32k in a page item.

However, you might want to take a look at this plugin

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

which is designed to overcome the limitation

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

This works

Murugananth, August 11, 2020 - 6:58 am UTC

Thanks for helping on this :) This works
Connor McDonald
August 11, 2020 - 9:25 am UTC

glad we could help

More to Explore

APEX

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