Tessera
Folgen

Philipp Hartenfeller

@hartenfeller.dev

🖥️ Web & DBs | Oracle APEX 📝 Blog: http://hartenfeller.dev/blog 💼 Product Lead @united-codes.com ♠️ Oracle ACE Pro 🎥 https://www.youtube.com/@united-codes

733 Posts700 Follower357 Folgt
Philipp Hartenfeller@hartenfeller.dev · 6d ago

Abstract season begins so its the time of the year where I need to think about which topics I want to dive deep into and seem worthy to share. I wanted to do less talks but here I am again with 4 topics. And I bet one conference accepts 2 and another the other 2 :D

Philipp Hartenfeller@hartenfeller.dev · 7d ago

If you use uc-local-apex-dev you need one command to get to #orclAPEX 26.2: local-26ai.sh upgrade-apex (takes a few mins but runs without you having to do anything). Run local-26ai.sh shrink-space to remove 26.1 after you validated everything works fine.

Bild
Philipp Hartenfeller@hartenfeller.dev · 2w ago

I published UC AI 26.4: - New OCR method to extract text from a PDF without a chat model (Mistral, OCI, Ollama) - Mistral PDF support - TOON now compliant with spec 4.1 - New RAG tutorial github.com/United-Codes... #orclAPX

Release v26.4 – OCR, Mistral PDF, Toon enhancements · United-Codes/uc_ai

To upgrade run the upgrade_packages.sql script attached to the GitHub release. This release has no migration script. For new installations follow this guide. Behavior notes: TOON output follows sp...

github.com

Philipp Hartenfeller@hartenfeller.dev · 3w ago

I started using Make in my APEX projects to keep the SQLcl, etc. commands in 1 place. There's also a sync script that exports the app before importing and merges the changes with Git →imports don't overwrite what others did in App Builder. #orclAPEX hartenfeller.dev/blog/makefil...

Make APEXlang Easy: Makefiles and Merge-Safe Imports

How a makefile turns the SQLcl, Git and dbLinter commands of an APEX project into short make commands, and how a Git-based sync script stops APEXlang imports from overwriting your colleagues' App Buil...

hartenfeller.dev

Philipp Hartenfeller@hartenfeller.dev · last mo.

ORDS 26.2.3 via the container image: ERROR: Required variable ORACLE_USER_PWD is missing or empty. Aborting execution. The documentation states ORACLE_PWD is needed not ORACLE_USER_PWD. Also even after setting ORACLE_USER_PWD it doesn refuse to start. #oracle #ords

Philipp Hartenfeller@hartenfeller.dev · 2mo ago

I am using a Oracle Free DB as a local dev env. I want to be up to date and try out the new Oracle features. But patching is not supported. So I found my own solution to patch the data dictionary: hartenfeller.dev/blog/patch-o... #orclAPEX #oracle

Oracle Free image bumps aren't upgrades; how to patch the data dictionary anyway

Changing the Oracle Free image tag keeps your data but leaves the data dictionary behind. Learn how to check, and how to patch it.

hartenfeller.dev

Philipp Hartenfeller@hartenfeller.dev · 3mo ago

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

Philipp Hartenfeller@hartenfeller.dev · 3mo ago

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.

Robert Marz@robbie.databee.org · 3mo ago

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)

Podcast Cover zu O wie Datenbank Folge 06 - Oracle 26ai: Feature Häppchen für DBAs
Philipp Hartenfeller@hartenfeller.dev · 3mo ago

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

Philipp Hartenfeller@hartenfeller.dev · 3mo ago

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)

Philipp Hartenfeller@hartenfeller.dev · 3mo ago

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