Philipp Hartenfeller

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

701 followers357 following734 posts

Pinned

Philipp Hartenfeller
@hartenfeller.dev

New blog post, my longest one ever. A full guide on how to use AI as a PL/SQL developer. - No 23ai or Python required - Advanced techniques like tools, structured output, reasoning, and file analysis - Usage demos hartenfeller.dev/blog/real-ai... #oracle #ai #orclAPEX

hartenfeller.devBuild Real AI Solutions with Oracle PL/SQL (No 23ai Required)Learn how data engineers can leverage AI for Oracle automation using PL/SQL. Discover structured output, file analysis, reasoning, and tool calling with the open-source UC AI SDK.
Philipp Hartenfeller
@hartenfeller.dev

Oracle Deep Data Security is so good; a brilliantly designed relational database enhancement. But there is a big catch: it currently requires a Cloud Identity Provider, also for #orclAPEX ... #JoelKallmanDay #Oracle #SQL hartenfeller.dev/blog/deep-da...

hartenfeller.devDeep Data Security is here to stay #JoelKallmanDayI think Deep Data Security (DDS) is one of the most promising additions to Oracle 26ai. The idea is straightforward: describe who may read or change which data with SQL, and let the database enforce i...
Philipp Hartenfeller
@hartenfeller.dev

OpenAI's new Decisions API and TypeSafe's Jev point to a new kind of AI model next to LLMs. They give typed answers with probabilities instead of generated text. That's why UC AI 26.5 adds uc_ai.decide, a PL/SQL API for both #orclAPEX #oracle #oracleAI #PLSQL

Philipp Hartenfeller
@hartenfeller.dev

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

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.

Philipp Hartenfeller
@hartenfeller.dev

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

github.comRelease v26.4 – OCR, Mistral PDF, Toon enhancements · United-Codes/uc_aiTo 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...
Philipp Hartenfeller
@hartenfeller.dev

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...

hartenfeller.devMake APEXlang Easy: Makefiles and Merge-Safe ImportsHow 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...
Philipp Hartenfeller
@hartenfeller.dev

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

It's a wrap. Biggest UC AI release ever. Small and big improvements. I will do more learning material about it in the next weeks. BTW: free + open source. #orclAPEX #AI #PLSQL #oracle

Philipp Hartenfeller reposted

Jon Dixon
@jon.cloudnueva.com

I tested APEX 26.1 AI Agents with a technician-dispatch use case. This post covers setup, tools, deployment options, current limitations, and lessons about validation, authorization, context, and human approval. #orclAPEX #AIAgents blog.cloudnueva.com/apex-ai-agen...

blog.cloudnueva.comAPEX 26.1 AI Agents for Real-World AppsBuild practical APEX 26.1 AI Agents with tools, prompts, approvals, PL/SQL calls, and guardrails for real-world business apps.
Philipp Hartenfeller
@hartenfeller.dev

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

hartenfeller.devOracle Free image bumps aren't upgrades; how to patch the data dictionary anywayChanging the Oracle Free image tag keeps your data but leaves the data dictionary behind. Learn how to check, and how to patch it.
Philipp Hartenfeller
@hartenfeller.dev

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

hartenfeller.devProgrammatic Tool Calling in the Oracle Database with MLE JavaScriptLetting 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...
Philipp Hartenfeller
@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.

Philipp Hartenfeller reposted

Robert Marz
@robbie.databee.org

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)

Philipp Hartenfeller
@hartenfeller.dev

⚠️️If you have DBs running make sure they are not reachable from the internet (port 1521 is behind the firewall). Oracle sent out notifications about open ports last week.

Philipp Hartenfeller
@hartenfeller.dev

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

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

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...

hartenfeller.devLetting Coding Agents Lint Their Own PL/SQL with dbLinterCoding 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.
Philipp Hartenfeller
@hartenfeller.dev

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

Philipp Hartenfeller
@hartenfeller.dev

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

github.comRelease v26.3: DB 23.26.2.0 · United-Codes/uc-local-apex-devWhat'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...
Philipp Hartenfeller
@hartenfeller.dev

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

Philipp Hartenfeller
@hartenfeller.dev

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)