Installation

Installation package

1. region_type_plugin_unitedcodes_apex_sankey_chart.sql - the plug-in installation file for Oracle APEX 19.2 or higher

2. ddl_uc_sankey_manual_install.sql - the database objects required to support the plug-in

Install procedure

To successfully install/update the plug-in, follow these steps:

1. Import the APEX plug-in region_type_plugin_unitedcodes_apex_sankey_chart.sql into your application.

2. Run ddl_uc_sankey_manual_install.sql in SQL Workshop > SQL Scripts > Upload and Run

3. Run one of the following scripts (depending on your access to the internet) in SQL Workshop > SQL Commands or Command Line SQL to activate the license:

   • Option 1: When you have access to the internet

   set serveroutput on
   
   --
   -- You can find the PLUGIN_NAME and YOUR_API_KEY in your Plug-ins Pro dashboard
   --
   
   -- when having access to the internet
   -- create a license automatically
   begin
   uc_pluginspro.auto_license(
       p_plugin  => 'PLUGIN_NAME',
       p_api_key => 'YOUR_API_KEY');
   end;
   /

   • Option 2: When there is no access to the internet

   set serveroutput on
   
   -- when there's no access to the internet
   -- create a license manually
   
   -- Step 1: Run the following statement. Then, follow the resulting
   --         instructions before moving on to Step 2.
   begin
   uc_pluginspro.manual_license(
       p_plugin      => 'PLUGIN_NAME',
       p_api_key     => 'YOUR_API_KEY');
   end;
   /
   
   -- Step 2: The above statement will return your ACTIVATION KEY, which you will need to
   --         enter in your plug-ins-pro.com portal (Select the plug-in you
   --         are activating, then click the Generate License button) to
   --         retrieve your license key.
   --         When you have your license key, run the statement below.
   begin
   uc_pluginspro.manual_license(
       p_plugin      => 'PLUGIN_NAME',
       p_api_key     => 'YOUR_API_KEY',
       p_license_key => 'YOUR_LICENSE_KEY');
   end;
   /

4. Add United Codes Sankey Chart Pro [Plug-In] region on page.

5. Define database Source and set Attributes (see examples below for more details)

6. Save changes. United Codes Sankey Chart Pro [Plug-In] is now ready to use.