Martins Blog

Powered by: WordPress

SodaDocumentCursor is iterable in node-oracledb 6.4 👏
Ad-hoc MLE JavaScript in Oracle Database 23c: Database Actions

A short post describing how to use Database Actions to run some ad-hoc JavaScript code
Ad-hoc MLE/ JavaScript execution in Oracle Database 23ai: DBMS_MLE

Occasionally it makes sense to run In-Database JavaScript code in an ad-hoc fashion. You typically do that to test something before wrapping the JavaScript code into a module. There are many ways to achieve this goal: This post demonstrates how to use DBMS_MLE for ad-hoc JavaScript execution. The package is documented in the JavaScript Developer’s…
Ad-hoc MLE JavaScript in Oracle Database 23c: APEX
Using server-side JavaScript in APEX processes

Before you can use the MLE module you have to create an MLE environment first. Still in the object browser, create a new MLE env and name it TIMEKEEPING_ENV. Assign timekeeping as the import name, pointing to the TIMEKEEPING_MODULE you just created. The final step is to assign the newly created environment to the APEX…
More fun while coding: local dev-environment for MLE, Oracle Database 23c Free

The recent release of the SQL-Developer extension for VSCode (Visual Studio Code) closes a gap for anyone developing server-side JavaScript code for Oracle Database 23c. And everyone else of course who always wanted to use VSCode for database development. And dark mode. The SQL Developer extension allows you to stay within a single IDE to…
Using MLE JavaScript modules for APEX validations
Calculating sums of interval expressions in Oracle Database 23c
Jump-start developing APEX apps using MLE/JavaScript: Containers

Support for In-Database JavaScript is one of the most exciting new features in Oracle Database 23c Free. JavaScript is the first language supported by Oracle Multilingual Engine (MLE), powered by GraalVM. Oracle APEX was one of the first platforms to support server-side JavaScript. If you want to get started developing using MLE and APEX without…
Using a proxy with the JavaScript fetch API and UTL_HTTP

This short post details how to use a proxy server for outgoing API requests, covering both UTL_HTTP and the In-Database JavaScript fetch() API. The code in this article was tested on Oracle Database 23ai Free, using the container image from container-registry.oracle.com.