Getting Started with Codex, SQLcl MCP and APEXlang for Oracle APEX Development
Using Codex, SQLcl MCP and APEXlang to update an existing Oracle APEX application, validate the changes and import them with SQLcl.
· 5 min read
READ ARTICLEBLOG
Practical Oracle APEX, PL/SQL and integration guides, alongside VaultBridge projects and personal experiments.
Using Codex, SQLcl MCP and APEXlang to update an existing Oracle APEX application, validate the changes and import them with SQLcl.
· 5 min read
READ ARTICLE
Diagnose Oracle UTL_HTTP failures with a reusable PL/SQL script that helps distinguish network timeouts, wallet issues, certificate errors and HTTP responses.
· 10 min read
READ ARTICLE
Create an Oracle APEX workspace and administrator directly with PL/SQL, set the workspace context and verify the new user.
· 2 min read
READ ARTICLE
Export and import Oracle schemas directly to OCI Object Storage using DBMS_DATAPUMP, DBMS_CLOUD credentials and URI dump files.
· 4 min read
READ ARTICLE
Restore focus to the last active Oracle APEX Interactive Grid cell after returning to the browser tab or window.
· 4 min read
READ ARTICLE
How I connected my Oracle APEX application to a Custom GPT through ORDS and GPT Actions.
· 5 min read
READ ARTICLE
Pass a comma-separated string between Oracle APEX pages as one item value without APEX splitting it at each comma.
· 2 min read
READ ARTICLE
How I turned a small Oracle APEX ticketing application into a versioned, auditable REST API secured with ORDS and OAuth 2.0.
· 11 min read
READ ARTICLE
How a small ChatGPT-to-Obsidian experiment became a self-hosted REST API with local semantic search, Docker and TrueNAS support.
· 10 min read
READ ARTICLE
A practical self-hosted workflow that turns ChatGPT output into structured Obsidian notes stored on TrueNAS and synced back to desktop.
· 26 min read
READ ARTICLE
Learn how to download and browse Wikipedia offline with Kiwix, choose the right package, and understand the practical trade-offs.
· 5 min read
READ ARTICLE
A practical look at melatonin, when it may help with sleep, its limitations, and my own experience using it.
· 5 min read
READ ARTICLE