PL/SQL
A good example of PLSQL-OO
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 Read more…
APEX Database JoelKallmanDay
ORA-06502: When loading data in the APEX data-loader
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 Read more…
APEX
Consume Digest API with PLSQL
In my personal blog, I have created an digest authenticated API use nodejs. Only thing it does is to authenticate with digest and output a json string when you are authenticated. I made it so that I can consume it Read more…
APEX
Google Analytics: custom dimensions
Google Analytics allow developers to collect custom data (parameters) and create custom dimensions to make use custom data. In this blog, i will try to go through the steps of creating custom dimensions and make use of the custom dimensions. Read more…
APEX
Connect Google Analytics to your APEX application
prerequisite: Any APEX application you have access to Google Account Go to google analytics ( make sure you have google analytics enabled ) and then go to the following section of the admin page and click on Create Account Once Read more…
APEX OraCloud
Adding a login-message to your always free Oracle Cloud APEX instance
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 Read more…
Database OraCloud
OCI connections to multiple Autonomous Transaction Databases in the Oracle Always Free cloud
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 Read more…
APEX JavaScript PL/SQL
And that’s how the cookie crumbles
owa_cookie.send does not write the cookie to the browser because the “Reload on Submit” setting is not set at page level.
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.
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 Read more…