7 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 orResultSetobjects. - 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 anErrorobject as a promise or callback as innode-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. - 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 betweennode-oracledbandmle-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.