Hi
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
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?
Vinish Kapoor
You can create an interactive grid or form on the table having a CLOB field. Then you can change the item type to textarea, rich text editor or markdown editor for the CLOB field so that the user can edit the CLOB data.
sai
Hi Vinish,
As per your blog that I mentioned previously, CLOB is being displayed in Region as static content. Its working fine to display CLOB data. But, I dont see any options to convert the region to textarea or rich text for editing. Can you advise?
sai
Hi Vinish,
One more thing is, I tried to create fresh interactive report with clob field. Automatically, clob field is set to plain text and run time it says pl/sql numeric error as clob size is big. Also, I could not convert field type from plain text to textarea or rich text.
Vinish Kapoor
Change interactive report to interactive grid then you will be able to change field type to rich text.