Ottmar Gobrecht @ogobrecht.com · 26/03/2026Thank you for all the contributions to the project. Good work and much appreciated. 000
Reposted by Ottmar GobrechtJakob Drees @jakob-drees.bsky.social · 26/03/2026Today, @ogobrecht.com and I have released version 1.3.0 of the great console logging framework. It includes many new unit tests and a breaking change to the "assert"-procedure. Check out what's new in my latest blog post: seedandpublish.com/blog/console...seedandpublish.comNew console v1.3 releaseAdding unit tests for logging 121
Reposted by Ottmar GobrechtJon Dixon @jon.cloudnueva.com · 31/01/2026I've used AI for APEX and PL/SQL for a year, but this week something changed. ⚡ I generated 100s of lines of production-ready PL/SQL in one shot. It’s all about metadata, specs, and agent instructions. #orclAPEX #AI blog.cloudnueva.com/an-ai-shift-...blog.cloudnueva.com 062
Reposted by Ottmar GobrechtPhilipp Salvisberg @salvis.com · 28/01/2025I have stumbled across some implicit data conversions that I was unaware of, causing poor performance when querying JSON-relational duality views. I demonstrate what I mean using a simplified example in this blog post. www.salvis.com/blog/2025/01...salvis.comAvoid Implicit Type Conversion in JSON Access - Philipp Salvisberg's BlogDiscover why explicit JSON value conversion in SQL is essential for best performance and how to apply it in your code. 1148
Reposted by Ottmar GobrechtPatrick Wolf @patrick-wolf.bsky.social · 23/01/2025🚨 APEX 24.2.1 is here! 🚨 This update addresses several bugs in APEX 24.2. 👉 Learn more & download: apex.oracle.com/download 🛠️ Check Known Issues: apex.oracle.com/known-issues #orclapexapex.oracle.com 0124
Reposted by Ottmar GobrechtPlamen Mushkov @apexapplab.dev · 15/01/2025This release of APEX looks like another hit. Lots of new features, AI integrations, RAG, Vector search, JSON duality views, new APIs and Utilities and core component enhancements. Will share more as I explore in the next days and weeks💡 docs.oracle.com/en/database/... #orclAPEX 24.2 for the win 🏆docs.oracle.comRelease Notes 0176
Reposted by Ottmar GobrechtNiels de Bruijn @nielsdb.bsky.social · 15/01/2025Great new features in #orclapex 24.2! Congrats to the whole team! Here are my favorites: nielsdebr.blogspot.com/2025/01/my-f...nielsdebr.blogspot.comMy favorite new features in APEX 24.2 at a glanceLow-Code, Rapid Application Development, APEX, Oracle Application Express, Oracle Database, Rapid Prototyping, Consultancy, IT, PL/SQL 0174
Reposted by Ottmar Gobrechtmsewtz.bsky.social @msewtz.bsky.social · 15/01/2025Oracle APEX 24.2 is now generally available! This release unlocks new capabilities for AI-powered apps 🤖, configure RAG data for AI calls🧠, automate Fusion Applications integration🔁, work directly with JSON data ✨, and much more! apex.oracle.com/go/242-is-no... #orclAPEX #LowCode 03217
Reposted by Ottmar GobrechtLouis Moreaux @moreaux-louis.bsky.social · 14/01/2025The wait is over and the version is... 24.2 🤓 #orclAPEX 0103
Ottmar Gobrecht @ogobrecht.com · 12/01/2025Jakob Drees and I have just released version 1.2.0 of my #Oracle #PLSQL logging tool “console”. This tool also contains some #orclAPEX goodies. Read his blog post to find out what's new seedandpublish.com/blog/console...seedandpublish.comNew console v1.2 releaseParameter logging has never been easier! 040
Ottmar Gobrecht @ogobrecht.com · 22/12/2024Just released a new version of my npm package to convert #Oracle PL/SQL code into Markdown docs: github.com/ogobrecht/plocgithub.comGitHub - ogobrecht/ploc: npm package to convert PL/SQL code into Markdown docsnpm package to convert PL/SQL code into Markdown docs - ogobrecht/ploc 184
Reposted by Ottmar GobrechtGerald Venzl @gvenzl.bsky.social · 08/12/2024#Oracle #Database 23.6 Free multi-platform images now available on gvenzl/oracle-freegeraldonit.comOracle Database 23.6 Free multi-platform images now available on gvenzl/oracle-freeOracle Database 23.6 Free multi-platform images are now available on container registries docker.io/gvenzl/oracle-free and ghcr.io/gvenzl/oracle-free. 05631
Ottmar Gobrecht @ogobrecht.com · 07/12/2024Have a look here: APEX_INSTANCE_ADMIN.SET_WORKSPACE_PARAMETER ( p_workspace IN VARCHAR2, p_parameter IN VARCHAR2, p_value IN VARCHAR2 ) Parameters: MAX_SESSION_IDLE_SEC MAX_SESSION_LENGTH_SEC ... docs.oracle.com/en/database/...docs.oracle.comAPI Reference 141
Reposted by Ottmar GobrechtMartin Bach @martindba.bsky.social · 02/12/2024Many thanks to @thatjeffsmith.com and his team for greatly simplifying the way you deploy MLE/JavaScript modules to Oracle database 23ai. The most recent SQLcl release introduces the create-module command. You can find more details here: martincarstenbach.com/2024/12/02/l...martincarstenbach.comLoading MLE modules into the database got a lot easier with SQLcl 24.3.2Oracle Database 23ai running on Linux x86-64 and aarch64 allows you to write server-side JavaScript code, stored and executed directly within the database. Multilingual Engine (MLE), powered by Gra… 184
Reposted by Ottmar GobrechtSimon Martinelli @martinelli.ch · 25/11/2024The Oracle DB Docker images are awesome! Since 23.5 there are ARM images available and they start super fast. oracle-free:23-slim-faststart starts in 3.6 sec on my M4 Pro. Thanks, @gvenzl.bsky.social for doing an amazing job! 2218
Reposted by Ottmar GobrechtMartin Bach @martindba.bsky.social · 30/11/2024Some of you wanted to know how I set up my lab environment on windows using wsl2. Strictly no serious use, I'm just dabbling with the technology. How does the saying go? It works for me, on my machine. Details here: martincarstenbach.com/2024/11/30/y...martincarstenbach.comYour local development environment: Oracle Database 23ai Free on WSL2Recently I posted a few tweets about my experience developing on windows. That’s something new to me, typically I’d use either Linux or MacOS. Some of you wanted to know how that went, … 181
Reposted by Ottmar GobrechtOracle ACE Pro | Maintenance Team Leader & Oracle APEX Expert @rgrzegorczyk.bsky.social · 28/11/2024Part 5 of my "Whirlwind Tour of Database Schema Changes" is live! I reviewed Oracle SQLcl's "Project" feature - a game changer for Database & APEX deployments. Kudos to @thatjeffsmith.com and his Database Tools team! rafal.hashnode.dev/part5-sqlcl-... #oracle #orclAPEX #cicdrafal.hashnode.devPart5: SQLcl Project (It will forever change your Database & APEX deployments)Welcome to part 5 of "A whirlwind tour of Database Schema Changes Tracking Tools" In this article, I will provide a general overview and test the basic functionalities of the Oracle SQLcl “Project” command. I will cover only CI/CD for database change... 1197
Ottmar Gobrecht @ogobrecht.com · 30/11/2024New in an #Oracle project? Visually explore unknown data models with an #orclAPEX app! github.com/ogobrecht/da... 2116