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

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Murugananth.

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

Answered by: Connor McDonald - Last updated: August 11, 2020 - 9:25 am UTC

Category: Application Express - Version: 20.1

Viewed 100+ 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 we 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

and you rated our response

  (1 rating)

Reviews

This works

August 11, 2020 - 6:58 am UTC

Reviewer: Murugananth from India

Thanks for helping on this :) This works
Connor McDonald

Followup  

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.