Categoria: APEX
-
When one login method is not enough
In the first version of this case, I deliberately kept things focused. The goal was to prove that a user could come in through Google, complete a minimal onboarding flow, receive ORDS client credentials, and actually use those credentials against a protected endpoint. That loop, once it closes, already carries a lot of value, and
-
From Social Login to API Access: Building a Self-Service OAuth Client Flow with APEX and ORDS
In APEX, the usual paths are familiar: workspace users, database accounts, or some internal authentication model we control ourselves. But APEX also gives us Social Sign-In, and that changes the tone of the application completely. There are several ways to do that depending on the provider, but in this case I am using Google because
-
Beyond Hidden Items: Passing State Across APEX Page Processes
By Dênio Flávio Garcia da Silva I’ve spent a lot of time auditing APEX environments, and nothing sinalizes a maintenance nightmare quite like the “Hidden Item Explosion.” We’ve all been there: a simple form grows, logic accumulates, and suddenly you’re juggling dozens of values across multiple processes. It works, sure, but would you trust your future self
-
Instrumenting PL/SQL in Oracle APEX: A Practical Case Using APEX_DEBUG
By Dênio Flávio Garcia da Silva There was a moment in my journey with Oracle APEX when I started working on larger enterprise applications and realized that the page itself was often the simplest part of the whole system. The UI looked clean and straightforward, but behind a single button there were packages with hundreds
-
Oracle APEX Background Processing with Execution Chains (Live Progress Monitor Demo)
In this video, I built and recorded a practical Oracle APEX demo showing how to handle long-running tasks without freezing the UI. The app starts a background Execution Chain (Init → Process → Finalize), returns control to the user immediately, and displays live progress on a Monitor page (status, “X of Y”, messages, and item-level
-
Securing ORDS Endpoints with OAuth2
In this article, I demonstrate how to secure ORDS REST endpoints using OAuth2 Client Credentials within Oracle APEX running on Autonomous Database (OCI). The post walks through creating roles and privileges via the APEX RESTful Services interface, configuring an OAuth client using SQL Workshop, and validating the full authentication flow using Postman. This example highlights…
-
Refreshing Multiple Oracle APEX Regions with a Single Dynamic Action Using jQuery Selectors
In this video, I demonstrate a practical Oracle APEX dashboard pattern that uses a single Dynamic Action combined with a jQuery selector to refresh multiple regions at once. The demonstration starts with a simple page containing filters and one report region refreshed by a button. As the page evolves into a real dashboard with multiple