I am a PL/SQL nerd. I love the language and what you can do with it. I consider myself a PL/SQL programmer first and only secondarily an APEX developer. For quite some time now I am highly in favour of using Object-Oriented techniques within packages but have difficulties convincing others Read more…
My contribution to this years contribution to #JoelKallmanDay Recently I created a data-load within APEX to load about 3500 lines of excel-sheet into a temporary table. I created the table for receiving the data using the Data Workshop, as shown in the image. I now had a neat little table Read more…
I used Dimitri’s great blog on how to get started on the Oracle Always Free cloud and APEX. Great work Dimitri.. Thanks for this. We’re used to add a login-message to our instances, so we can easily see on what instance we’re logging in. Alas.. The Oracle Always Free instances Read more…
I still use PL/SQL developer to work in our Oracle Databases. It is a tool I’ve been using for years and old habits seldom die.. In fact Pl/SQL developer is the only sound reason I have parallels desktop installed on my Mac. 🙂 PL/SQL developer connects to the database using Read more…
A good tradition needs follow up, last year we were not able to fullfill our promise, this year we’ll do better.
It was March 2018 when Jasper Alblas and Frans Jacobs introduced me to a real nice way of explaining the advantages of Kanban within a Scrum environment. In the Agile world, Kanban and Scrum have been seen as separate frameworks / practices, but as we all know Scrum teams actually Read more…
owa_cookie.send does not write the cookie to the browser because the “Reload on Submit” setting is not set at page level.
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 http://myserver:8080/ords/ gave me the expected APEX login screen. However since 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, Richard