Search code examples
oracle-databaseoracle-apexapexapex-codeoracle-apex-19.2

Edit clob data in oracle apex

I have to show oracle database table data in oracle apex interactive report. This table has a clob column(mime type: text/plain).

I am able to successfully display clob data in oracle apex interactive report as guided in below post https://www.foxinfotech.in/2019/12/displaying-clob-contents-in-oracle-apex.html

Now, I should be able to edit clob column data and save the updated clob data back to database. But I am unable to do this.

Can some one help with this?

Solution

  • Your requirement is to View and Edit a CLOB Content.
    This can be achieved by using AJAX in Oracle APEX.
    I have created a Blog Post for the above requirement. Please use the link below: https://akilramesh.blogspot.com/2021/06/display-and-edit-clob-content-in-oracle.html

    Demo: https://apex.oracle.com/pls/apex/workspace_akil/r/demo/show-and-edit-clob