Writing / topic
Oracle APEX & Database
Hands-on Oracle APEX, PL/SQL and Oracle Database. The thing I have written about since 2006.
Subscribe to this topic only (RSS)
- How we monitor our Oracle APEX servers with AI
For weeks I asked an AI every morning "how are the servers doing?", now it checks on its own. How it works together with AHF and APEX Project Eye, the real problems it found, and what I learned about letting AI look after your servers.
- A health check for our Oracle Database server with AHF
After our upgrade to 26ai I installed Oracle's Autonomous Health Framework (AHF) on our database server. How we installed it, what ORAchk found (memory, a single controlfile, core dumps), what we fixed, what we left alone, and how we monitor from now on.
- Upgrading our Oracle Database from 19c to 26ai
Last weekend we moved our production database from 19c to Oracle AI Database 26ai with AutoUpgrade. It's faster, and I recommend you do it too, but plan well: here are the gotchas we hit, from removed packages to the SQL transpiler and a Stripe certificate.
- Keep your Oracle APEX up-to-date in the AI era
The October 2026 Critical Patch Update fixes a 9.8 Oracle APEX vulnerability that needs no login. With AI finding bugs and writing exploits in minutes, staying current is the only real defense. How to check your versions and which patch level you need.
- Upgrade APEX 24.1 app to APEX 26.1
Moving forward building Oracle APEX applications, you want to make sure your apps are compatible with APEXlang.
- Oracle Database 26ai Assertions in a World Cup Betting App
Recently I was playing again with my World Cup betting application, originally built in 2006 with Oracle APEX. Yes… almost 20 years ago already!
- Oracle APEX 25.1 and beyond
Why there is no Oracle APEX 25.1 yet, and what Oracle showed at Kscope about the next release: APEXlang, AI-generated apps, AI in Interactive Reports, a new Advisor and features for large teams.
- Making File Upload required in Oracle APEX
Making the File Upload a required field is difficult with Oracle APEX 24.1 or earlier. In this post, I will show you the solution I use until Oracle APEX's native behavior improves.
- ORDS - SQL Developer Web: Fix Invalid credentials
I had a weird issue with some Oracle database users I wanted to connect to in SQL Developer Web.
- A story about Joel and APEX Office Print (AOP) #JoelKallmanDay
Since this is the special Joel Kallman day, I thought to share a story about how document generation with AOP started at Oracle's internal APEX environment.
- Compare 2 Oracle APEX pages
I wanted to know if a page was the same within the same application. Two (+1 in Oracle APEX 22.1+) features in Oracle APEX help to compare pages, which you find under the tools menu: Checksum and…
- The application alias "X" can not be converted to a unique application ID.
You get this error when two or more Oracle APEX applications have the same alias.
- Oracle APEX: the Power of the Activity Logs
Have you ever had those moments when an end-user calls you out of the blue with a disturbing message about your app?
- Fix for ORDS connection pool named |default|lo| is not able to proxy to the schema
Today on our server running ORDS 22.4 and Oracle APEX 22.2 we had a weird error: The database user for the connection pool named |default|lo|, is not able to proxy to the schema named ET_DEV.
- Restarting to blog
At the beginning of the year, I tend to reflect on the last year(s). When looking back this year I realized that in the last 15 years things changed in the amount I blogged.
Plus ~840 older Oracle APEX posts in the 2006–2022 archive. Not sure where to begin? Start here.