Intro to DBMS_MLE: Pass Variables from PL/SQL to Javascript inside a Function

This video creates a function that illustrates by-directional variable sharing between pl/sql variables and javascript variables inside a 21c database function.

The video begins by showcasing how to query and determine the version of the database you are running, then execute a simple javascript program inside the Oracle Multi-lingual engine to determine if the feature is enabled. We then query the database inside Oracle APEX 21.1.1.7 leveraging SQL*Workshop and show a sample pl/sql function creating a Code Name for a player. After seeing the end result, we will walk you line by line through the sample code so you understand:
- How to pass a number in variable from PL/SQL to Javascript
- How to import the number into a Javascript variable
- How to execute a Query inside Javascript against the Oracle Database
- How to retrieve and iterate through results in Javscript
- How to export a Javascript text string to a pl/sql varchar2
- How to import javascript text into a pl/sql varchar2
- How to open and close a dbms_mle context

Example Code can be found inside the git repo at the link below.

#mle #21c #apex #javascript #oracle #graalvm

[mahmoudnoor]

PLS-00201: identifier 'DBMS_MLE.CONTEXT_HANDLE_T' must be declared