APEX + AI patterns, components, and integrations for modern apps.
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
Email functionality is vital for many Oracle APEX applications, whether it’s sending notifications, confirmations, or updates to users. Deployments on an Autonomous Database (ADB), have by default added layers of security that make adoption and migration a bit challenging. Oracle documents the key differences, constraints inherent to Autonomous Database for experienced Oracle Database users. The
Configuring Email in OracleAPEX on an AutonomousDatabase (ADB) Read More »
Oracle APEX 24.1 has introduced an exciting new feature: the APEX Assistant, which leverages OpenAI’s large language model to help developers generate code and receive intelligent suggestions during app development. In this article, I’ll walk you through the steps to set up your OpenAI credentials in Oracle APEX and enable the AI Assistant for your
Unlock the Power of AI in Oracle APEX 24.1: Set Up OpenAI Credentials for APEX Assistant Read More »
