Martins Blog

Powered by
WordPress

  • 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…

  • JSON strict and lax syntax in Oracle Database | Pt 3: Type Conversions (SQL functions)

    A recent forum post prompted me to look into JSON syntax rules and their implications more closely. The way I read the JSON Developer’s Guide, there are two aspects to the topic of lax and strict JSON: When storing JSON as a database column Performing type conversions as part of JSON functions like JSON_QUERY, etc. Let’s…

  • Oracle Cloud Infrastructure: establish a console connection to a Windows compute VM

    You may occasionally run into issues with a Windows 2022 (or later) compute VM in Oracle Cloud Infrastructure (OCI) that require you to access the VM via the graphical recovery console. This article describes how to connect to a graphical recovery console, based on VNC using MacOS 15.3 Sequoia. The latest MacOS 15.3 ships with OpenSSH_9.8p1/LibreSSL 3.3.6. It…

  • SQLcl introduces support for Rollup.js to load MLE modules

    Thanks to the awesome team developing new features for Oracle SQL Developer Command Line creating modules for Multilingual Engine (MLE) just got a lot easier. SQLcl 24.3.2 introduces the mle create-module command allowing you to create a MLE module from a file in the directory. I blogged about the feature in the past. SQLcl 24.4.1 raises the bar even further. Background A…