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 Callbacks, and dynamic manipulation of the Document Object Model (DOM). These features enhance user experience, improve performance, and enable the [...]
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. The PR_LOAD_MESSAGES procedure initializes the conversation by retrieving system messages, structuring collections, and handling errors. Messages are displayed dynamically using [...]
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 memory, function calling, and multi-step reasoning. This new paradigm allows for more sophisticated and context-aware AI-driven assistants that can work [...]
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 mechanism that remains active throughout a user's session. Rather than immediately writing data to a database table, collections allow us [...]
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 attacks. In this article, we explore advanced techniques to prevent SQL injection attacks in APEX, going beyond basic measures like [...]
