Skip to Main Content
Feature Request FR-2122
Product Area Page Components
Status DELIVERED

65 Voters

Support for CLOB in Text Area

abraham.olsen Public · Oct 27 2021

Idea Summary
A Text Area seems to be limited to the length of varchar2, which is 32767.

Try to make a function with: 

  • return dbms_lob.substr(cc, 32767, 1); -- results are shown in Text Area
  • return dbms_lob.substr(cc, 32768, 1); --Text Area remains empty
  • return cc; -- ora_sqlerrm: ORA-06502: PL/SQL: numeric or value; the page does not render at all.

Use Case
Useful whenever the contents to be displayed are longer than 32767, such as a JSON or XML returned from a http call, a file that has been uploaded. I have applications that display such data, or uses it to process in javascript.

We all build workaround solutions for it, but wouldn't it be cool, if a standard Text Area wouldn't suffer from the above mentioned.

Preferred Solution (Optional)
I can think of a few:

  • Simply, allow for unlimited or a very large amount of bytes.
  • Similar to “Display Image”, which demands a BLOB, add a new type that can use CLOB, prefferably one that can be edited.

Or/and, please, document size limits in “Help”. I might be the single one developer who actually uses it, but: 

Textarea
  Displays a multiple-row text area.

 is not warning me against violations of the size limit.

NOTE: Rich Text Editor suffers from the same.

This has been delivered in Oracle APEX 22.2!

Known Duplicates

Known duplicates

FR-2016
FR-2016 Rich Text Editor with CLOB Return value

Comments

Comments

  • ino.laurensse OP 3.8 years ago

    NOTE: Rich Text Editor suffers from the same.

    Indeed, and that is a problem for base64 images. APEX 22.1 now supports the CKEditor base64 plugin , but because of the 32k limit, only tiny images can be pasted in the RTE.

  • jayson hanes Admin OP 3.8 years ago

    ino - you can paste images larger than 32k into this app.. (274KB)

  • ino.laurensse OP 3.8 years ago

    Jason, the image you pasted is not a base64 image. It has this source:

    src="apex_pm/fr/files/NPnCjP….."

    whereas a base64 source looks like

    src="data:image/png;base64,iVBORw0KGgo….."

    It would be interesting to know how this ideas app uploads the image!

  • jayson hanes Admin OP 3.8 years ago

    wellll… this isn't even on APEX 22.1 yet (read: older ckeditor).. I'll see what summary I can whip up for you :)

  • ino.laurensse OP 3.8 years ago

    This is what the Ideas app uses. It looks like the trick is in uploadUrl, some ORDS process?

        // these plugins would other ise not be included by default
    options.editorOptions.extraPlugins.push(
        ClassicEditor.extraPlugins.ImageUpload,
        ClassicEditor.extraPlugins.SimpleUploadAdapter    );

    // configure upload url
    options.editorOptions.simpleUpload = {
        uploadUrl: restParams.paths.secfiles,
        // Required to enable ORDS security mapping to APEX
        headers: {
            \"Apex-Session\": restParams.headers.apexSession
        }
    };
  • smatzis OP 3.8 years ago

    Hello. Could please someone share the code to make image insert-upload working for the rich text editor in offline usage (like this app does)?

    I tried adding the above code in the "JavaScript Initialization Code" field of the rich text editor but it is not working [inside a function(options) that returns the options of course].

    Thank you very much in advance…

  • jayson hanes Admin OP 3.8 years ago

    There is some other JS to wire up as well as a rest endpoint to make it work like this.. it's not super easy and might require a blog post or video to explain. I've put it on my to-do list, but no promises.

  • smatzis OP 3.8 years ago

    Thank you so much!!! I really wish you could do that and I think many more people… Fingers crossed!

  • ino.laurensse OP 3.4 years ago

    @jayson: I've put it on my to-do list, but no promises.

    I'm still curious about this solution.

  • pauteandres91 OP 3.1 years ago

    How Get images from Rich Text Area via APEX oracle and save oracle bucket storage…