Instead of 17 tool calls, the LLM writes one small JavaScript program that calls them in a loop. 31.7k tokens → 4.3k. It runs inside the Oracle DB sandboxed via MLE. How I built that for UC AI: hartenfeller.dev/blog/program... #orclAPEX #ai

Programmatic Tool Calling in the Oracle Database with MLE JavaScript

Letting an LLM write one small program that calls your tools in a loop beats round-tripping every call through the model. Here is how I built that for UC AI with Oracle MLE, and why the sandbox was th...

hartenfeller.dev

Currently investigating if Programmatic tool calling (PTC) is feasable in Oracle via UC AI. PTC: LLM does not just call tools, it can write code that calls many tools and processes the responses. Great for big data. Maybe the perfect opportunity to get my hands dirty in MLE.

Die spannendsten Oracle-26ai-Features stecken tief im Maschinenraum. Priorisierte Transaktionen, PDBs als Cluster-Resource, sperrfreie Spalten: kleine Häppchen mit großer Wirkung für den DBA-Alltag. Neue Folge „O wie Datenbank" 🧵👇 (1/8)

Many high risk vulnerabilities in the Oracle Database ( 19.3-19.31, 21.3-21.22, 23.4.0-23.26.2). It's patching time...

Dynamic actions are one of the rare things where I feel they could get in the way of coding agents. Execution point is good but a single JS block calling set values, hides, refreshes etc. is probably much easier to maintain for LLMs (and easier to read for me in .apx) #orclAPEX

I love having local #orclAPEX (with 26ai and ORDS). Get yours running in minutes: youtu.be/PdjUIiiaQhw

Run local Oracle APEX (with 26ai and ORDS) in minutes

YouTube video by United Codes

youtu.be

Hot take/opinionated: With the help of AI, creating SQL migration scripts is as easy as ever: claude check the commit history since last tag, create a migration script, test it with a local DB. I don't need Liquibase, SQLcl Projects, etc. (Only works if you work file based)

Coding agents write a lot of PL/SQL, but is it good PL/SQL? I wrote up how I hand #dbLinter 's CLI to Claude Code and make a clean lint report part of "done". Stay in control in the age of AI-generated code. 👇 #orclAPEX hartenfeller.dev/blog/dblinte...

Letting Coding Agents Lint Their Own PL/SQL with dbLinter

Coding agents write plenty of PL/SQL, but they need a feedback loop to write it well. Here's how to hand dbLinter to Coding Agents and teach it to check its own work.

hartenfeller.dev

ORDS 26.2 is now available in uc-local-apex-dev (local DB + ORDS + APEX with just one script). #orclAPEX github.com/United-Codes...

With the new WITH WITH, you can do more WITH every WITH than you ever did WITH WITHout WITH ... or something like that :-) connor-mcdonald.com/2026/07/01/w...

WITH clause gets a 26ai boost!

By way of background, a while back I did video called “My New Favourite Join” on the LATERAL clause. The reason I like it is that it lets you solve a problem by composing little pieces …

connor-mcdonald.com

How the new JOIN TO ONE syntax extension of Oracle 26ai works with enabled and disabled constraints. Read my newest blog post: danischnider.wordpress.com/2026/06/30/j...

JOIN TO ONE and Constraints

The new JOIN TO ONE syntax extension seems to be very useful for queries on star schemas. But before we can use it, we have to prove how they can be combined with different types of constraint defi…

danischnider.wordpress.com

Wrong subreddit 😅😅

😂😂 youtu.be/5KyfW79Ld4g

Interview with a DBA (Database Administrator)

YouTube video by Kai Lentit

youtu.be

My local DB (uc-local-apex-dev) was running full. Improved the local-26ai.sh shrink-space script by: - removing old APEX installations - Reclaiming space from APEX internal BLOBs - Reclaiming space from audit log - Data file resizing In total reclaimed 6 GB 👍. #orclAPEX

Astro 7 is here! A new Rust compiler, a new Rust Markdown/MDX processor, Vite 8 and more. Get ready for 60%+ faster builds. astro.build/blog/astro-7/

Astro 7.0 | Astro

Astro 7.0 brings faster builds with Vite 8, a new Rust compiler, Advanced Routing, background dev server support, and structured logging.

astro.build

Release v26.3 of uc-local-apex-dev is out! 🎉 Get your local Oracle, ORDS, & APEX 26.1 stack in just 1 command. This release upgrades you to DB 23.26.2 featuring Oracle Deep Data Security. Release details: github.com/United-Codes... #orclAPEX #OracleDatabase

Release v26.3: DB 23.26.2.0 · United-Codes/uc-local-apex-dev

What's Changed (since first 26.2 release) Migration guide DB 23.26.1.0 → 23.26.2.0 (DB files are compatible — the database upgrades in place, no dump/restore needed) ORDS 26.1.0 → 26.1.2 New scrip...

github.com

Dimitri lighting a bonfire for the #orclAPEX community @dgielis.com

How to do Real Time communication in #orclAPEX. Kevin Thysen and Vito Van Hecke at #Kscope26

Submitted 3 abstracts for DOAG K+A in November in Nuremberg. Fingers crossed! Hope to see many people in the #orclAPEX community so you should submit some too or at least come :) @DOAGeV #DOAG

If you missed our webinar on how to improve performance and save cost while using APEXlang with coding agents, you can watch the replay here: youtube.com/live/idsI7pQ... #orclAPEX

United Codes, Live! - Supercharge APEXlang

YouTube video by United Codes

youtube.com

Looking to generate #orclAPEX apps with APEXlang? You should join our webinar tomorrow! We will showcase an approach that save over 50% of $/tokens/time and thus is smarter as LLMs fatigue quickly. And the best part: you will be able to do the exact same thing at home. (links in comment)

Improved uc-local-apex-dev: - One-shot ./install.sh: starts the stack, waits for DB + ORDS, configures everything. Zero manual steps - Native Podman support: auto-detects your engine (Docker or Podman) - SELinux-ready out of the box Local #orclAPEX 26.1 even simpler. github.com/United-Codes...

I've been experimenting with an approach where agents don't need to relearn #orclAPEX APEXlang syntax every time – instead they get tools to read, query and edit .apx files directly. Results look great, learn more in our stream next Tuesday (see reply)!

Cooking something to make it easier for AI agents to work with #APEXlang looks quite promising. Will release very soon. #orclAPEX

APEX Connect 26 was exceptional as always! Great to see many friends again, learn about #orclAPEX 26.1 (and that my body still does not like rollercoasters 🎢). Thanks DOAG and everyone involved! Looking forward to APEXconn27 in Cologne! #APEXConn

How to run #orclAPEX 26.1 locally – fresh setup if you don't have a local DB yet, or upgrade path if you already use uc-local-apex-dev: hartenfeller.dev/blog/run-ape...

Run Oracle APEX 26.1 Locally

APEX 26.1 was finally released yesterday. Learn how to quickly set it up locally and test the new features with uc-local-apex-dev.

hartenfeller.dev

Git pull uc-local-apex-dev and run this to upgrade to 26.1 . Still waiting for ORDS 26.1.1 to be available from the container registry. #orclAPEX

I released the beta of the UC AI Chat plug-in for #orclAPEX 🎉 - Run AI agents from any APEX page - Visualize tool calls & reasoning steps - Runs in a scheduler job hartenfeller.dev/blog/uc-ai-c...

UC AI Chat Plug-In Beta

Build APEX AI agents with UC AI thanks to the new chat plug-in

hartenfeller.dev

APEX 26.1 brings native tools/function calling — the core building block for AI agents. Wrote up best practices on scope, validation, and security to help your agents succeed. #orclAPEX hartenfeller.dev/blog/ai-tool...

Best Practices for LLM Tools or Function Calling for Oracle Developers

APEX 26.1 brings native LLM function calling to PL/SQL. Here's how to design tools that the model actually uses correctly: scope, validation, and security.

hartenfeller.dev

New release for uc-local-apex-dev - DB 26.1 - ORDS 26.1 - Several script improvements (see github release notes) Thanks @alexnuijten.bsky.social for your contributions :) #orclAPEX #oracle github.com/United-Codes...