Skip to Main Content

Title region

Breadcrumbs

Update CLOB

The action updates the current CLOB value in the plug-in session state on the end-user demand.

Preview components

Click on the page component below to preview its configuration in the Oracle APEX page designer.

Documentation

Read the plug-in documentation to learn more about this supporting dynamic action.

Learn more

The supporting plug-in can refresh CLOB (on demand ) to the state when a page is loaded.

Live demo

Plug-in

Ideas

Here, we share the idea on how the supporting dynamic action Update CLOB can be utilized in your application.

Auto-update the APEX session state

When the end-user accidentally closes the page or goes to the other page, the page submission might not happen. If the Warn on Unsaved Changes is disabled, all the changes done in a rich text might be lost. You can implement the auto-update mechanism to prevent losing changes written by the end user. To implement such a feature, the following components must be combined:

  • the plug-in event UC Froala Content Change
  • the supporting dynamic plug-in Update CLOB

Auto-save CLOB content in a database

The feature is similar to the auto-update session state. To save the CLOB content automatically, the following components must be combined:

  • the plug-in event UC Froala Content Change
  • the supporting dynamic plug-in Update CLOB
  • the Oracle APEX dynamic action Execute PL/SQL Code
  • the plug-in PL/SQL function getValue