llms.txt
Cloud Nueva | Jon Dixon
Practical tutorials and project experience covering Oracle APEX, AI agents, Oracle REST Data Services (ORDS), SQL, PL/SQL, Oracle Cloud Infrastructure (OCI), and enterprise integrations.
Cloud Nueva is Jon Dixon's technical blog for developers building applications and integrations with Oracle technologies. Articles include implementation walkthroughs, code examples, architecture discussions, and lessons from client projects.
Use the topic index to discover additional articles and the archive to find recent posts. This file is a curated starting point. Article examples and recommendations reflect the product versions and publication or update dates stated in each post.
Most article links below point to the site's Markdown versions. Remove the final .md to open the corresponding HTML article if needed. Some links use HTML directly.
Site navigation
- Blog home: Latest articles.
- Blog index: Articles organized by subject, with suggested starting points.
- About Jon: Author background, technology focus, and contact information.
AI and APEX AI agents
- Adding an AI Agent to an Existing APEX App: Agent architecture using existing PL/SQL APIs, orchestration, validation, approvals, and logging.
- APEX AI Agents: Comparing Cost, Quality, and Models: Measured agent workloads comparing model behavior, token usage, execution time, and estimated costs.
- Using an APEX AI Agent to Turn Purchase Orders into JSON: Extracting structured purchase-order data with an APEX AI agent.
- APEX AI Agent Handlers: Intercepting & Updating Requests and Responses: Customizing agent exchanges through request and response handlers.
- 23ai Vector Search & RAG: Building retrieval-augmented generation with Oracle Database vector capabilities and APEX.
- APEX AI Interactive Reports Just Got More Interesting: APEX 26.2 computed columns generated through AI and their use in business analysis.
APEX application development
- APEX_WEB_SERVICE The Definitive Guide: Calling web services from PL/SQL with the APEX_WEB_SERVICE API.
- APEX Background Page Processing - The Definitive Guide: Moving page processing into the background for longer-running operations.
- Easy file Parsing with the APEX_DATA_PARSER API: Reading XLSX, CSV, JSON, and XML files with APEX_DATA_PARSER.
- How To Handle Advanced APEX Form & IG CRUD Operations Like a Pro: Sharing packaged PL/SQL business logic across forms, Interactive Grids, and REST services.
- Save an APEX Interactive Grid Before Opening a Modal: Completing cell edits and waiting for a successful grid save before opening a child-record dialog.
- The anatomy of an APEX 26.1 APEXlang file: Understanding .apx files, application folders, component references, and embedded code.
Security and credentials
- Protect APEX URLs with Session State Protection: Protecting application URLs and session state with APEX security settings.
- Secure your Secrets with APEX Web Credentials: Managing credentials used by APEX integrations.
ORDS and REST APIs
- Best Practices for Building ORDS PL/SQL-Based REST APIs: Design and implementation practices for REST endpoints backed by PL/SQL.
- Building Performant REST Services with Oracle REST Data Services: Improving the performance of ORDS services.
SQL and PL/SQL
- JSON Parsing in Oracle SQL and PL/SQL: Worked examples for reading JSON in SQL and PL/SQL.
OCI and cloud services
- Secure APEX Access to OCI Object Storage: Configuring authenticated access from APEX to OCI Object Storage.
- Setting up and Using the OCI Queue Service from APEX: Configuring queues and exchanging messages from APEX.
Enterprise integrations
- Building Integrations with the Oracle DB APEX & ORDS - Part 1: Beginning an integration series with retrieval of data from remote REST services.
- Using APEX Workflow for Enterprise Integration Orchestration: Coordinating integration steps with APEX Workflow.
- Consuming Fusion ERP Data with BI Publisher & APEX: Calling Fusion ERP BI Publisher reports and consuming their results in APEX.
- Managing Fusion Cloud ERP Data from APEX with No Code: Using declarative APEX capabilities to work with Fusion ERP data.
Optional
- Dynamic Actions series: Short commentary on APEX, AI, and technology.
- Archive: Browse posts by publication date.
- RSS feed: Feed for discovering newly published articles.
- XML sitemap: Additional URL discovery.

