Java 8 furnishes Nashorn, a JavaScript engine which runs on the JVM including JDK, JRE, and the embeded JVM in the Oracle database a..k.a. OJVM.

This folder stores database related Nashorn based examples (i.e., plain JavaScript + SQL statements) including JavaScript Stored procedures with OJVM, and standalone/client JavaScript functions with JDK/JRE.

For data access, Nashorn allows interoperability between Java and JavaScript, therefore, the SQL statements are invoked using JDBC which is a portable standard Java API.

In addition to SQL statements, for JSON collections and documents, you can also use the fluent API (i.e., no SQL, dot notation) using SODA for Java with JavaScript, the beauty of Nashorn (see SODAjs.md for more details).

For JavaScript Stored Procedures, the steps are very simple

1) create/design your JavaScript function in a file

2) load the JavaScript file into your database schema using the loadjava utility (DBMSJAVASCRIPT role required)

3) invoke it using (i) either DBMS_JAVASCRIPT.run(<JS file>) or (ii) DbmsJavaScript.run Java call, or (iii) using javax.script API

[See my blog post for more details](http://db360.blogspot.com/search?updated-max=2016-11-09T08:41:00-08:00&max-results=3)

[Documentation](http://bit.ly/2nstiYQ)

[White paper](http://bit.ly/2orH5jf) What's in Oracle database 12c Release 2 for Java & JavaScript Developers?

[Community Forum](https://community.oracle.com/community/database/developer-tools/jvm)

The embedded JVM in Oracle database 12 Release 2 (DB 12.2.0.1) supports Java SE 8 therefore the Nashorn engine.

* **load the JavaScript file in the database as a Java Resource**

loadjava -v -u username/password hello.js <-- replace hello.js by your JS file

* **Run/Execute the file previously loaded using one of the following 3 methods**

a) Running JavaScript in the Database using DBMS_JAVA.JAVASCRIPT.RUN Procedure

From SQL or PL/SQL

SQL>set serveroutput on

SQL>call dbms_java.set_output(20000);

SQL>call dbms_javascript.run("hello.js");

b) Running JavaScript in the Database using DbmsJavaScript.run Java call

From Java, running in the database (OJVM)

import oracle.aurora.rdbms.DbmsJavaScript;

…

DbmsJavaScript.run("hello.js");

c) Running JavaScript in the Database using the javax.script API

This approach consists in 4 simple steps (described hereafter) and gives you more flexibility, specifically for functions or procedures accepting a variable number of parameters and/or returning value(s).

Notes: The direct invocation of Nashorn classes is restricted in Oracle JVM. All scripting mode extensions are disabled in Oracle JVM.

* **Instantiate a script manager**

import javax.script.*;

import java.net.*;

import java.io.*;

...

ScriptEngineManager factory = new ScriptEngineManager();

* ** 1.Create an engine**

ScriptEngine engine = factory.getEngineByName("myJSengine");

* ** 2.Pass your resource stream reader as the argument to the eval method of the engine**

URL url =

Thread.currentThread().getContextClassLoader().getResource("hello.js");

engine.eval(new InputStreamReader(url.openStream()));

...

* ** 3.Invoke a function of the JavaScript code

Invocable invocable = (Invocable) engine;

Object selectResult =

invocable.invokeFunction("selectQuery", inputId);

The furnished InvokeScript.java has all these steps.

The signature may differ depending on your input parameters and return values.

The following SQL script creates the Java class in your schema

create or replace and compile java resource named "InvokeScript" as

@InvokeScript.java

/

Alrnatively you can simply load the Java class in your schema using

loadjava -r -v -user hr/hr InvokeScript.java

CREATE OR REPLACE FUNCTION invokeScriptEval(inputId varchar2) return varchar2 as language java

name 'InvokeScript.eval(java.lang.String) return java.lang.String';

/