All-In-One bundle for JavaScript APIs in Oracle Database

Oracle Database allows executing user-provided JavaScript code since version 21c by using the Multilingual Engine (MLE). This documentation describes mle-js which contains all relevant declarations of predefined JavaScript modules that ship with the database plus the declarations of all global symbols.

MLE Modules

Oracle Database ships with some predefined JavaScript modules:

• MLE SQL Driver: mle-js-oracledb
• MLE Bindings: mle-js-bindings
• MLE PL/SQL Types mle-js-plsqltypes
• MLE Fetch API polyfill mle-js-fetch
• MLE Encoding API: mle-js-encodings
• MLE Base64 Encoding: mle-encode-base64
• MLE Foreign Function Interface (FFI): mle-js-plsql-ffi

Global Symbols

The following symbols exist in each JavaScript context in Oracle Database:

• console
• JsonId (since Oracle 23.5)
• OracleNumber
• OracleBlob
• OracleClob
• OracleDate
• OracleTimestampTZ
• OracleTimestamp
• OracleIntervalDayToSecond (since Oracle 23.3)
• OracleIntervalYearToMonth (since Oracle 23.3)
• oracledb: shorthand for getting direct access to mle-js-oracledb without importing it
• Polyglot
• plsffi.arg (since Oracle 23.7)
• plsffi.argOf (since Oracle 23.7)
• plsffi.CallError (since Oracle 23.7)
• plsffi.resolvePackage (since Oracle 23.7)
• plsffi.resolveFunction (since Oracle 23.7)
• plsffi.resolveProcedure (since Oracle 23.7)
• session: shorthand for the mle-js-oracledb default connection; is used to issue SQL statements directly
• soda: shorthand for the mle-js-oracledb SODA Database object which can be used to create SODA collections
• SparseVector: (since Oracle 23.26.0)
• TextEncoder (since Oracle 23.4)
• TextDecoder (since Oracle 23.4)

The following symbols will get added to a JavaScript context after importing mle-js-fetch:

• fetch
• Headers
• Request
• Response