Edit clob data in oracle apex

0
votes

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?

1
oracleoracle-apexapexapex-codeoracle-apex-19.2
There are a couple of plugins available for this - you could try this: github.com/OraOpenSource/apex-plugin-clob-load - Koen Lostrie

1 Answers

0
votes

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