Martins Blog

Powered by
WordPress

  • Better support for JavaScript’s console.log() in ORDS handlers

    Oracle released Oracle REST Data Services (ORDS) 25.2 recently, in other words it’s time for me to upgrade. The release highlights have been summarised elsewhere, so I won’t do that again. Please head over to Chris Hoina’s blog post for all the details. One thing in particular I would like to point out though is…

  • Thementage 2025: CI/CD demo part 2

    The first part of this mini-series dealt with Continuous Integration/Continuous Delivery in the context of database applications. More specifically how to use the SQLcl (Oracle SQL Developer Command Linx) project command to create and move an APEX app from development to production. This article consists of 2 parts: Recap Please refer to part 1 for…

  • Thementage 2025: CI/CD demo part 1

    I am, and have been, an admirer of Andrea Held’s conferences, both IT Tage in Frankfurt in December, and more recently its online edition, Thementage Remote. I had the great privilege to be part of both of them. This article consists of 2 parts: My most recent presentation was yesterday, where I demonstrated how to…

  • What’s new with MLE 23.8 – restricted execution contexts

    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. The availability of Oracle Database 23ai Release Update 8…

  • MLE/JavaScript support in SQLDeveloper for VSCode

    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. The latest Oracle SQL Developer Extension for VSCode release…

  • Multilingual Engine: polyfill timeouts and intervals

    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. One of the really interesting opportunities offered by MLE…

  • Debugging JavaScript handlers in ORDS

    A question came up recently how to troubleshoot MLE/JavaScript handlers in Oracle Rest Data Services (ORDS). These kind of questions are great inspirations for blog posts, as you can see in this article. If you are unfamiliar with the concept of ORDS handlers written in JavaScript, please refer to an earlier post for more details.…

  • Using Oracle Database 23ai as a Document Store

    JSON is one of the most popular data formats, and unsurprisingly, modern, multi-model database, Oracle included, offer JSON support. Ideally, your database engine supports both a noSQL-like document API and the relational model for higher degrees of flexibility. The SQL standard was enhanced in 2016 and 2023 to accommodate SQL/JSON processing. At the risk of…

  • Using PDF-LIB to generate PDFs in the database

    Recently, someone asked if it was possible to use PDF-LIB with Multilingual Engine (MLE) and APEX. That was a fun challenge to solve, and you can read more about it here. Turns out, it sure is possible to use PDF-LIB, but before you consider adopting it, please also review the other options available to you – APEX supports PDF generation…

  • NJS-044: named JSON object is not expected in this context in MLE/JavaScript

    This is a quick post hopefully saving you 5 minutes debugging the following error in Multilingual Engine (MLE) as shipping with Oracle Database 23ai on Linux/{x86-64,aarch64}: Th error is caused in situations when you provide a JavaScript object as a positional bind to MLE’s JavaScript SQL Driver. The SQL Driver analyses the JavaScript object and expects to find…