Calling PL/SQL and SQL from the MLE JavaScript SQL Driver

• Introduction to the MLE JavaScript SQL Driver

  The MLE JavaScript driver is closely modeled after the client-side Oracle SQL driver for Node.js, node-oracledb.

• Selecting Data Using the MLE JavaScript Driver

  Data can be selected using Direct Fetches or ResultSet objects.

• Data Modification

  Modify data using the MLE JavaScript SQL driver.

• Bind Variables

  Use bind variables to control data passed into or retrieved from the database.

• PL/SQL Invocation from the MLE JavaScript SQL Driver

  Use the MLE JavaScript driver to call functions and procedures from PL/SQL.

• Error Handling in SQL Statements

  JavaScript provides an exception framework like Java. Rather than returning an Error object as a promise or callback as in node-oracledb, the MLE JavaScript driver resorts to throwing errors. This concept is very familiar to PL/SQL developers.

• Working with JSON Data

  The use of JSON data as part of a relational structure, more specifically the use of JSON columns in (relational) tables, is described.

• Working with User-Defined Data Types

  Collections, records, and abstract data types can be used as parameters in JavaScript functions and can be inserted into the database with in-database JavaScript.

• Using Large Objects (LOB) with MLE

  A PL/SQL wrapper type is used to handle CLOBs and BLOBs with the MLE JavaScript driver.

• API Differences Between node-oracledb and mle-js-oracledb

  There are several differences between node-oracledb and mle-js-oracledb, including the methods for handling connection management and type mapping.

• Introduction to the PL/SQL Foreign Function Interface

  The Foreign Function Interface (FFI) is designed to provide straightforward access to PL/SQL packages in a familiar, JavaScript-like fashion.