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.
Events
SIOUG 2018
October 15 – 16, 2018 Portoroz, Slovenia The MakeIT18 conference will be held on October 15 and 16, 2018 at Portus Portus in Portorož, Slovenia. We expect over 300 participants. View Details
Database
Make tomcat wait until oracle database is available
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 http://myserver:8080/ords/ gave me the expected APEX login screen. However since Read more…
APEX Automation JavaScript
Automating APEX using Node.js and Puppeteer
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 just inspect how the browser renders an URL, you can Read more…
Database
The request could not be mapped to any database
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, Richard