Martins Blog

Powered by
WordPress

  • 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 Data Services (ORDS). In a nutshell you can write your GET, POST, PUT and DELETE handlers in JavaScript, powered by Multilingual Engine (MLE). I think this is a nice feature. Recently I ran into a situation where I’m using…

  • 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 that’s run whenever an ORDS container starts. This older article is now obsolete … Beginning with ORDS 25.2.3 a new flag has been added to the container image allowing you to debug the container startup. The new ORDS image…

  • 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 Database. My friend Øyvind Isene presented about Multilingual Engine (MLE)/JavaScript and made a good point about the delimiters you can use with inline JavaScript code. Please allow me to share a little bit of background first: When using MLE/JavaScript you…

  • Identify driver details of your cloud VM’s block devices

    While preparing a presentation for POUG 2025 I had a need to find out more about the block device driver in use on my system. I was particularly interested in the SCSI mid-layer and low-layer drivers. Unsure about these terms? I am referring to the Linux Storage Stack Diagram. It’s a great resource for anyone…

  • 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 store rather large JSON documents, individual field lengths exceeding what I usually see. No problem with that, the database didn’t even so much as flinch. However, when I queried the table I used to store the JSON documents using…

  • 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 experience with the database: group by all. Just like the new select without from dual clause this might not sound like a big deal, but after a little while working with it, you don’t really want to miss it…

  • 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 Arm, respectively. Developers with a preference for Typescript can use it alternatively after transpilation to JavaScript. JavaScript support in Oracle Database is known as Multilingual Engine, or MLE for short. Oracle Database 23ai Release Update 9 does away with…

  • Troubleshooting errors in ORDS container image entrypoint

    I’m a huge fan of Oracle REST Data Services (ORDS) and use it extensively. I’m also very fond of the official container image, significantly simplifying the way I work with ORDS. The best thing is: I don’t need to concern myself with the REST and APEX installation – the image is clever enough to do…

  • Sourcing environment variables from .env in compose

    I am a great fan of {podman,docker}-compose. Using compose I can whip up environments in no time, define dependencies, and do a lot of cool stuff I otherwise would have to script in Ansible or other tools. I really like developing software, tools and other things locally before showing them to the world. Using compose…

  • LiveSQL supports MLE/JavaScript 🎉

    Oracle LiveSQL allows you to learn and share SQL, for free. You get instant access to the Oracle Database and learn from a collection of community scripts and tutorials. You can write your own SQL scripts and easily share them with others. All you need to get started is your Oracle.com account.No need to deal with…