APEX

Embed images in the email when sending it from the Oracle APEX Application

When using Oracle APEX hosted externally, such as on Oracle Cloud, if your application includes sending an email notification with embedded images from linked images, the image may look broken, as seen below. Based on the warning message, the embedded image’s host, which the email is referring to, is not on the safe list. Obviously, …

Embed images in the email when sending it from the Oracle APEX Application Read More »

Install APEX’s Sample Packaged Application by Importing its SQL Script

If for some reason, you could not install the APEX sample packaged application via Application Builder > Packaged Applications interface, you have an option of installing it by importing the SQL script (fxxxx.sql). In my case, when installing via the Packaged Applications interface, I got the following error: While working with DBA and Oracle support …

Install APEX’s Sample Packaged Application by Importing its SQL Script Read More »

The Developer Toolbar in APEX Application Disappeared

If the Developer Toolbar (shown below) in your Oracle APEX application is not displayed, you can control its display by changing the Status attribute on the application’s Edit Definition page. I’ve learned about this when somehow one of our applications suddenly did not display the Developer Toolbar. We found out later that during environment refresh, …

The Developer Toolbar in APEX Application Disappeared Read More »

File Browser in APEX 4 with BLOB column specified in item source attribute

In APEX 4, we now have the option to place where the uploaded file will be stored within the development workspace interface. The Storage Type setting of the File Browser item has two options: Table WWV_FLOW_FILES stores the uploaded file in the table wwv_flow_files (or APEX_APPLICATION_FILES).  This is the default way in the previous versions …

File Browser in APEX 4 with BLOB column specified in item source attribute Read More »

Upgrade APEX to 4.0.1 encounters “ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists”

Few weeks back, we’ve upgraded multiple APEX installations (development, test and production) to new version 4.0.1 from the default version 3.0.1.00.12 in Oracle 11g R1. The upgrade (just running the apexins.sql) went well for all except one. We got a strange error during the last stage of installation. Performing Application Express component validation – please …

Upgrade APEX to 4.0.1 encounters “ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists” Read More »

Oracle Application Express (APEX) Certification Exam

Oracle is working toward having the first certification exam for Oracle APEX. This “Oracle Application Express Developer Certified Expert” pilot program is intended for intermediate and advanced APEX developers. You will have to indicate the relevant APEX trainings you’ve completed, years of APEX experiences and, of course, the agreement to provide feedback in order to …

Oracle Application Express (APEX) Certification Exam Read More »

Scroll to Top