Notes
Verified Oracle findings, one at a time
Short notes on things we reproduced on a real Oracle database or read in Oracle's docs. Each one links to the guide that covers it in full.
- OllamaAPEXNetwork ACL
Ollama + APEX: give the network ACL to the right user
APEX_WEB_SERVICE calls go out as the APEX engine schema, not APEX_PUBLIC_USER, and the grant must run in the APEX PDB.
From the guide: Run a local LLM (Ollama) inside Oracle APEX
Read the note → - APEX 26.2UpgradeORDS
APEX 26.2 upgrade: the prerequisites most checklists skip
ORDS and SQLcl 26.3.0 or later, WORKAREA_SIZE_POLICY = AUTO in the installer's session, the right container, and a rollback plan.
From the guide: Upgrade Oracle APEX 24.1 to 26.2
Read the note → - 26aiVector SearchSQL
FETCH FIRST isn't always exact in Oracle AI Database 26ai vector search
Once a vector index exists, a plain FETCH FIRST similarity query can use it and return approximate results. FETCH EXACT FIRST guarantees an exact search.
From the guide: Oracle AI Database 26ai Vector Search for app developers
Read the note → - SQLclCI/CDAPEX
Your APEX pipeline might be lying to you: SQLcl exits 0 when apex import fails
SQLcl returns exit code 0 even when apex validate or apex import reports errors, so a CI job goes green with nothing deployed.
From the guide: CI/CD for APEX with GitHub Actions
Read the note →