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.
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 Oracle Linux 7 and CentOS7, … Read more
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
Disabling Apex items the right way
Sometimes you want to show data without the user being able to change it. The easiest way in Apex to use reports and read only items. There are use cases however for which this is not good enough.For example when you want to change from read only to editable item dynamically or vv. Or if … Read more
APEX: Validate user input – Riga Dev Days 2016
This 2016 presentation was also integraly put on youtube. Please watch the video, it still is relevant.
Google Apps integration in Oracle APEX – Riga Dev Days 2016
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 enjoy
making https (webservice) requests from PL/SQL without a wallet
While developing the application for my kscope15 presentation I discovered that my Oracle XE database is unable to handle the certificate for Linked-in. This has to do with the algorithm used to sign the Linked-in certificate. Oracle XE 11 has a bug that prevents it from handling the certificate correctly. The solution lies in creating … Read more
Calculate time difference between log-entries
For me, myself and I (as a reminder) 🙂 I needed to calculate the difference between a log entry and the previous log-entry to be able to investigate where performance was dropping: With alittle bit of help here and here I figured out how to do it:
Fully freeware APEX environment VII: Oracle HTTP server (configuration)
This is post 7 in the Fully Freeware APEX environment series. The post will cover the configuration of the Oracle HTTP server. Please mention, that I’m not fully aware about the license restrictions on the Oracle HTTP server. What I heard is that if you use it for an APEX installation and install it physically … Read more
Fully freeware APEX environment VI: Oracle HTTP server (installation)
This is post 6 in my series about a fully freeware APEX installation: Information has been taken from The Oracle Install guidelines http://eelzinga.wordpress.com/2009/07/04/oracle-fusion-middleware-11g-ofm11g-on-centos-5/ Shut down EPG The EPG is still running. To shut it down, open SQL*plus:conn conn system execute dbms_xdb.sethttpport(0); exit Prerequisits Make sure your system has enough memory (2 Gigs or more) We … Read more
You must be logged in to post a comment.