Table of Contents

• Title and Copyright Information
• Changes in This Release for JavaScript Developer’s Guide
  • July 2024, Release Update 23.5
  • January 2025, Release Update 23.7
  • April 2025, Release Update 23.8
  • July 2025, Release Update 23.9
  • October 2025, Release Update 23.26.0
  • January 2025, Release Update 23.26.1
• Introduction to Oracle AI Database Multilingual Engine for JavaScript
  • The Need for a Multilingual Engine
  • Overview of JavaScript
  • Overview of Multilingual Engine for JavaScript
    • JavaScript Implementation Details
    • Invoking JavaScript in the Database
    • Introduction to Dynamic Execution
    • Introduction to MLE Module Calls
    • About MLE Execution Contexts
    • About Restricted Execution Contexts
  • Introduction to Debugging JavaScript Code
• MLE JavaScript Modules and Environments
  • Using JavaScript Modules in MLE
    • Managing JavaScript Modules in the Database
      • Naming JavaScript Modules
      • Creating JavaScript Modules in the Database
      • Storing JavaScript Code in Databases Using Single-Byte Character Sets
      • Code Analysis
    • Preparing JavaScript code for MLE Module Calls
    • Additional Options for Providing JavaScript Code to MLE
    • Specifying Module Version Information and Providing JSON Metadata
    • Drop JavaScript Modules
    • Alter JavaScript Modules
    • Overview of Built-in JavaScript Modules
    • Dictionary Views Related to MLE JavaScript Modules
      • USER_SOURCE
      • USER_MLE_MODULES
  • Specifying Environments for MLE Modules
    • Creating MLE Environments in the Database
      • Naming MLE Environments
      • Creating an Empty MLE Environment
      • Creating an Environment as a Clone of an Existing Environment
      • Using MLE Environments for Import Resolution
      • Providing Language Options
        • JavaScript Language Options
    • Dropping MLE Environments
    • Modifying MLE Environments
      • Altering Language Options
      • Modifying Module Imports
    • Dictionary Views Related to MLE JavaScript Environments
      • USER_MLE_ENVS
      • USER_MLE_ENV_IMPORTS
• Overview of Dynamic MLE Execution
  • About Dynamic JavaScript Execution
  • Dynamic Execution Workflow
    • Providing JavaScript Code Inline
    • Loading JavaScript Code from Files
  • Returning the Result of the Last Execution
• Overview of Importing MLE JavaScript Modules
  • JavaScript Module Hierarchies
    • Resolving Import Names Using MLE Environments
  • Export Functionality
    • Named Exports
    • Default Exports
    • Private Identifiers
  • Import Functionality
    • Module Objects
    • Named Imports
    • Default Imports
• MLE JavaScript Functions
  • Call Specifications for Functions
    • Creating a Call Specification for an MLE Module
      • Components of an MLE Call Specification
      • MLE Module Clause
      • ENV Clause
      • SIGNATURE Clause
    • Creating an Inline MLE Call Specification
      • Components of an Inline MLE Call Specification
      • Accessing Built-in Modules Using JavaScript Global Variables
    • Choosing Inline Versus Module MLE Call Specifications
    • Runtime Isolation for an MLE Call Specification
    • Dictionary Views for Call Specifications
  • OUT and IN OUT Parameters
• Calling PL/SQL and SQL from the MLE JavaScript SQL Driver
  • Introduction to the MLE JavaScript SQL Driver
    • Working with the MLE JavaScript Driver
    • Connection Management in the MLE JavaScript Driver
    • Introduction to Executing SQL Statements
    • Processing Comparison Between node-oracledb and mle-js-oracledb
  • Selecting Data Using the MLE JavaScript Driver
    • Direct Fetch: Arrays
    • Direct Fetch: Objects
    • Fetching Rows as ResultSets: Arrays
    • Fetching Rows as ResultSets: Iterating Over ResultSet Objects
  • Data Modification
  • Bind Variables
    • Using Bind-by-Name vs Bind-by-Position
      • Named Bind Variables
      • Positional Bind Variables
    • RETURNING INTO Clause
    • Batch Operations
  • PL/SQL Invocation from the MLE JavaScript SQL Driver
  • Error Handling in SQL Statements
  • Working with JSON Data
  • Working with User-Defined Data Types
    • Using Record Data Types in JavaScript
    • Using Collections in JavaScript
  • Using Large Objects (LOB) with MLE
    • Writing LOBs
    • Reading LOBs
  • API Differences Between node-oracledb and mle-js-oracledb
    • Synchronous API and Error Handling
    • Connection Handling
    • Transaction Management
    • Type Mapping
    • Unsupported Data Types
    • Miscellaneous Features Not Available with the MLE JavaScript SQL Driver
  • Introduction to the PL/SQL Foreign Function Interface
    • Object Resolution Using FFI
    • Provide Arguments to a Subprogram Using FFI
• Working with SODA Collections in MLE JavaScript Code
  • High-Level Introduction to Working with SODA for In-Database JavaScript
  • SODA Objects
  • Using SODA for In-Database JavaScript
    • Getting Started with SODA for In-Database JavaScript
    • Creating a Document Collection with SODA for In-Database JavaScript
    • Opening an Existing Document Collection with SODA for In-Database JavaScript
    • Checking Whether a Given Collection Exists with SODA for In-Database JavaScript
    • Discovering Existing Collections with SODA for In-Database JavaScript
    • Dropping a Document Collection with SODA for In-Database JavaScript
    • Creating Documents with SODA for In-Database JavaScript
    • Inserting Documents into Collections with SODA for In-Database JavaScript
    • Saving Documents into Collections with SODA for In-Database JavaScript
    • SODA for In-Database JavaScript Read and Write Operations
    • Finding Documents in Collections with SODA for In-Database JavaScript
    • Replacing Documents in a Collection with SODA for In-Database JavaScript
    • Removing Documents from a Collection with SODA for In-Database JavaScript
    • Indexing the Documents in a Collection with SODA for In-Database JavaScript
    • Getting a Data Guide for a Collection with SODA for In-Database JavaScript
    • Handling Transactions with SODA for In-Database JavaScript
    • Creating Call Specifications Involving the SODA API
• Post-Execution Debugging of MLE JavaScript Modules
  • Specifying Debugpoints
    • Debugpoint Locations
    • Debugpoint Actions
    • Debugpoint Conditions
  • Managing Debugpoints
    • Debugging Security Considerations
    • COLLECT DEBUG INFO Privilege for MLE Modules
  • Analyzing Debug Output
    • Textual Representation of Debug Output
    • Analyzing Debug Output Using Developer Tools
  • Error Handling in MLE
    • Errors in Callouts
    • Accessing stdout and stderr from JavaScript
      • Accessing stdout and stderr for MLE Modules
      • Accessing stdout and stderr for Dynamic MLE
• MLE Security
  • System and Object Privileges Required for Working with JavaScript in MLE
    • Necessary Privileges for Dynamic MLE Execution
    • Necessary Privileges for Using the NoSQL API
    • Necessary Privileges for Creating MLE Schema Objects
    • Necessary Privileges for Creating MLE Modules and Environments in ANY Schema
    • Necessary Privileges for Post-Execution Debugging
  • Security Considerations for MLE
    • MLE_PROG_LANGUAGES Initialization Parameter
    • Execution Contexts
    • Runtime State Isolation
    • Database Security Model
    • Considerations for Using MLE Call Specifications and Modules from Different Schemas
    • Auditing MLE Operations in Oracle AI Database
  • JavaScript Security Best Practices
    • Using Bind Variables for Security and Performance
    • Generic Database and PL/SQL Specific Security Considerations
    • Supply Chain Security
    • Software Bill of Material
    • Using the Database to Store State
    • Disabling Multilingual Runtime
  • MLE Security Examples
    • Business Logic Stored in MLE Modules
    • Generic Data Processing Libraries
    • Generic Libraries in Business Logic
• MLE Type Conversions
  • MLE JavaScript Support for JSON
  • MLE JavaScript Support for the VECTOR Data Type