Overview of Multilingual Engine for JavaScript

MLE allows you to run and store JavaScript directly in the Oracle AI Database.

Using MLE enables users of the Oracle AI Database to run the following, written in JavaScript:

• Stored procedures

• Stored functions

• Code in a PL/SQL package namespace

• Anonymous, dynamic code snippets (in a way that is similar to DBMS_SQL)

MLE is supported when connecting to the database using a dedicated server connection on Linux x86-64 or Linux for Arm (aarch64), including with server connections that have enabled a Database Resident Connection Pool (DRCP). Certain data types are not supported, listed in full at Unsupported Data Types.

Note:

Shared server connections cannot make use of MLE.

Topics

• JavaScript Implementation Details
  The MLE implementation of JavaScript is compliant with ECMAScript 2023.
• Invoking JavaScript in the Database
  JavaScript can be invoked through dynamic execution or through call specifications, which either reference MLE modules or inline JavaScript functions.
• Introduction to Dynamic Execution
  Anonymous JavaScript code snippets can be executed via the DBMS_MLE PL/SQL package.
• Introduction to MLE Module Calls
  It is possible to create JavaScript modules as schema objects that are stored persistently in the database.
• About MLE Execution Contexts
  An MLE execution context is a standalone, isolated runtime environment, designed to contain all runtime state associated with the execution of JavaScript code. Runtime state includes global variables as well as the state of the language environment.
• About Restricted Execution Contexts
  The PURE keyword can be specified on MLE environments and JavaScript inline call specifications to create restricted JavaScript execution contexts.