APEX + AI patterns, components, and integrations for modern apps.
How I connected Oracle APEX to a FastAPI backend powered by Oracle Agent Memory, Autonomous Database and OCI Generative AI, building an enterprise-style memory console with Add Memory, Search, Chat Workspace, Models and Project 360. 3.0 Introduction: why bring Agent Memory into APEX? In the first article of this series, I explained the overall architecture of […]
How I extended an Oracle Agent Memory exploration into a working workspace with FastAPI, React, Oracle APEX, Autonomous Database, OCI Generative AI, Codex, ChatGPT Enterprise and Visual Studio Code. 1.0 Introduction AI agents are quickly moving beyond simple chat interfaces. They can call tools, reason over documents, generate code, interact with APIs, orchestrate workflows and
Building an Oracle Agent Memory Workspace — Part 1/3: From inspiration to Architecture Read More »
In the past weeks I’ve been working on an Oncology Forecasting prototype built with Oracle APEX + Autonomous Database (ADB). The goal is straightforward (but very powerful): let business users define a scenario (country, indication, time horizon, epidemiology assumptions, products…), run the forecast, and then explore the results. The real challenge is not only computing
📎 Read Part 1 First:If you haven’t seen the first part where we trained and deployed a machine learning model using OCI Data Science, start here:👉 Part 1: Train and Deploy ML Model in OCI Data Science Introduction Welcome back! In Part 1, we trained a RandomForestClassifier using the Iris dataset, deployed it in OCI
Introduction Welcome to this comprehensive guide on building an Oracle APEX application that integrates with OCI Data Science to make real-time predictions using a machine learning model. This guide is divided into two parts: What you’ll learn in Part 1 In this first part, we will go step by step through: Why you should stay
Workflows are essential in modern applications to streamline processes, ensure consistency, and automate repetitive tasks. Oracle APEX provides a robust workflow engine that allows developers to automate approvals and rejections efficiently. Despite the abundance of blogs and documentation available, many resources often miss crucial steps, such as ensuring a workflow exists both in the development
Automating Approvals with Workflows in Oracle APEX Read More »
Integrating Oracle APEX with Oracle Object Storage is a fundamental step toward creating robust applications for managing data workflows and preparing for advanced data science services. In this article, I will outline the configuration steps and necessary code to visualize and upload files to Object Storage buckets directly from an APEX application. This setup lays
In Oracle APEX, REST API calls can be performed using either Shared Components (Web Source Modules) or through PL/SQL processes. While Shared Components provide simplicity and built-in tools, sometimes you need greater control over the request, response, and processing logic. In this article, I’ll show you how to perform REST API calls using pure PL/SQL
Performing REST API Calls in Oracle APEX with PL/SQL Code Read More »
APEX is an incredibly versatile platform for building low-code applications, but one feature that really elevates its capabilities is the ability to generate professional-quality reports and documents. While APEX provides some built-in reporting tools, integrating it with APEX Office Print (AOP) takes things to a whole new level, especially for creating customizable Word, PDF, and
Creating Reports and Documents with APEX Office Print in Oracle APEX Read More »
As a developer working with Oracle APEX, staying updated with the latest features and enhancements is crucial for building scalable and secure applications. While tools like ChatGPT have become invaluable for coding assistance, I’ve often found that its knowledge of specific technologies can lag behind the latest updates. This is particularly true when new versions
