Oracle

ORA-942 in MLE/JavaScript, but the query runs fine in my IDE! What gives?

This article is part of the upcoming Troubleshooting JavaScript chapter that should soon make it into…
Successfully Using SQLcl Projects If Your Production Branch Isn’t Called “main”

This short note demonstrates that the the production branch name is configurable in SQLcl projects. If…
Intro to Post-Execution Debugging in SQL Developer for VSCode

Post-execution debugging has been an integral feature in Multilingual Engine/JavaScript from the very beginning. It allows…
Life hack: encode a URL in a QR code using APEX

Someone in the community once said to me that APEX is awesome even if you’re not…
JavaScript Handler Functions in ORDS: Pay Attention to Data Types

In the past few weeks, I have written several articles covering JavaScript handlers in Oracle REST…
New DEBUG flag simplifies troubleshooting ORDS container image issues

I previously wrote about troubleshooting the ORDS (Oracle REST Data Services) container’s entrypoint, e.g. the script…
Inline JavaScript and some further details about code delimiters

I recently attended POUG 2025, perhaps the most technical conference in Europe with focus on Oracle…
Why does my call to json_table return null for a column despite it not being empty?

I recently worked on a fun project involving JSON and Oracle Database 23ai. I had to…
Group-by-all is awesome for digging in performance data

Oracle Database 23ai Release Update 9 introduces yet another new feature aimed at improving the developer…
What’s new with MLE 23.9 – no need to grant execute on javascript

Oracle Database 23ai introduces In-Database JavaScript for Linux x86-64 and aarch64. That’s Linux on Intel and…