Martins Blog

Powered by
WordPress

  • 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: Let’s look at the second aspect: type conversion. This post concerns Oracle Database 23ai and JSON SQL functions. Here…

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

  • JSON strict and lax syntax in Oracle Database | Pt 2: Type Conversions (dot notation)

    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: Let’s look at the second aspect: type conversion. This post concerns Oracle Database 23ai and the simple dot access…

  • Less-well-known features of Multilingual Engine: Document API

    Many developers like the simplicity and flexibility provided by specialised document databases. These systems offer a lot of freedom when it comes to writing applications. If you don’t like SQL, a document API provides another way to persist data. There is no better or worse approach. Developers should be empowered to use the technology they are most comfortable with…

  • What’s new in Multilingual Engine 23.7: Fetch Type Handler Support

    The availability of Oracle Database 23ai Release Update 7 marks the introduction of several new features for Multilingual Engine (MLE) and JavaScript. As always, you can find the details in Oracle’s JavaScript Developers Guide and the MLE Module API documentation on GitHub. This post demonstrates the use of Fetch Type Handlers. Fetch Type Handlers have been part of node-oracledb since…