Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to download clob data into csv file in oracle apex

Ashrao-OracleAug 1 2018 — edited Aug 24 2018

Hi All,

I have a requirement where I need to download the table with 100+ clob columns into CSV file based on user selected records.

The clob column contains data more than 4k characters.

i tried the approach mentioned in the below link but ran into "ORA-22835 - Buffer too small for CLOB to CHAR or BLOB to RAW conversion " error.

https://www.apex-at-work.com/2015/02/custom-csv-export-in-apex.html

Is there any other way to achieve this?

Please guide.

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2018
Added on Aug 1 2018
2 comments
464 views