APEXcl is available for macOS, Windows and Linux. The desktop client is free to download, but requires a license to use (you can get a 90 day trial for free).
Download the desktop client here: https://apexcl.wpengine.com/download/ and follow the steps of the installer.
Verify your installation
The APEXcl installer adds a new alias to your system that you can invoke from the command line. You can validate the version of APEXcl by typing:
$ apexcl --version 2.0.0
The latest version is currently 2.0.0
On-prem database scripts
If you plan to use APEXcl Cloud, skip the following section.
To use APEXcl On-prem, you will have to install a few objects on your database. If you have DBA privileges, APEXcl will ask for your credentials directly from your command line and will proceed to install the objects for you.
If you do not have SYSDBA privileges, you can provide the two following scripts to a DBA within your organization:
- Create the APEXcl schema on your database
/Applications/apexcl/database/YOUR_APEX_VERSION/install.sql(or the location you chose during installation)
C:\Program Files (x86)\apexcl\database\YOUR_APEX_VERSION\install.sql(or the location you chose during installation)
- Grant APEXcl to your APEX parsing schema.
/Applications/apexcl/database/YOUR_APEX_VERSION/grants.sql(or the location you chose during installation)
C:\Program Files (x86)\apexcl\database\YOUR_APEX_VERSION\grants.sql(or the location you chose during installation)
Run this against all APEX parsing schema that require access to APEXcl.
Make sure APEXcl is compatible with your version of APEX and your version of the Oracle database.
Compatible with Oracle Database: 12 or higher
Compatible with Oracle APEX: 5.1, 18.1, 18.2, 19.1, 19.2
Uninstalling the APEXcl client
macOS: Simply remove
Windows: Uninstall APEXcl in Windows Programs and features
If you used APEXcl On-premise, you may want to drop the APEXcl schema too, byu running the following command with SYSDBA privileges:
drop user APEXCL cascade;
where APEXCL is the name of the APEXCL schema
Allow macOS app
If you try installing APEXcl on macOS, it’s possible that your system will ask you for special permissions. You can allow APEXcl by opening "Security & Privacy" and open apexcl.pkg anyway.
Alternatively, you can simply right click on the APEXclSetup.pkg installer, and click open.
Installing on Linux
To install APEXcl on Linux, once you have the run file (apexcl-installer.run), head over to your terminal. The installer puts the installation files in
/usr/local/apexcl so the installer must be run as root. You don’t want to switch entirely into root before running the installer because the installer will set up an alias for the command
apexcl for convenience by adding a line into your bashrc file.
So, over in your terminal, run the following command:
sudo bash /path/to/apexcl-installer.run
If all goes well, you should see an output similar to the following: