Martins Blog

Powered by
WordPress

  • JSON strict and lax syntax in Oracle Database | Pt 1: Storing JSON

    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 syntax: Let’s look at the first of these – storing JSON – before diving into type conversions in a future…

  • Use Flashback Time Travel with Autonomous Database

    This is a very short post, mainly for my own benefit, to summarise how to use Flashback Time Travel (previously named Flashback Data Archive or Total Recall) in Autonomous Database 23ai – Serverless (ADB-S from now on). At the time of writing the database was patched to Release Update 7: SQL> select 2 version_full 3…

  • What’s new in Multilingual Engine 23.7: Foreign Function Interface

    The availability of Oracle Database 23ai Release Update 7 marks the introduction of a number of new features for Multilingual Engine (MLE) and JavaScript. As always you find the details in Oracle’s JavaScript Developers Guide and the MLE Module API documentation on GitHub. This post demonstrates one of the most exciting features: the Foreign Function Interface, or FFI…

  • Node-express MLE/JavaScript example

    A short post demonstrating how to use node-express and Oracle’s Multilingual Engine (MLE) in Release 23ai

  • With-clause, values operator and a strange JSON_TABLE error

    A short tale of investigating a problem with JSON_TABLE, common table expressions and the value operator in Oracle Database 23ai

  • Containers are awesome, not only for stateless things

    This post describes why using containers, even for database driven applications, is very useful.

  • Loading MLE modules into the database got a lot easier with SQLcl 24.3.2

    Oracle AI Database 26ai running on Linux x86-64 and aarch64 allows you to write server-side JavaScript code, stored and executed directly within the database. Multilingual Engine (MLE), powered by GraalVM makes this possible. Developers can write their JavaScript modules in a way that is very similar to how PL/SQL developers write functions, procedures, and packages.…

  • Your local development environment: Oracle Database 23ai Free on WSL2

    Recently I posted a few tweets about my experience developing on windows. That’s something new to me, typically I’d use either Linux or MacOS. Some of you wanted to know how that went, so … here’s the story. In preparation for my talk about Continuous Integration/Delivery (CI/CD) and the pending update of my “DevOps with…

  • Avoiding MLE/JavaScript pitfalls: the requested module does not provide an export named ‘default’

    Oracle Database 23ai saw the introduction of JavaScript as an additional language for writing server-side code. As with PL/SQL, it is possible to separate JavaScript code into separate units. This concept is similar to PL/SQL where you group code logic into packages. In JavaScript, these code units are called modules. Just as with PL/SQL, you…

  • Troubleshooting the Oracle Cloud Infrastructure API

    Sometimes, it can be interesting to learn how the Oracle Cloud Infrastructure (OCI) API works, particularly if your favourite Internet search engine fails to locate the exact syntax of an API call. This is typically due to unspecific search terms because the OCI CLI is really well documented, but those things happen. I would like…