Flows for APEX minimal requirements are:
- Oracle database: 12.2 or higher
- Oracle APEX: 20.1 or higher
Installation with the packaged application
- Download the latest version of the packaged app here.
- Log in into your Oracle APEX workspace and click on the “Import” cards.
- On the import page, choose the previously downloaded SQL file, make sure that the option “Database Application, Page or Component Export” is selected and click on the “Next” button. A new page should confirm that the file have been correctly imported. Click on the “Next” button.
- The next wizard page is a summary of the installation that will be done. Make sure the selected options are correct and click on “Install Application”.
- After installation, you will be asked if you want to install the Supporting Objects. Enable the switch and click on “Next”. A confirmation page will be loaded, confirm the installation by clicking on the “Install” button.
- After installation, you can click on the “Run Application” button to log into the Flows for APEX application and start building flows.
Installation with SQLcl
For Windows users, please make sure to set NLS_LANG value correctly by running
set NLS_LANG=AMERICAN_AMERICA.UTF8 before using SQLcl.
- Get the full distribution content by cloning the repository or downloading the release source code: zip or tar.gz.
- Connect to you Oracle schema with SQLcl, make sure you are located into the distribution folder.
- Run the installation script, it will create the database objects and import the application.
- Provide the Workspace Name, Parsing Schema, Application Alias and Application Name.
>> Please enter needed Variables Enter Workspace Name: [FLOWS4APEX] FLOWS4APEX Enter Parsing Schema: [FLOWS4APEX] FLOWS4APEX Enter Application Alias: [FLOWS4APEX] FLOWS4APEX Enter Application Name: [Flows for APEX] Flows for APEX
- At the end of the installation, you should see the confirmation that the product have been correctly installed. You can connect to your Oracle APEX builder and run the Flows for APEX application.
>> Finished Installation of Flows4APEX >> ====================================
Additional step to use timers
Grant create job
Your schema need to have the privilege “create job” to use the timers feature of Flows for APEX. As SYS, you have to run the following command:
grant create job to <my_workspace_schema>;
Create timers job
We provide a SQL script in the distribution to enable the timer feature. Run enable_timers.sql (app_dist/Applications/Enable_Timers) in your schema with SQLcl or using the SQL Workshop in the APEX builder.