Skip to Main Content

Release History

  • The Plug-ins Pro Team 17-MAY-2023
    UC AutoNumeric

    UC Autonumeric v23.1 is now ready for download!  This release includes:

  • The Plug-ins Pro Team 15-MAY-2023
    Gantt Chart Pro

    Minor update:

    • BugFix on move task (before: if the date (items on top of the grid) was changed, then move action stopped working)
    • BugFix on refresh Gantt (before: if the date (items on top of the grid) was changed, all the tasks were scattered and not neatly aligned.)
    • Upgrade on edit task (click on the task) - In 'EDIT Link'  is now also possible to pass variable APEX$GANTT_RESOURCE_ID
  • The Plug-ins Pro Team 17-APR-2023
    PDF Region Pro

    Initial release!  PDF Region Pro is now available for download.

  • The Plug-ins Pro Team 13-APR-2023
    Enhanced Grid Pro

    Initial release!  Enhanced Grid Pro is now available for download.

  • The Plug-ins Pro Team 15-MAR-2023
    Rich Text Editor Pro

    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.plug-ins-pro.com/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.
  • The Plug-ins Pro Team 13-DEC-2022
    UC AutoNumeric

    Initial release!  UC AutoNumeric is now available for download.

  • The Plug-ins Pro Team 09-DEC-2022
    SweetAlert2 Pro

    Initial release!  SweetAlert2 Pro is now available for download.

  • The Plug-ins Pro Team 03-MAR-2022
    Automatic Constraint Validation Pro

    Version 22.1.08 of Automatic Constraint Validation Pro is ready to be downloaded.  Improvements include:

    Sample Application Bug Fixes

    • Forms on all pages - After successful saving of a form with 'Apply Changes' or 'Create' the form was empty. Now the app stores the PK values in session state.
    • On page Introduction / Events / Item \ Column - the Instruction list was not clickable. The links have been fixed.

    Library 

    • function validate_form_items_list:
      • checked conversion of item min and max values
      • date item min and max : changed wrong format 'YYYY-MM-DDTHH24:MI:SS' to 'DD-MON-YYYY'
      • allowed process points now include 'Before Regions'
      • Improved validation messages for foreign keys and intervals.
    • function Current_Page_Has_No_Plugin_DA:
      • The function now returns true when the current page has no plug-in invocations and the current page has input fields for database columns.

    New Plug-in Arguments

    • Added filter for inactive constraints.
    • Added Table Name Prefix. (To be removed from displayed table names.)

    Javascript event handler 

    • Ignore leading and trailing blanks in key comparison for IG uniqueness test
    • Improved messages for composite uniqueness test
  • The Plug-ins Pro Team 03-MAR-2022
    UC Automatic Constraint Validation

    Version 22.1.08 of UC Automatic Constraint Validation is ready to be downloaded.  Improvements include:

    Sample Application Bug Fixes

    • Forms on all pages - After successful saving of a form with 'Apply Changes' or 'Create' the form was empty. Now the app stores the PK values in session state.
    • On page Introduction / Events / Item \ Column - the Instruction list was not clickable. The links have been fixed.

    Library 

    • function validate_form_items_list:
      • checked conversion of item min and max values
      • date item min and max : changed wrong format 'YYYY-MM-DDTHH24:MI:SS' to 'DD-MON-YYYY'
      • allowed process points now include 'Before Regions'
      • Improved validation messages for foreign keys and intervals.
    • function Current_Page_Has_No_Plugin_DA:
      • The function now returns true when the current page has no plug-in invocations and the current page has input fields for database columns.

    New Plug-in Arguments

    • Added filter for inactive constraints.
    • Added Table Name Prefix. (To be removed from displayed table names.)

    Javascript event handler 

    • Ignore leading and trailing blanks in key comparison for IG uniqueness test
    • Improved messages for composite uniqueness test
  • The Plug-ins Pro Team 09-FEB-2022
    Automatic Constraint Validation Pro

    Initial release!  Automatic Constraint Validation Pro is now available for download.

  • The Plug-ins Pro Team 09-FEB-2022
    UC Automatic Constraint Validation

    Initial release!  UC Automatic Constraint Validation is now available for download.

  • The Plug-ins Pro Team 18-JAN-2022
    Rich Text Editor Pro

    Important notice regarding upgrading from 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 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. Learn more in REST URLs attributes help text. Using #OWNER_LOWER# results in showing error on page load.
    • 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 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.
    • In order to enable uploading images examine all implementations of the plug-in and set the new plug-in attribute Upload Image(s) on Request(s) on 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 have to 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 make sure dynamic actions implementing the action is listening to the plug-in event Froala Before Initialization.

    Froala framework

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

    General

    • Image resizing with the mouse is now enabled by default
    • Multibyte characters are now supported and don't raise an error when processing CLOB content
    • When application (or item) level attributes defining REST URLs are having different protocol than currently used in the browser, the plug-in forces the current protocol

    Image handling

    • Images now are uploaded only for defined page request(s) when a page is submitted. If images are not uploaded by the plug-in they remain in CLOB content as they were added (or loaded with CLOB) to the plug-in editor. For example, images added from 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 on downloading 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 documentation
    • Pasting content containing images from Microsoft Word or Google docs is now supported
    • Images added to the editor are using less data-* attributes to track images

    United Codes Rich Text Editor Pro (Item)

    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, 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 has 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 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.

    United Codes Rich Text Editor Pro (Extend)

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

    United Codes Rich Text Editor Pro (Process)

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

     

  • The Plug-ins Pro Team 05-MAY-2021
    UC List Extension
    • Added support for Interactive Grid
    • Added option on "Position button" to "Popup LOV (inline)"
    • Improved debug
    • Code aligned with UC code convention
  • The Plug-ins Pro Team 22-APR-2021
    Progress Bar Pro

    Initial release!  Progress Bar Pro is now available for download.

  • The Plug-ins Pro Team 16-APR-2021
    Client-side Validation Pro

    Client-side Validation Pro has been updated to support  validation subtypes.

  • The Plug-ins Pro Team 31-MAR-2021
    Guided Tour Pro

    Updated licensing mechanism.

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

  • The Plug-ins Pro Team 31-MAR-2021
    File & Image Uploader Pro

    Updated licensing mechanism.

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

  • The Plug-ins Pro Team 31-MAR-2021
    Interactive JET Charts Pro

    Updated licensing mechanism.

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

  • The Plug-ins Pro Team 31-MAR-2021
    Client-side Validation Pro

    Updated licensing mechanism.

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

  • The Plug-ins Pro Team 31-MAR-2021
    IG Checkbox Pro

    Updated licensing mechanism.

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

     
  • The Plug-ins Pro Team 31-MAR-2021
    IG File Download Pro

    Updated licensing mechanism.

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

  • The Plug-ins Pro Team 31-MAR-2021
    Rich Text Editor Pro

    Updated licensing mechanism.

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

  • The Plug-ins Pro Team 31-MAR-2021
    Gantt Chart Pro

    Updated licensing mechanism.

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

  • The Plug-ins Pro Team 03-MAR-2021
    Rich Text Editor Pro

    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 type 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 non-CLOB value from SQL Query it is required to use to_clob function within SQL Query. For example: "select to_clob(123) from dual"

    Fix for license creation to support Oracle Database 21c.

  • The Plug-ins Pro Team 19-FEB-2021
    UC List Extension

    Initial release! UC List Extension is now available for download.

  • The Plug-ins Pro Team 09-FEB-2021
    Guided Tour Pro

    Enhancements

    • Attributes - new application attributes added: "Popper Skidding" and "Popper Distance" configuring popper offset of a tour step cross application.
    • User Interface - when tour was not using "Add Masking", the step arrow was not visible. Step element shadow is increased to highlight the step arrow.
    • Sample application
      • A new "Tour Builder" page has been added. The tour builder enables developers to create table-based tours directly from the sample application.
      • "Examples \ Table-based tour" page has been updated.
    • Supporting Objects \ Packages - new package "UC_GUIDEDTOUR_API" has been added. The package contains functions/procedures to handle tables "UC_GUIDEDTOURS_STEPS" and "UC_GUIDEDTOURS_TOURS"

     Bug fixes

    • Plug-in JavaScript core - Fixed: table-based tours wasn't respecting flag "Fire on page load" set to "No". 
    • Pug-in attributes
      • Fixed: when table-based tour has no steps, the plug-in was raising unhandled error.
      • Removed invalid column "CUSTOM_BUTTONS" from the plug-in default value for attribute "SQL Query Returning Tour Steps".
      • Added missing column "DISPLAY_SEQUENCE" to the plug-in default value for attribute "SQL Query Returning Tour Steps".
      • Added missing column "INIT_JS" to the plug-in default value for attribute "SQL Query Returning Tour Steps".  
      • Attribute "Action \ Initialize Tour (Custom Table)" no longer raises an error on tour initialization.

    Other

    •   Supporting Objects \ Tables
      • table "UC_GUIDEDTOURS_STEPS" renamed to "UC_GUIDED_TOUR_SAMPLE_STEPS".
      • table "UC_GUIDEDTOURS_TOURS" renamed to "UC_GUIDED_TOUR_SAMPLE_TOURS".
      • table "UC_GUIDEDTOUR_DISALBED" renamed to "UC_GUIDEDTOUR_SAMPLE_DISABLED"
      • new table "UC_GUIDEDTOUR_STEPS" has been added. Table is used by the plug-in action "Initialize Tour (Table)".
      • new table "UC_GUIDEDTOUR_TOURS" has been added. Table is used by the plug-in action "Initialize Tour (Table)".
    • Supporting Objects \ Packages - package "UC_GUIDEDTOUR_SAMPLE_APP" has been changed in order to handle tables "UC_GUIDED_TOUR_SAMPLE_STEPS" and "UC_GUIDED_TOUR_SAMPLE_TOURS".
  • The Plug-ins Pro Team 04-FEB-2021
    Gantt Chart Pro

    Initial release!  Gantt Chart Pro is now available for download.

  • The Plug-ins Pro Team 01-FEB-2021
    Rich Text Editor Pro

    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 initialise plug-in if event "theme42ready" or "apexwindowresized" is not triggered.
    • Added "apex-session" for ORDS RESTful call header / allows to authenticate call on ORDS level
    • Refactored error handling for the process plug-in
    • When the process plug-in "load" actions executes and "no_data_found" is raised, the plug-in logs information on the PL/SQL level and sets the CLOB to null
  • The Plug-ins Pro Team 02-DEC-2020
    Rich Text Editor Pro

    The following fixes are included in 20.1.1:

    • Initialisation of RTE in a Modal window
    • Compatibility with Oracle DB 12c
  • The Plug-ins Pro Team 20-NOV-2020
    Rich Text Editor Pro

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

  • The Plug-ins Pro Team 14-SEP-2020
    IG Checkbox Pro
    The following fixes are included in 20.1.1:
    • Interactive Grids using rowid are now supported
    • The plug-in change event is now properly triggered for the active row and modified colum
    • The checkbox container now uses an additional attribute, data-column-name, to identify the column
    • Clicking on checkboxes in different rows is no longer displays the checkbox in the IG inline popup
  • The Plug-ins Pro Team 15-JUL-2020
    File & Image Uploader Pro

    Initial release!  Image Uploader Pro is now available for download.

  • The Plug-ins Pro Team 16-JUN-2020
    IG Checkbox Pro

    Initial release!  Interactive Grid Checkbox Pro is now available for download.

  • The Plug-ins Pro Team 16-JUN-2020
    IG File Download Pro

    Initial release!  Interactive Grid Download File Pro is now available for download.

  • The Plug-ins Pro Team 16-JUN-2020
    Client-side Validation Pro

    Initial release!  Client-side Validation Pro is now available for download.