1. Upload the files to the Static Application or Workspace files
2. Load these files on application or page level (I will do it page level)
- Go to Shared Components/Plug-ins and click on create, and then create from scratch.
- Choose a name and internal name. The internal name is used internally by APEX for identifying the plug-in, it is not displayed.
- Choose the item type, it is where this plugin will be used.
Now, you must define a PL/SQL anonymous block that contains a function for rendering, validating, execution and Ajax callbacks for the plug-in. This can also be stored in the database.
4. Now we set the name of render function
5. Supported for: We must define where the plugin is supported, where it is available in the Builder, Page Items and/or Interactive Grid Columns. Also if the plug-in is displayed in the Builder as a supported component for desktop and/or mobile.
6. Standard Attributes: For Item type plug-ins, identify the attributes that apply to this plug-in:
7. Now we must save, so APEX will identify the plugin type and add some plugin options, we must create the format mask custom attribute.
Finally, we can save and use the plugin. Just create a page item and change the item type to the plugin that we just created.
Rodrigo is an Oracle ACE and APEX Developer Expert certified by Oracle and is an experienced software engineer with emphasis in analysis, design and development of bespoke Oracle applications utilising development tools such as PL/SQL, APEX and Forms for a variety of international businesses. Rodrigo speaks regularly at Oracle community events and enjoys creating APEX plugins and writing blogs.