List of Examples
- 2-1 Creating a JavaScript Module in the Database
- 2-2 Create a Call Specification for a Public Function
- 2-3 Public and Private Functions in a JavaScript Module
- 2-4 Providing JavaScript Source Code Using a BFILE
- 2-5 Providing JavaScript Source Code Using a CLOB
- 2-6 Specification of a VERSION string in CREATE MLE MODULE
- 2-7 Addition of JSON Metadata to the MLE Module
- 2-8 Drop an MLE Module
- 2-9 Drop an MLE Module Using IF EXISTS
- 2-10 Alter an MLE Module
- 2-11 Externalize JavaScript Module Source Code
- 2-12 Find MLE Modules Defined in a Schema
- 2-13 Map Identifier to JavaScript Module
- 2-14 Import Module Functionality
- 2-15 List Available MLE Environments Using USER_MLE_ENVS
- 2-16 List Module Import Information Using USER_MLE_ENV_IMPORTS
- 3-1 Using the Q-Quote Operator to Provide JavaScript Code Inline with PL/SQL
- 3-2 Loading JavaScript code from a BFILE with DBMS_LOB.LOADCLOBFROMFILE()
- 3-3 Loading JavaScript Code from a BFILE by Referencing an MLE Module from DBMS_MLE
- 3-4 Returning the Result of the Last Execution
- 4-1 Use an MLE Environment to Map an Import Name to a Module
- 4-2 Function Export using Named Exports
- 4-3 Function Export Using Export Keyword Inline
- 4-4 Export a Class Using a Default Export
- 4-5 Named Export of Single Function
- 4-6 Module Object Definition
- 4-7 Named Imports Using Specified Identifiers
- 4-8 Named Imports with Aliases
- 4-9 Default Import
- 4-10 Default Import with Built-in Module
- 5-1 Creating MLE Call Specifications
- 5-2 Simple Inlined MLE Call Specification
- 5-3 Inlined MLE Call Specification Returning JSON
- 5-4 Execution Context Dependencies
- 5-5 Show JavaScript Call Specification Metadata
- 5-6 OUT and IN OUT Parameters with JavaScript
- 6-1 Getting Started with the MLE JavaScript SQL Driver
- 6-2 Use Global Variables to Simplify SQL Execution
- 6-3 Selecting Data Using Direct Fetch: Arrays
- 6-4 Selecting Data Using Direct Fetch: Objects
- 6-5 Fetching Rows Using a ResultSet
- 6-6 Using the Iterable Protocol with ResultSets
- 6-7 Using the Iterator Protocol with ResultSets
- 6-8 Updating a Row Using the MLE JavaScript SQL Driver
- 6-9 Using Named Bind Variables
- 6-10 Using Positional Bind Variables
- 6-11 Using the RETURNING INTO Clause
- 6-12 Performing a Batch Operation
- 6-13 Calling PL/SQL from JavaScript
- 6-14 SQL Error Handling Inside a JavaScript Function
- 6-15 Error Handling Using JavaScript throw() Command
- 6-16 Inserting JSON Data into a Database Table
- 6-17 Use JavaScript to Manipulate JSON Data
- 6-18 Inserting a CLOB into a Table
- 6-19 Read an LOB
- 6-20 Using JavaScript Native Data Types vs Using Wrapper Types
- 6-21 Overriding the Global oracledb.fetchAsPlsqlWrapper Property
- 7-1 SODA with MLE JavaScript General Workflow
- 7-2 Creating a Collection with Custom Metadata
- 7-3 Opening an Existing Document Collection
- 7-4 Fetching All Existing Collection Names
- 7-5 Filtering the List of Returned Collections
- 7-6 Dropping a Collection
- 7-7 Creating SODA Documents
- 7-8 Inserting a SODA Document into a Collection
- 7-9 Inserting an Array of Documents into a Collection
- 7-10 Saving a Document into a Collection
- 7-11 Finding a Document by Key
- 7-12 Looking up Documents Using Multiple Keys
- 7-13 Using a QBE to Filter Documents in a Collection
- 7-14 Using skip() and limit() in a Pagination Query
- 7-15 Specifying Document Versions
- 7-16 Counting the Number of Documents Found
- 7-17 Replacing a Document in a Collection and Returning the Result Document
- 7-18 Removing a Document from a Collection Using a Document Key
- 7-19 Removing JSON Documents from a Collection Using a Filter
- 7-20 Creating a B-Tree Index for a JSON Field with SODA for In-Database JavaScript
- 7-21 Creating a JSON Search Index with SODA for In-Database JavaScript
- 7-22 Dropping an Index with SODA for In-Database JavaScript
- 7-23 Generating a Data Guide for a Collection
- 7-24 Use SODA for In-Database JavaScript
- 8-1 JSON Template for Specifying Debugpoints
- 8-2 JSON Template for Specifying Watch Action
- 8-3 JSON Template for Specifying Snapshot Action
- 8-4 Watching a Variable in an MLE Module
- 8-5 Enabling Debugging of an MLE Module
- 8-6 Obtain Textual Representation of Debug Output
- 8-7 Throwing
ORA-04161
Error and Querying the Stack Trace - 8-8 Redirect stdout to CLOB and DBMS_OUTPUT for MLE Module
- 8-9 Redirect
stdout
toCLOB
andDBMS_OUTPUT
for Dynamic MLE - 9-1 Runtime State Isolation Scenario
- 9-2 Using Bind Variables Rather than String Concatenation
- 9-3 Use DBMS_ASSERT to Verify Valid Input
- 9-4 Using Bind Variables Rather than String Concatenation
- 9-5 Use DBMS_ASSERT to Verify Valid Input
- 9-6 Business Logic Stored in MLE Modules
- 9-7 Generic Data Processing Libraries
- 9-8 Use Generic Libraries in Business Logic
- A-1 Use VECTOR Data Type with MLE