Switching your application theme is getting more and more popular in recent years. APEX apps and their users are no exception. Most of our devices support this feature, APEX itself introduced dark and light mode for the Application Builder too. I am going to show you a quick way of integrating it into your application. … Continue reading Auto switch Dark & Light modes of your APEX app
Category: Oracle APEX
Unlock APEX Admin account
It happens that you forget your master ADMIN password for the apex_admin page. Here are the two widely user methods to change it and unlock the Admin account: Use @apxchpwd.sql script in your APEX directory. To run it, navigate to the directory through bash or Command prompt. Connect to your database as SYS and run … Continue reading Unlock APEX Admin account
PLS-00907: Can not load library unit
It happens relatively rarely to have an error PLS-00907 (PLS-00907: Can not load library unit). We have encountered it few times in our APEX applications. Here is the way to resolve it (performed by a SYS user). Solution : Ask your DB admin to flush the shared pool 🙂
Print PDF reports with APEX 5.1 + ORDS
By default, if you use embedded PL/SQL gateway to run your APEX, PDF printing is not possible. There are several ways to make it possible. By configuring ORDS and running it in either Standalone mode or into Apache Tomcat / Glassfish / or other web server. This option is completely free and easy to setup. … Continue reading Print PDF reports with APEX 5.1 + ORDS