APEX PL/SQL
On APEX LOV’s and how to define their queries
The goal in defining LOV queries is to have them stored in a compiled way, having the benefit of database dependencies and making use of the SQL optimizer.
The goal in defining LOV queries is to have them stored in a compiled way, having the benefit of database dependencies and making use of the SQL optimizer.
Recently I’ve been installing the OATOA (Oracle APEX on Tomcat with ORDS behind Apache) stack a number of times on both Oracle Linux 7 and CentOS7. In the past this was no problem, Tomcat came up and a request to Read more…
Did you know that Chrome now ships with the feature Headless Chrome it is a tool for automated testing. For example, you may want to run some tests against a real web page, create a PDF of a page, or Read more…
Today I figured out to my shame that the mentioned error by ORDS 3 has a really, REALLY simple cause… the password was expired. Logging in (using SQL-plus) revealed this elegantly: The second one of course did the trick. Regards, Read more…
This 2016 presentation was also integraly put on youtube. Please watch the video, it still is relevant.
I did this presentation on how to integrate Google Apps in APEX throughout Europe (Netherlands, United Kingdom, Slovenia, Croatia, Latvia, Germany) and even at kScope (Miami). The guys at Riga DEV days (Latvia) made a complete video for you to Read more…