The embedded JVM runs Java code in user session (within the dedicated or shared server), in the same memory space as SQL and PL/SQL. These Java modules can be invoked by any database client, similarly to PL/SQL modules.
|OJVM is available in Non-managed Database Cloud Services including DBCS, Database Service on OCI etc.
|Java 8 exclusively (Java 7 End of Public Updates was April 2015)
|during patching in RAC environments: for older releases, see MOS Note 2217053.1 for the conditional rolling patch
|Web Services Callout
|(SOAP and REST):see Database Web Services
|JIT, memory manager (on-going infrastructure enhancements)
|Integration with Java Debug Wire Protocol (JDWP)
|The maximum length of a SQL identifier is now 128 bytes.
In-place processing of large datasets (batch operations, LOBs, JSON, XML) without incurring network traffic; In other words, no data shipping. Here are some use cases:
|Micro services and/or Stored procedures/functions for in-place data processing
|using the server-side type 2 JDBC driver
|Extending Oracle database with Java libraries
|e.g., SODA for Java, Hive client, and so on
|JDBC Callout to non-Oracle RDBMS
|Support JVM languages
|Scala, Jython, JRuby, Clojure, and Kotlin
|Calling out to external Web Services (REST, SOAP)
|See the OJVMWCU utility in the doc
|In-place indexing using Lucene and Solr
A new utility Oracle Web Services Callout Utility (OJVMWCU) which accepts WSDL (SOAP Web Services) as well as WADL (Restful Web Services) and additional parameters then retrieves the Web Services client proxy, loads it in the database and generates the wrapper for calling out the Web Service from SQL and PL/SQL.