Skip to main content

Changelog

Version 24.1​

release date

2024-09-02

Table of contents

Froala​

changes
  • The Froala is updated to 4.2.1
known issues
  • Copying and pasting an image with link enabled in Firefox browser has no effect, an anchor tag is only being copied.

Image handling​

bug fixes
  • Copying and pasting images from clipboard stopped working since plug-in release 23.2.3.
  • Event UC Froala Image Upload Error stopped working after introducing the upload and update workflow.
  • When multiple instances are created, uploading images doesn't start for the second plug-in instance.
  • Typo in the workflow upload and update summary message.
new features

Page item​

bug fixes
  • Submitting a page after the plug-in Initialization JavaSctip Code raises an error is not possible.
  • Opening Froala popups (ie. insert image) raises JavaScript error when the rich text editor is in full screen mode.
  • Opening Froala popups displayed next to the right side of browser cause page horizontal scrolling.
changes
  • The toolbar button opening editor's shortcuts help popup is added to the misc group.
  • The toolbar button opening configurable paragraph styles is added to the toolbar group paragraph.
  • The default JavaScript options now include responsive toolbar configuration.

Supporting dynamic action plug-in​

bug fixes
  • Using dynamic action server-side condition EXPRESSION (Oracle APEX 22.2 onwards) raises PL/SQL error.
  • Evaluating dynamic action server side condition is case sensitive causing customizing the plug-in impossible.
  • Setting minimum height using dynamic action has no effect when maximum height is set to 100%.
  • Minimum height has no effect when the value is bigger than than the value defined using plug-in page item attribute height.
  • Dynamic actions Update CLOB, Reset Value and upload on demand produces malformed browser logs.
  • Using quote character in dynamic action name causes JavaScript errors when initializing the plug-in.
new features
changes
  • The plug-in validates a dynamic action triggering event for actions Change Settings, Change Upload Params, Change Browser Params and Initialization JavaScript Code. If dynamic action triggering event is not set to UC Before Initialization, then the plug-in raises PL/SQL error informing developer about invalid configuration.

PL/SQL API​

changes

Package UC_FROALA_RTE​

New features

Access token type​

changes
  • The new static function encode is added.

Sample application​

bug fixes
  • Home page: emptying the rich text editor is not possible due to page item default value.
  • Math Type example: link to documentation is invalid.
  • Math Type example: #APP_IMAGES# is not escaped in description region and is being replaced with the substitution actual value.
  • Show Current Font Family example: Invalid label for configuration item.
  • TOAST UI Image Editor: Invalid link to third party home page
  • Customizing rich text editor using Oracle APEX global page: dynamic action setting minimum height has no effect
  • Guided tours are displayed on top layer, when any modal page is opened.
  • General fixes for spelling and typos.
changes
  • Home page: Clearing session state and loading sample documents can be done irrespective of selected settings tab.
  • Home page: success on message when updating a document has been changed so it includes information about number of uploaded and deleted images.
  • Home page: uploading images on demand using dynamic action can be tested using settings region.
  • The example pages now use page aliases instead of page ids for better SEO.

RESTful service​

changes
  • Sample restful service name is changed from froalasamplerest to Rich Text Editor Pro Sample REST
  • The procedure argument location is removed from sample PL/SQL procedures UC_FROALA_SAMPLE_REST.imageGet, UC_FROALA_SAMPLE_REST.imageUpload and UC_FROALA_SAMPLE_REST.imageUploadFolder.
  • The parameter location is removed from sample handlers get/:fileid, upload and uploadFolder.

Documentation​

changes

General

  • The documentation is now divided into three sections: introduction, documentation and guidelines.
  • Easy navigation links are added to the top of the documentation.
  • Better text formatting for readability.
  • Existing documents are remastered

Introduction

  • The feature at a glance document is remastered and includes useful documentation and sample application cross-links.
  • The live demo documentation is remastered.
  • The changelog page navigation is simplified for released versions.
  • A new FAQ pages are created.

Documentation

  • The table of content page is created for all guidelines.
  • Documents for session state, image handling and upload workflow are remastered and described as the plug-in concepts.
  • A new document describing toolbar concept is created.
  • A new document describing using ACL customization is created.
  • A new document describing using an application global page is created.
  • Page item documentation for standard attributes, custom attributes, events and APEX integration are remastered
  • The supporting dynamic action documentation is remastered and divided into separate pages
  • The supporting process documentation is remastered
  • The plug-in database objects documentation is remastered
  • The sample RESTful service documentation is remastered
  • The PL/SQL API is now divided into function and procedures including table of contents page

Guidelines

  • The table of content page is created for all guidelines.
  • A new guidelines describing sample application installation for Oracle APEX 22.2+ is created.
  • A new guidelines describing implementing the plug-in in Oracle APEX 19.2 are created.
  • A new guidelines describing implementing the plug-in in Oracle APEX 22.2+ are created.
  • A new guidelines describing third party integrations are created.
  • A new guidelines describing toolbar JavaScript customization are created.
  • A new guidelines describing toolbar PL/SQL customization is created.
  • A new guidelines describing images JavaScript customization are created.
  • A new guidelines describing upload and update workflow is created.
  • A new guidelines describing creating a custom RESTful service are created.

Version 23.2.3​

release date

2024-01-22

Froala​

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

Copied and pasted images are added with the 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 problem is confirmed by the Froala framework bug. To add an image with the original size (without the width property set), a developer has to set the imageDefaultWidth set to 100% and the imageResizeWithPercent set to true. See an example code below:

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

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: misleading upload error message 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. The plug-in uses On-load CLOB only internally to support CLOB checksum validation and by supporting dynamic action plug-in Reset Value.
  • The plug-in PL/SQL API UC_FROALA_RTE.clobGetHTML and UC_FROALA_RTE.clobDisplay no longer use on-load CLOB. Previously, it was used when the draft CLOB value was 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 to clear the plug-in session state using APEX URL syntax.
  • The package UC_FROALA_RTE variables defined using attribute Initialization PL/SQL Code are now stored in the plug-in session state (APEX collection). They are not evaluated for validation, metadata, and AJAX plug-in interface procedures.
  • The upload error handling is now improved and handles the most common mistakes when creating a custom upload handler.
  • An image filename dragged and dropped from an end-user desktop is now 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 permanently attached to the parent container, making it always visible to the end-user.
  • Fixed: Navigating to an image using upload & update workflow dialogs does not always show an image to the end user.
  • Fixed: The upload and update workflow doesn’t show an inline APEX notification about the terminated upload.
changes
  • The upload summary dialogs are redesigned and present information about images in a 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 and procedures accepting page items as an argument now perform a 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 (Signature 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 examples are missing for the plug-in attribute JavaScript returning JSON.
  • Fixed: JavaScript errors caused by the developer's invalid input are only shown in a browser console. Now, errors are shown as APEX inline notifications.
new features

New features​

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

Documentation​

bug fixes
  • 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 the 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 is missing the action Allow Image Resizing.
  • Fixed: The plug-in session state is missing information about collection column c003 used by the supporting process plug-in
changes
  • 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 across 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 recognized and handled by the plug-in by showing a proper error message.
  • Upload handler does not need to include data-temp-image-id in the 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 tokens.
  • A new package variable UC_FROALA_RTE.g_disable_rest_enabled_check can now be 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 the APEX version and if it supports CLOB values in the APEX session state.
  • Debug messages now include the package name used to render the plug-in instance.
  • Debug messages now include whether the plug-in instance is CLOB enabled (Shared components \ Plug-ins \ Item plug-in \ Standard Attributes).
  • Debug messages now include information on whether a page item implementing the plug-in is CLOB enabled (Page Designer \ Item \ Session State \ Data Type).
  • All plug-in errors and warnings are prefixed with RTE Error and RTE Warning to distinguish them from other non-plug-in PL/SQL warnings and errors.

Sample application​

bug fixes
  • Fixed: The breadcrumb button opening the context menu does nothing when the United Codes Context Menu plug-in 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.

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

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
changes

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
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
New features
  • New action Upload Images on demand

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

Package UC_FROALA_RTE​

changes

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

Package UC_FROALA_SETTINGS​

changes

New package variable g_disable_rest_enabled_check

Sample application​

changes

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​

changes
  • 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​

bug fixes
  • 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

changes
  • 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.

PL/SQL API​

changes
  • 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​

changes
  • The plug-in documentation can be opened directly from the sample application pages.
bug fixes
  • Fixed: the de-installation script raises an error on removing package PIP_CRYPTO.

Documentation​

changes
  • The documentation is remastered and available at https://www.united-codes.com/ords/links/plugins/rich-text-editor-pro/docs/.
  • 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​

changes
  • 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

Froala​

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

Annotations

  • [1] The Froala changelog is available here.

Page item​

bug fixes
  • 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

  • [2] based on version 22.1.1 which was never released publicly.

Package PIP_CRYPTO​

changes
  • The package PIP_CRYPTO is now renamed to UC_CRYPTO

Version 22.1.1​

release date

Never

bug fixes
  • 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.