Opening an APEX Modal Dialog through a custom linkRecently I had the challenge of building a report and edit form in APEX based on a database table. Pretty standard in APEX, but in this case, there is some complicated logic which determines which rowAug 28, 2026·5 min read
A single query to decompose JSON using the APEX_JSON package, part 1Sometimes I want to examine in detail a JSON document that is stored in the database. I just want an overview of all the fields in the document, possibly with their values. The JSON document itself caApr 17, 2026·7 min read
Controlling access to ORDS RESTful ServicesIn this blog post I will explain how access control in ORDS REST services can be configured. I will discuss both module protection and pattern protection, and explain in which situations these should Apr 3, 2026·6 min read
Using Assertions to enforce Business RulesIn Oracle, we have long been accustomed to defining constraints at the table level in the database. These are enforced for us by the database. Until recently, this was not possible for constraints betMar 13, 2026·6 min read
The ORA-00604 error: one possible causeRecently I wanted to modify an existing view. I needed to add a few extra colums from another table. So the original view was something like create or replace view testview as select t1.id , t1.cFeb 27, 2026·2 min read
How to delete an Interactive Report subscriptionRecently one of our testers asked me to remove an Interactive Report subscription. He still received an email every week from an Interactive Report in one of our applications. But he didn’t know if it was the Development, Test or Acceptance environme...Oct 8, 2025·3 min read
Multiple Authentication Schemes with Deep LinkingIn Oracle APEX it is possible to use multiple Authentication Schemes for your application. Only one of them can be the current Authentication Scheme, but from the Login page you can link to another Authentication Scheme, for example Social Sign-in, u...Sep 24, 2025·2 min read
