This plug-in can load clob data to any DOM element or Item on the APEX page, including also the RichTextEditor (CKE). It's also possible to upload a CLOB value again to the database. This value is stored in APEX Collection or it's also possible that this plug-ins calls a PL/SQL API e.g. to write the CLOB into table after upload. You can set Affected Element this is the element where any Dynamic Action Event is fired on and where the loader icon is shown. When you want to get content of collection when submit page. Call the Upload with Dynamic Action "Before Page Submit". If "Before Page Submit" is not working the start upload e.g. by button click and as second action fire page submit. This plugin can also sanitize HTML content on render and upload.
For working Demo just click on:
https://apex.oracle.com/pls/apex/f?p=103428
If you like my stuff, donate me a coffee
Important clarification: My work in the development team of Oracle APEX is in no way related to my open source projects or the plug-ins on apex.world! All plug-ins are built in my spare time and are not supported by Oracle!