Skip to main content

Changelog

Version 23.2.3​

Release date: 2024-01-16

Froala​

Changes​

  • The Froala framework is upgraded to version 4.1.4. See the Froala changelog to learn more about changes.

Page item​

Bug fixes​

  • Fixed: emptying rich text document and submitting page results in setting the on-load CLOB value instead of using value resulting from page item attribute Source \ Used \ Only when current value in session state is null.
  • Fixed: evaluating the plug-in attribute Initialization PL/SQL Code might raise an error when performing page validation or plug-in AJAX requests. The attribute is now evaluated only once when rendering the plug-in.
  • Fixed: the plug-in upload error message is misleading when an image upload request is terminated by the network error (AJAX ready state 0).

Changes​

  • The on-load CLOB is no longer used to compute page item value on page load. On-load CLOB is used only internally by the plug-in to support CLOB checksum validation and byt the supporting dynamic action plug-in Reset Value.

  • The plug-in PL/SQL API UC_FROALA_RTE.clobGetHTML and UC_FROALA_RTE.clobDisplay no longer uses on-load CLOB. Previously, it was used when draft CLOB value is NULL.

  • The PL/SQL procedure UC_FROALA_RTE.manageClearCache is no longer required to clear the plug-in session state using Oracle APEX URL syntax in Oracle APEX 22.2 onwards. For prior APEX releases the procedure is mandatory.

  • The package UC_FROALA_RTE variables defined using attribute Initialization PL/SQL Code are now stored in the plug-in session state (APEX collection).

  • The upload error handling is now improved and handles the most common mistakes when creating a custom upload handler.

  • An image filename drag and dropped from end-user desktop is not available in the RESTful service upload handler.

UX & UI​

Bug fixes​

  • Fixed: When refreshing the rich text editor, a spinner is hidden due rich text editor scrollbar and maximum height. Now, a spinner is always attached to the parent container making it always visible to the end-user.
  • Fixed: Navigating to an image using upload & update workflow dialogs not always show an image to the end-user
  • Fixed: The upload and update workflow doesn’t show an inline APEX notification about terminated upload.

Changes​

  • The uplaod summary dialogs are remastered and present information about images in tabular layout.

PL/SQL API​

Bug fixes​

  • Fixed: The procedure UC_FROALA_RTE.manageClearCache doesn’t clear page items implementing the plug-in when URL syntax is missing CR, RP, or RR in Oracle APEX URL syntax for clearing page items.
  • Fixed: With the plug-in version 23.2, the function UC_FROALA_RTE.setValue stopped returning a given CLOB checksum as the function result.

Changes​

  • Functions aand procedures accepting page item as an argument now performs check if a given page item implements the plug-in. If not, the PL/SQL error is raised.
  • Function and procedure UC_FROALA.setValue (Signature 2) raises an error when an invalid CLOB type is given.
  • Function UC_FROALA_RTE.getValue always returns the current value of the draft CLOB - previously, it could return on-load CLOB if draft CLOB was NULL.
  • Procedure UC_FROALA_RTE.clear accepts a new optional argument p_set_session_state with a default value false. When p_set_session_state is set to true, a page item APEX session state is set to NULL. When set to false, only the plug-in session state is purged (APEX collection).
  • Procedure UC_FROALA_RTE.clobDisplay accepts a new optional argument p_include_css with default value true. When set to false, the plug-in doesn’t add the plug-in CSS files styling rich text documents using default rich text editor CSS rules.
  • Function UC_FROALA_RTE.setValue (Singature 1) sets only draft CLOB in the plug-in session state. Previously it was updating on-load CLOB as well.

Supporting dynamic action plug-in​

Bug fixes​

  • Fixed: Help text and help text example is missing for the plug-in attribute JavaScript returning JSON.
  • Fixed: JavaScript errors caused by developer's invalid input are only shown in a browser console. Now, errors are shown as APEX inline notification.

New features​

  • Action Update CLOB supports optional JavaScript callbacks (done and fail) definable using the attribute JavaScript Initialization Code.

Documentation​

  • Fixed: Function UC_FROALA_RTE.setValue parameter p_set_session_state is wrongly described since the plug-in release 23.2. Since the plug-in version 23.2, the function updates a page item session state to actual CLOB value instead of the given CLOB checksum.

  • Fixed: Procedure UC_FROALA_RTE.clobDisplay (Signature 1) lists parameter p_item_name instead of p_clob.

  • Fixed: The supporting dynamic action plug-in describes is missing action Allow Image Resizing.

  • Fixed: The plug-in session state is missing information about collection column c003 used by the supporting process plug-in

  • The package UC_FROALA_SETTINGS variables are now described in Item Plug-in \ Database objects \ Package UC_FROALA_SETTINGS

  • The package UC_FROALA_RTE variables available for the plug-in attribute Initialization PL/SQL Code are moved from Item Plug-in \ Custom Attributes \ Initialization PL/SQL Code to Item Plug-in \ Database objects \ Package UC_FROALA_RTE

  • The plug-in session state has been updated due to mandatory changes for CLOB support cross APEX versions.

  • The plug-in documentation mentions new integrations with the Froala third-party plug-ins such as WProofReader Web Spell Check, Wiris Math Type, CODOX.io and Track changes

  • The supporting dynamic action plug-in Change Settings includes information about alternative customization using the page item attribute JavaScript Initialization Code.

RESTful service​

Improvements​

  • Upload handler raising error 555 User Defined Error is now recognised and handled by the plug-in
  • Upload handler does not need to include data-image-id in the upload result JSON

Database objects​

Changes​

  • Access token type UC_RTE_ACCESS_TOKEN exposes static and member functions
  • Package UC_FROALA_SAMPLE_REST doesn’t reference UC_FROALA_RTE functions decoding access token.
  • Package UC_FROALA_RTE relies on access token type static and member functions to handle access token.
  • A new package variable UC_FROALA_RTE.g_disable_rest_enabled_check can be now used in the plug-in attribute Initialization PL/SQL Code as an alternative to defining UC_FROALA_SETTINGS.g_disable_rest_enabled_check on package level.

Debugging​

Changes​

  • Debug messages now include information about APEX version and if it supports CLOB values in APEX session state.
  • Debug messages now include the package name used to render the plug-in instance.
  • Debug messages now include information whether the plug-in instance is CLOB enabled in APEX shared components.
  • Debug messages now include information whether a page item implementing the plug-in is CLOB enabled.
  • All plug-in errors and warning are prefixed with RTE Error and RTE Warning to distinguish from other non-plug-in PL/SQL warnings and errors.

Sample application​

Bug fixes​

  • Fixed: breadcrumb button opening context menu is doing nothing when United Codes context menu is not installed. Now, when the plug-in is not installed, the modal page with information about the plug-in is shown as initially intended

Changes​

  • Internal development pages not shown in the sample application are now removed from the sample application

Known Issues​

Copied and pasted images are added with width set to 0px​

The issue occurs when a developer uses the Froala option imageDefaultWidth set to 0 in the plug-in attribute JavaScript Initialization Code. The issue is confirmed Froala framework bug. To add an image with original size (without width property set), a developer has to set imageDefaultWidth set to 100% and imageResizeWithPercent set to true. See an example code below:

function( pOptions ) {
 pOptions.imageDefaultWidth = ‘100%’;
 pOptions.imageResizeWithPercent = true;
 return pOptions;
}

Version 23.2.2​

Release Date: 2023-10-24

Froala framework​

Changes​

  • The Froala WYSIWYG editor updated to 4.1.3 - changelog

Item plug-in​

Bug fixes​

  • Fixed: Component settings Image Upload URL (Value Required) in 23.2.1 was referencing a hardcoded invalid URL
  • Fixed: Plug-in attribute File URLs to Load \ Cascading Style Sheet was having extra / for plug-in file froala_editor.pkgd.min.css, causing editor not to render correctly on servers with strict policies
  • Fixed: Computing REST handlers URL based on the plug-in substitution string #DEFAULT_*# was malformed when owa_util.get_cgi_env('X-Forwarded-Port') is set to NULL
  • Fixed: Uploading error message when REST upload handler raises errors ERR_* was misleading, pointing to CORS policies [1]
  • Fixed: Updating CLOB using supporting dynamic action was setting a page item session state to not supported value, including on-load checksum [2]

Annotations

  • [1] Now, it prompts a developer to check an error in a browser console for a detailed error raised by a browser.
  • [2] When using the plug-in APEX before 22.2, and the CLOB value exceeds the VARCHAR2 limitation, the plug-in nulls a page item session item, similarly to the APEX engine.

Version 23.2.1​

Release Date: 2023-10-06

The plug-in is successfully tested with the most recent APEX version (23.1.3) at apex.oracle.com.

Packages​

UC_FROALA_RTE​

Bug fixes​
  • Fixed: Checking APEX version for CLOB support raises an error on Oracle APEX 22.1.x

Sample application​

Bug fixes​

  • Fixed: A few sample application pages breadcrumb title doesn't match example title

Version 23.2​

Release Date: 2023-09-20

The plug-in is successfully tested with the most recent APEX version (23.1.3) at apex.oracle.com.

Rich Text Editor Pro​

General​

  • Froala editor is updated to 4.1.2
  • a page item value in the session state is no longer the checksum of the current rich text - on APEX before 22.2, when the rich text content exceeds VARCHAR2 limitation, the session state is set to NULL according to APEX capabilities
  • Checksum validation is stored in f01 or a page item if defined
  • The editor’s toolbar layout is refined - buttons are regrouped within Froala editor’s toolbar groups: paragraph, text, rich, and misc.

Bug fixes​

  • Fixed: Removing duplicated uploaded images one by one doesn’t result in marking an image as removed in the plug-in session state.

  • Fixed: The editor’s popup when inserting an image was cropped by APEX CSS rules for the grid column

  • Fixed: The editor’s popup when inserting a link was cropped by APEX CSS rules for the grid column

  • Fixed: The editor’s popup when inserting a font awesome icon was cropped by APEX CSS rules for the grid column

  • Fixed: The editor’s popup when inserting special characters was cropped by APEX CSS rules for the grid column

  • Fixed: The editor’s popup inserting emoticons icon was cropped by APEX CSS rules for the grid column

  • Fixed: The editor’s popup inserting video was cropped by APEX CSS rules for the grid column

  • Fixed: Clearing the plug-in session state using URL syntax and PL/SQL API manageClearCache was not working as expected

New features​

  • Support for native CLOB support starting with APEX 22.2 [1]
  • The native Form component is now supported for APEX 19.2 and above [2]
  • New image uploading mechanism
  • Upload images on demand using dynamic action
  • New third-party integrations are introduced
  • Enhanced handling for uploaded images

Annotations

  • [1] Native CLOB support still has flaws. For example, page item attribute Value required raises an error when rich text content exceeds the VARCHAR2 limitation. The workaround is to use APEX validation NOT NULL
  • [2] Before APEX 22.2, the supporting process plug-in is required to handle CLOB values exceeding the VARCHAR2 limitation. CLOB values below 32 767 characters are supported natively

Support for CLOB values across APEX versions

  • Form component is supported across APEX versions - before APEX 22.2, the supporting process plug-in is required to handle CLOB values exceeding the VARCHAR2 limitation. CLOB values below 32 767 characters are supported natively
  • When not using a supporting plug-in, CLOB is supported by the APEX engine

New image uploading mechanism

  • Images are uploaded in parallel, not one by one
  • Possibility to preview upload errors and successes from page item level
  • Configurable upload workflow to automatically cancel, continue or ask the end-user to take an action
  • An image upload parameters are evaluated for each image when uploading

Upload images on demand

  • Images can be uploaded on demand using the supporting dynamic action plug-in
  • A developer can specify three JavaScript callbacks to be executed based on the upload workflow: fail, cancel, and done

Third-party plug-ins are supported

  • A free third-party plug-in supported: Track Changes
  • Paid third-party plug-in supported: WProofreader WebSpellCheck for Froala
  • Paid third-party plug-in supported: Wiris Math Type
  • Paid third-party plug-in supported: CODOX.io

Enhancements​

  • A new page item level attribute Initialization PL/SQL Initialization
  • A new application level attribute Initialization PL/SQL Initialization
  • Page item source type Database Column is supported when using native form component [1]
  • Page item source type Item is supported [1]
  • Page item source type PL/SQL Expression is supported [1]
  • Page item attribute Default is now supported [1]
  • Page item attributes Pre and Post are now supported
  • Computing page item height is enhanced - minimum and maximum height is computed based on page item Height attribute, JavaScript Initialization Code (height, heightMax, heightMin), or value overridden using supporting dynamic action plug-in

Annotations

  • [1] The plug-in relies on the APEX capabilities to handle CLOB values.

Item plug-in​

Bug fixes​

  • Fixed: When the plug-in attribute JavaScript Initialization Code raised an error, the unhandled error message was shown. Now. the plug-in shows why, for example, the returned value from the anonymous JavaScript function is undefined.
  • Fixed: plug-in wasn’t initialized when dynamic action customizing the editor wasn’t executed immediately

Changes​

  • The setting Enable TUI Image Editor is removed from page item attribute Settings in favor of the package variable UC_FROALA_RTE.g_plug_tui_enable. By default, it’s set to true, and it can be configured on the page item level or application level
  • A new page item attribute Settings option is added: Expand height to fit rich text
  • A new page item attribute is added: Initialization PL/SQL Code
  • A new component settings attribute is added: Initialization PL/SQL Code

Dynamic Action plug-in​

Bug fixes​

  • Fixed: missing help text for Upload parameters
  • Fixed: missing help text for Image Browse Parameters
  • Fixed: When dynamic action was implemented on the global page and it was containing true and false actions, and dynamic action wasn’t applied to the current instance, it made the plug-in stuck on initialization
  • Fixed: using multiple instances where one is customized with dynamic action blocks initialization of each

New features​

  • New action Upload Images on demand

Changes​

  • Standard attribute JavaScript Initialization Code is enabled - right now, it is used only by a new action* upload images on demand
  • Dynamic actions support dynamic action Wait For Result attribute
  • Customizing rich text editor using global page has been redesigned

Process plug-in​

Changes​

  • A new flag, g_froala_image_safe_to_delete is available for Delete Removed Images
  • When Update PL/SQL doesn’t update CLOB in the database (SQL%ROWCOUNT is 0) then, the plug-in error message is set to Updating #LABEL# failed. where #LABEL# is page item label text.

New features​

  • A new process Process Uploaded Images looping over recently uploaded images, has been added

Packages​

UC_FROALA_RTE​

General​
  • New package variable g_update_include_rowcount
  • New package variable g_toolbar_presets_refined
  • New package variable g_warn_about_clob [1]
  • New package variable g_froala_image_safe_to_delete [2]
  • New package constant c_toolbar_group_paragraph [3]
  • New package constant c_toolbar_group_text [3]
  • New package constant c_toolbar_group_rich [3]
  • New package constant c_toolbar_group_misc [3]

Annotations

  • [1] if enabled and APEX supports CLOB and page item attribute Data Type is not set to CLOB, then the plug-in shows an error prompting to enable CLOB on page item level.
  • [2] It was released with v23.1 but not included in the changelog
  • [3] constants should be used as values for g_plug_trackchanges_group, g_plug_wiris_editor_group, g_plug_wiris_chemistry_group
Third-party integration: Track Changes​
  • New package variable g_plug_trackchanges_enable
  • New package variable g_plug_trackchanges_group
  • New package variable g_plug_trackchanges_pos
Third-party integration: TOAST UI Image Editor​
  • New package variable g_plug_tui_enable
Third-party integration: WProofreader Text Checker​
  • New package variable g_plug_spellcheck_enable
  • New package variable g_plug_spellcheck_js
  • New package variable g_plug_spellcheck_api
  • New package variable g_plug_spellcheck_lang
  • New package variable g_plug_spellcheck_ui_lang
  • New package variable g_plug_spellcheck_theme
  • New package variable g_plug_spellcheck_badge_enable
  • New package variable g_plug_spellcheck_badge_lang
Third-party integration: Wiris Math Type​
  • New package variable g_plug_wiris_enable
  • New package variable g_plug_wiris_js
  • New package variable g_plug_wiris_editor_group
  • New package variable g_plug_wiris_editor_pos
  • New package variable g_plug_wiris_chemistry_group
  • New package variable g_plug_wiris_chemistry_pos

UC_FROALA_SETTINGS​

New package variable g_disable_rest_enabled_check

Sample application​

New features​

  • Preview the plug-in page item definition directly in the sample application
  • Preview the plug-in dynamic action definition directly in the sample application
  • Preview the plug-in process definition directly in the sample application
  • Preview the native form definition directly in the sample application
  • Example pages are described using United Codes Guided Tour Pro
  • Examples pages navigation is enhanced with the United Codes Context Menu

New examples​

  • Native form implementation for Oracle APEX 22.2 and above
  • Native form implementation for Oracle APEX before 22.2
  • Using page item source attribute to load CLOB content
  • Display CLOB rich text using page item read-only attribute
  • Handle CLOB using the supporting process plug-in only
  • Handle CLOB using the plug-in PL/SQL API only
  • Configure the plug-in upload images workflow
  • Save images in the context of rich text in the database
  • Custom toolbar: Google Calendar
  • Custom toolbar: Google Docs
  • Third-party integration: Track Changes
  • Third-party integration: WProofreader WebSpellChecker
  • This-party integration: Wiris Math Type
  • Process Uploaded Images
  • Upload Images on demand

Refined examples​

  • Customize the rich text editor using
  • Send e-mail written using rich text editor
  • Home page

Database objects​

  • A new sample table UC_FROALA_SAMPLE_CLOB_BLOBS
  • A new sequence UC_FROALA_SAMPLE_CLOB_BLOBS_SEQ
  • A new constraint UC_FROALA_SAMPLE_CLOB_BLOBS_FK
  • A new constraint UC_FROALA_SAMPLE_CLOB_BLOBS_FK2

Version 23.1​

Release Date: 2023-03-15

The plug-in is successfully tested with the most recent APEX version (22.2.4) at apex.oracle.com.

Item plug-in​

  • All files except the TUI image editor and language files are referenced in an application builder's plug-in definition - see the plug-in attribute File URLs to Load. Referencing the plug-in JS and CSS files on th plug-in definition level enables a developer to move the plug-in files to an external server.
  • Fixed: the plug-in export file size is reduced from 13,3 MB to 6,4 MD due to removing redundant Froala files from the plug-in definition.
  • Fixed: WEBP images don't raise an error when uploading.
  • Fixed: the plug-in raises an error for a non-existing metadata procedure.
  • Fixed: an image collection flag save to remove is being wrongly computed when an image URL protocol differs from an application's protocol.
  • Fixed: missing workspace name when an application uses friendly URLs and when REST URL is computed from the plug-in substitution strings #DEFAULT_REST_URL_*
  • Fixed: the plug-in event UC Froala Images In Collection triggered with corrupted event data. [1]
  • Fixed: the plug-in raises a PL/SQL error when computing a CLOB checksum for CLOBs value bigger than 8 MB.
  • Fixed: missing help text for the standard plug-in attribute Execute JavaScript Initialization Code

Annotations

PL/SQL API​

  • A new signature for function UC_FROALA_RTE.clobGetHTML is now available. The function accepts an item name implementing the plug-in.
  • A new signature for procedure UC_FROALA_RTE.clobDisplay is now available. The procedure accepts an item name implementing the plug-in.

Sample application​

  • The plug-in documentation can be opened directly from the sample application pages.

  • Fixed: the de-installation script raises an error on removing package PIP_CRYPTO.

Documentation​

  • The documentation is remastered and available at https://www.united-codes.com/products/plug-ins-pro/docs/rich-text-editor-pro.
  • The database objects created after installation are now described.
  • The installation instructions (sample application and manual installation) are now described.
  • The license activation instructions are now described.
  • The support instructions are
  • The downloading instructions are now described.
  • The changelog is now included in the documentation.

Installation bundle​

  • DDL scripts removed: ddl_unitedcodes_rich_text_editor_pro.sql and ddl_unitedcodes_rich_text_editor_pro_sample_rest.sql. [1]
  • A new DDL script is now available: ddl_uc_rte_update_plugin_pkgs.sql. [2]
  • A new DDL script is now available: ddl_uc_rte_manual_install.sql. [3]
  • A new DDL script is now available: ddl_uc_rte_manual_deinstall.sql. [4]

Annotations

  • [1] Scripts are replaced by a new DDL script ddl_uc_rte_manual_install installing all objects at once.
  • [2] The script overrides the plug-in packages UC_FROALA_RTE, UC_FROALA_SETTINGS, and the plug-in type UC_RTE_ACCESS_TOKEN.
  • [3] The script is used to manually install the plug-in database objects in an existing application.
  • [4] The script removes database objects created using the script ddl_uc_rte_manual_install.sql.

Version 22.2​

Release Date: 2022-01-18

  • The Froala editor is upgraded from version 3.2.6-1 to 4.0.16. [1]

  • The package PIP_CRYPTO is now renamed to UC_CRYPTO

  • Fixed: the plug-in raises an error for a non-existing metadata procedure on APEX 22.x.

  • Fixed: the plug-in raises a JavaScript error when a modal page implementing the plug-in uses page attributes width and height. [2]

Annotations

  • [1] The Froala changelog is available here.
  • [2] based on version 22.1.1 which was never released publicly.

Version 22.1.1​

Release Date: never

  • Fixed: the plug-in raises a JavaScript error when a modal page implementing the plug-in uses page attributes width and height.
  • Fixed: substitution string #OWNER_LOWER# is again available in order to reference REST URL without RESTfulservice name

Version 22.1​

Release Date: 2022-01-18

Important notice regarding upgrading from v21.3 and v21.4

Changes introduced with this release might be affected by the current plug-in settings in your existing implementation. It is strongly recommended that you upgrade the plug-in in a copy of your application before releasing it to a production environment.

  • After upgrading the plug-in in your application, examine the plug-in component settings in Shared Components. Attributes configuring URLs to the REST module must be (if using #OWNER_LOWER#) updated with new default values described in help texts. If any plug-in instance is using Override Application Attributes, it must be updated too. Using #OWNER_LOWER# results in showing an error on page load. Learn more about REST URL attributes help text.
  • Examine changes in the sample REST package for uploading images (procedure UC_FROALA_SAMPLE_REST.imageUpload) - REST template uploading images has to return the full URL to the uploaded image. The current value of a new attribute Image GET URL is available through the plug-in access token, and it must be used to return an image URL by REST template upload.
  • To enable uploading images, examine all plug-in implementations and set the new plug-in attribute Upload Image(s) on Request(s) on the item level. Otherwise, newly added images will never be uploaded using the plug-in REST.
  • If you were processing images (stored in the plug-in collection) on page submission, you must adapt to the new collection column usage - learn more in the plug-in documentation.
  • If you were using the supporting dynamic action plug-in action Browser Parameters, ensure dynamic actions implementing the action listen to the plug-in event Froala Before Initialization.

General​

  • Froala framework has been updated from version 3.2.1 to 3.2.6-1 (learn more in Froala change log Changelog for WYSIWYG Editor - Froala )
  • Froala is now more RWD-friendly and adapts editor width dynamically.
  • Image resizing with the mouse is now enabled by default.
  • Multibyte characters are supported and don't raise an error when processing CLOB content.
  • When an application (or item) level attributes defining REST URLs have a different protocol than currently used in the browser, the plug-in forces the current protocol

Image handling​

  • Images are now uploaded only for defined page request(s) when a page is submitted. If the plug-in does not upload images, they remain in CLOB content as they were added (or loaded with CLOB) to the editor. For example, images added from the desktop are embedded as inline base 64 images by default,
  • If an image is copied and pasted into the plug-in editor within a browser, the plug-in will try to download an image (based on the src attribute) and upload (using REST) it on-page submission. If the plug-in fails to download an image, the end-user is asked whether to cancel the upload or preserve the image in CLOB content as it is.
  • Images uploaded using plug-in REST and removed from the editor can be easily deleted in the database using the new supporting plug-in process type Delete Removed Images.
  • Images statuses in the collection were re-designed and use different collection columns - learn more in the documentation.
  • Pasting content containing images from Microsoft Word or Google docs is now supported.
  • Images added to the editor use fewer data-* attributes to track images.

Item plug-in​

Item Attributes

  • Application-level attributes for REST URLs are now required.
  • New item level attribute Upload Image(s) on Request(s) defining page submit a request for which images are uploaded.
  • Item level attributes Image Browse URL; Image Delete URL and Image Upload URL use new default values #DEFAULT_REST_URL_UPLOAD#, #DEFAULT_REST_URL_BROWSE#, #DEFAULT_REST_URL_DELETE#. Old substitution string #OWNER_LOWER# is still supported but deprecated.
  • Item-level attribute Settings \ Embed Images as Inline Base64 was removed.
  • Application and item level attribute Image GET URL have been added along with default value #DEFAULT_REST_URL_GET#.
  • Application and item level attributes Image Browse URL, Image Delete URL, Image Upload URL, and Image GET URL can use substitution string #DEFAULT_REST_URL_MODULE# - see the attribute help text for detailed information.

Events

  • Event Froala Image Removed was removed.
  • Event Froala Image Inserted was removed.
  • Event Froala Images in Collection is updated and exposes new data - learn more in the plug-in documentation.

Dynamic action plug-in​

  • The supporting plug-in now supports Oracle APEX dynamic action flag Wait for Result
  • Action Enable Base64 Images was removed.
  • Action Disable Base64 Images was removed.
  • Action Browser Parameters has been updated and must now be created only for the plug-in event Froala Before Initialization.

Process plug-in​

  • A new process type, Delete Removed Images, is added (learn more about usage in the sample application)

PL/SQL API​

  • A new procedure clobDisplay is added.
  • A new function clobGetHTML is added.

RESTful Service​

  • Sample REST module ucfroalasamplerest is updated on the template level.

  • Sample REST module ucfroalasamplerest package UC_FROALA_SAMPLE_REST has been updated.

    • Procedures were adapted to the new image handling.
    • Procedures now have default error handling implemented.

Sample Application​

  • The home page has been updated in order to show major plug-in features.
  • A new page The Plug-in \ Attributes \ Upload Images on Request has been added,
  • The page The Plug-in \ Events has been updated.
  • The page The Plug-in \ Attributes Plug-in \ Embed Images as Inline Base64 was removed
  • The page The plug-in \ Attributes \ Height has been updated.
  • A new page Supporting plug-ins \ United Codes Rich Text Editor Pro (Process) \ Delete Removed Images has been added,
  • The page Supporting plug-ins \ United Codes Rich Text Editor Pro (Extend) \ Minimum Height has been updated.
  • The page Supporting plug-ins \ United Codes Rich Text Editor Pro (Extend) \ Maximum Height has been updated.
  • The page Supporting plug-ins \ United Codes Rich Text Editor Pro (Extend) \ Base64 Images was removed.
  • The page Supporting plug-ins \ United Codes Rich Text Editor Pro (Extend) Browse Parameters is updated - the page description was invalid and misleading.
  • The page Examples \ How to display CLOB content? has been updated
  • The page Examples \ How to create and send an HTML email? has been updated
  • The page Examples \ How do I print the contents of my editor? has been updated

Supporting Objects​

  • Installation scripts have been updated.

  • Deinstallation scripts have been updated. All plug-in supporting objects are now removed. If any other plug-in is activated in the current workspace, the script won't remove the objects listed below:

    • UC_PLUGISNPRO_LICENSE table
    • PIP_CRYPTO package
    • UC_PLUGINSPRO package

Version 21.3​

Release Date: 2021-03-31

Updated licensing mechanism.

Important Note: Installing a Plug-ins Pro plug-in containing the 31-MAR-2021 licensing update will require that ALL Plug-ins Pro plug-ins installed in the same schema be updated and reactivated to a compatible version released on or after 31-MAR-2021.

Version 21.2​

Release Date: 2021-03-03

Fix for supporting plug-in process:

  • When the plug-in collection wasn't initialized, the plug-in type Clear was raising an error on clearing the plug-in not initialized collection. Now, removing an item CLOB value from the plug-in collection is done only if the collection is initialized. Otherwise, no action is performed.
  • When the plug-in type was set to Load from SQL Query and provided SQL query returned other types than CLOB, the plug-in wasn't able to fetch CLOB value using APEX_EXEC.GET_CLOB. Now, the plug-in raises an error if APEX_EXEC.GET_CLOB raises no_data_found. In order to fetch a non-CLOB value from SQL Query, it is required to use the to_clob function within SQL Query. For example: select to_clob(123) from dual

Fix for license creation to support Oracle Database 21c.

Version 21.1​

Release Date: 2021-02-01

The following fixes are included in 21.1:

  • Modal Page issue fix: creating the plug-in instance is followed with a timeout check (500ms) to initialize the plug-in if event theme42ready or apexwindowresized is not triggered.
  • Added apex-session for ORDS RESTful call header / allows authenticating call on ORDS level
  • Refactored error handling for the process plug-in
  • When the process plug-in load actions execute and no_data_found is raised, the plug-in logs information on the PL/SQL level and sets the CLOB to NULL

Version 20.1.1​

Release Date: 2020-12-02

The following fixes are included in 20.1.1:

  • Initialization of RTE in a Modal window
  • Compatibility with Oracle DB 12c

Version 20.1​

Release Date: 2020-11-20

Initial release! Rich Text Editor Pro is now available for download.