April 2025
Advanced Use of AJAX Callbacks in Oracle APEX
Introduction Advanced Dynamic Actions in Oracle APEX extend beyond basic user interactions like showing or hiding fields, enabling or disabling components, or submitting forms. They support executing custom JavaScript code, asynchronous server-side processing using AJAX [...]
Oracle APEX and OpenAI Walk Into a Bar… And Build an Assistant – Part 2
Building on our previous discussion about integrating OpenAI Assistants with Oracle APEX, this article focuses on structuring and displaying user interactions efficiently. Instead of frequent database queries, APEX collections provide session-based storage for optimized performance. [...]
Oracle APEX and OpenAI Walk Into a Bar… And Build an Assistant – Part 1
Previously, we explored the OpenAI API's completion models, which enabled text generation and language-based automation. Now, we are shifting our focus to OpenAI's new Assistant API, a more structured approach that enhances interactions by integrating [...]
Oracle APEX Collections: Efficiently Managing Temporary Data
Introduction In Oracle APEX, there are situations where we need to manage temporary data before deciding whether to store it permanently. APEX Collections provides an efficient way to handle this by offering an in-memory storage [...]
How to Prevent SQL Injection Attacks in APEX (Beyond the Basics)
SQL injection remains one of the most exploited vulnerabilities in web applications, and Oracle APEX is no exception. Despite APEX’s built-in protections, poor use of dynamic PL/SQL and configuration mistakes can expose your application to [...]
March 2025
Building an Oracle APEX Plugin: A Deep Dive, part 3
Now we need to move on to the JavaScript portion, which forms the core of our proposal: replacing the item's default validation with a fully customized solution tailored to our specific requirements. This step is [...]