15 October 2025

Creating a Google XML Sitemap using Oracle APEX. #JoelKallmanDay

›
Oracle APEX makes it easy to build modern web apps, but ensuring that your public pages are properly indexed by Google sometimes requires a ...
1 comment:
17 August 2025

Oracle APEX: How Application and Page Processes really execute at the same process point

›
Debugging a legacy application recently gave us a deeper understanding of the order in which Oracle Application Express executes Appl...
11 August 2025

Using PL/SQL to Seed and Publish Oracle APEX application translations

›
For multilingual applications, it can become a little tiresome to constantly have to reseed and republish your application while testing ...
4 comments:
04 June 2024

Reading and writing files on Amazon S3 from Oracle Autonomous Database and PL/SQL

›
In our mixed cloud environment of AWS and Oracle Autonomous databases, sometimes it's necessary to move files/blobs between the database...
19 August 2022

Correctly sorting data containing accented characters (a.k.a. the Côte d'Ivoire and Türkiye issue)

›
This will be short and sweet. Hopefully it will be useful to some of you. As you may or may not know, the country formerly known as ...
19 November 2021

How I got SQL Developer working on a new MacBook Pro (MacOS Monterey - M1 Pro)

›
Note: See updates 2021-11-23, 2022-02-17 and 2022-06-29 below concerning the use of GraalVM's JDK as an alternative to JDK 17. This is ...
4 comments:
30 August 2021

Autonomous DB "You have exceeded the maximum number of web service requests per workspace"

›
We recently had an experience on an Oracle Autonomous Database where our production instance started giving us lots of errors saying: ORA-20...
23 January 2021

Making XML tags dynamic in SQL and PL/SQL

›
While trying to produce XML using Oracle's native XML functions, I needed some of the XML tags to be dynamic.  To simplify and illustrat...