Evolve with APEX

Oracle APEX Security PL/SQL APEX Custom Auth Settings, Decoded Why I Build this I was building an internal APEX app — strictly for people on our corporate network. The default authentication worked, but it had a few things that kept bothering me. Anyone with valid credentials could log in from anywhere. Sessions expired with a useless error page. There was no audit trail — no way to know who logged in, when, or from where. And passwords were stored in plain text, which I just couldn't leave alone. So I did what any developer does — I built it myself. Custom authentication, from scratch, in PL/SQL. Turned out to be one of the best learning experiences I've had with APEX. Here's exactly how I did it. Img 1 : Head to Shared Components → Authentication Schemes → Create, choose Custom as the Scheme Type, and plug in your function and procedure names. Quick note before we get into the code — the s...

Oracle 23ai Deep Dive JSON-Relational Duality Views in Oracle APEX The complete guide to bridging relational tables and JSON documents storing data efficiently, accessing it flexibly. 📋 Table of Contents What Are Duality Views? The Problem They Solve Prerequisites Practical Example: Emp-Dept App Configuring in Oracle APEX CRUD Operations via Duality Views Key Benefits Summary 1 What Are Duality Views? In one of my Oracle APEX projects, I had a requirement to expose relational data as JSON for integration with external systems. The application needed to support both database transactions and API-based data exchange, which made the design slightly complex. Initially, I considered building REST APIs with manual JSON construction using SQL functions. However, maintaining that logic became difficult as the data model evolved. That’s when I explored JSON-Relational Duality View...

Generate Custom PDFs in Oracle APEX with jsPDF A complete step-by-step guide to building a client-side PDF generator with profile image embedding and PL/SQL database persistence. 📄 Step-by-step guide Oracle APEX jsPDF Dynamic Actions PL/SQL JavaScript "Picture this: your Oracle APEX application is polished, your users love it — but when they ask for a downloadable report with a profile picture and custom styling, you realize vanilla APEX isn't built for that out of the box. What if a single JavaScript library and one Dynamic Action could change everything?" Welcome to the world of jsPDF inside Oracle APEX . In this tutorial, we wire up a PDF generator that captures a user's name, email, phone number, and profile picture — renders them into a beautiful PDF layout — and saves everything to Oracle, all in one button click. ⓘ What you'll build: A dynamic PDF generat...

Oracle APEX PL/SQL Authentication One app. Two servers. Zero hardcoded auth logic. Dasshini Ravi  ·  April 16, 2026 The Authentication Configuration Procedure is the most underused feature in Oracle APEX. Here's how to use it to run one codebase across environments with completely different auth schemes — automatically. I once maintained two copies of the same APEX application — one for testing with custom PL/SQL auth, one for production with LDAP. Every bug fix, every UI tweak, every feature had to be applied twice. It was the kind of thing you accept as normal until someone shows you there's a better way. The better way is the Authentication Configuration Procedure — a PL/SQL hook that fires before the user even sees the login page, letting you switch auth schemes at runtime based on any data you want. No manual switching. No duplicate apps. What actually happens at session start When a n...