Raoul Mangoensentono

Six ways to call an LLM from Oracle APEX, and the region choice that broke all six

I tried six different ways to send a prompt to an LLM from Oracle APEX and get text back. All six failed. Not because of bad code but because of a decision made once at signup, years before Generative AI existed as a product. I had a hunch going in.

We improved the query by 40% and the report was still slow

A real client performance problem, a personal benchmark setup and numbers that prove why it worked. TL;DR: ORDS is Oracle's tool for exposing database data as REST services. If your ORDS handler builds its JSON response using a PL/SQL loop with JSON_OBJECT_T, replacing it