{"id":12931,"date":"2023-11-26T18:56:09","date_gmt":"2023-11-26T17:56:09","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=12931"},"modified":"2023-11-26T18:57:40","modified_gmt":"2023-11-26T17:57:40","slug":"installing-mle-modules-in-the-oracle-database","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/","title":{"rendered":"Installing MLE Modules in the Oracle Database"},"content":{"rendered":"\n

Introduction<\/h2>\n\n\n\n

In my previous blog post<\/a>, I’ve shown how you can deploy an npm module from a URL and a custom ESM module from a local file into a remote Oracle Database 23c using JavaScript and SQLcl. This works well. However, for two MLE modules, I had to write 22 lines of code with duplications. I do not like that. I have therefore developed a small SQLcl custom command that greatly simplifies the installation of MLE modules in the Oracle Database.<\/p>\n\n\n\n

Installing the mle<\/code> Custom Command<\/h2>\n\n\n\n

Start SQLcl and run the following command to install the custom command mle<\/code> in the current session.<\/p>\n\n\n\n

<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
script https:\/\/raw.githubusercontent.com\/PhilippSalvisberg\/mle-sqlcl\/main\/mle.js register<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The SQLcl script command can read a JavaScript file from the local file system or from a URL. If you feel uncomfortable running JavaScript files directly from a URL, you can have a look at the GitHub repo<\/a> first and download and run a chosen version of the script from the local file system.<\/p>\n\n\n\n
The register<\/code> subcommand registers the mle<\/code> script as an SQLcl command. However, this registration is not permanent. It will be lost after closing SQLcl. To make the custom command available in every new SQLcl session add the command above to your login.sql<\/code> or startup.sql<\/code>. SQLcl executes these files on start-up or after establishing a new connection. Just make sure that you have configured the SQLPATH<\/code> environment variable accordingly. <\/p>\n\n\n\n
Providing Help<\/h2>\n\n\n\n
Now you can run the mle<\/code> command like this:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
mle<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Without parameters, an error message is displayed along with information on how to use this command.<\/p>\n\n\n\n
\"Output<\/a><\/figure>\n\n\n\n
Installing Validator<\/h2>\n\n\n\n
Now we know the syntax to install an MLE module from a URL. However, what’s the URL for an npm module? We use the free OpenSource CDN jsDelivr<\/a> for that. They provide a service returning an npm module as an ECMAScript module. The result can be used in a browser and also in an Oracle Database. The URL looks like this:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
https:\/\/esm.run\/npm-package-name@npm-package-version<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
We want to install the current version 13.11.0 of the npm module validator<\/a>. Based on the information provided above our SQLcl command for that looks like this:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
mle install validator_mod https:\/\/esm.run\/validator@13.<\/span>11<\/span>.<\/span>0<\/span> <\/span>13<\/span>.<\/span>11<\/span>.<\/span>0<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
And here is the result in SQLcl :<\/p>\n\n\n\n
\"Output<\/a><\/figure>\n\n\n\n
Please note that the response message by SQLcl 23.3 is not 100% correct for MLE modules. However, our module is installed correctly. We verify that later.<\/p>\n\n\n\n
Maybe you’d like to know what the SQL statement looks like to install this module. The last statement is still in SQLcl’s buffer. Therefore we can type l<\/code> followed by enter<\/code> to see the content of the buffer.<\/p>\n\n\n

\n
<\/i><\/i>SQLcl's buffer<\/div>
<\/p>\n\n\n\n
The first line contains the start of the SQL statement. Lines 2 to 7 are comments generated by jsDelivr. Line 8 contains the complete module. Yes, as a single line. The code is minified. All unnecessary whitespace is gone and internally used identifiers are shortened to save space. On line 9 we would see a JavaScript comment with a pointer to a map file that points to the original, nicely formatted source code. This is interesting when debugging in other environments. It’s currently not used in the database.<\/p>\n\n\n\n
\"SQLcl<\/a><\/figure>\n\n\n
<\/div><\/div>\n
\n<\/div><\/div>\n\n\n\n\n
Querying MLE Modules<\/h2>\n\n\n\n
The following SQL statement shows some data regarding the previously deployed MLE module:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
set<\/span> sqlformat ansiconsole<\/span><\/span>\nselect<\/span> module_name, <\/span>version<\/span>, language_name, <\/span>length<\/span>(module)<\/span><\/span>\n  <\/span>from<\/span> user_mle_modules;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The result in SQLcl looks like this:<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
We see the version of the module and also the size in bytes of the blob column where the module is stored. It is one byte larger than the result of the URL since It contains a final line feed character due to the way we built the SQL statement.<\/p>\n\n\n\n
IMO it is helpful to provide the version of the external ESM as long as there is no proper package registry within the Oracle Database.<\/p>\n\n\n\n
Verifying Installation<\/h2>\n\n\n\n
Let’s write a call specification in order to verify the successful installation of the validator module.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
create or replace<\/span> <\/span>function<\/span> <\/span>is_email<\/span>(<\/span><\/span>\n   in_email <\/span>in<\/span> <\/span>varchar2<\/span><\/span>\n) <\/span>return<\/span> <\/span>boolean<\/span> <\/span>as<\/span> mle module validator_mod <\/span>signature<\/span> <\/span>'default.isEmail(string)'<\/span>;<\/span><\/span>\n\/<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Now we can run the following query to verify e-mail addresses and the installation of the validator module:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
select<\/span> is_email(<\/span>'jane.doe@example.org'<\/span>) <\/span>as<\/span> jane_doe,<\/span><\/span>\n       is_email(<\/span>'john.doe@example'<\/span>) <\/span>as<\/span> john_doe;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
In SQLcl 23.3 the result looks like this (boolean values as 1<\/code> and 0<\/code>):<\/p>\n\n\n\n
\"Result<\/a><\/figure>\n\n\n\n
And in SQL*Plus 23.3 the result looks like this (boolean values as TRUE<\/code> and FALSE<\/code>):<\/p>\n\n\n\n
\"Result<\/a><\/figure>\n\n\n\n
Installing More Modules<\/h2>\n\n\n\n
Let’s install some other modules I find useful. You find them on npm<\/a> if you want to know what they do.<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
mle install sentiment_mod https:\/\/esm.run\/sentiment@5.<\/span>0<\/span>.<\/span>2<\/span> <\/span>5<\/span>.<\/span>0<\/span>.<\/span>22<\/span><\/span>\nmle install jimp_mod https:\/\/esm.run\/jimp@0.<\/span>22<\/span>.<\/span>10<\/span>\/browser\/lib\/jimp.js <\/span>0<\/span>.<\/span>22<\/span>.<\/span>10<\/span><\/span>\nmle install sql_assert_mod https:\/\/esm.run\/<\/span>sql<\/span>-assert@1.<\/span>0<\/span>.<\/span>3<\/span> <\/span>1<\/span>.<\/span>0<\/span>.<\/span>3<\/span><\/span>\nmle install lodash_mod https:\/\/esm.run\/lodash@4.<\/span>17<\/span>.<\/span>21<\/span> <\/span>4<\/span>.<\/span>17<\/span>.<\/span>21<\/span><\/span>\nmle install js_yaml_mod https:\/\/esm.run\/js-yaml@4.<\/span>1<\/span>.<\/span>0<\/span> <\/span>4<\/span>.<\/span>1<\/span>.<\/span>0<\/span><\/span>\nmle install minimist_mod https:\/\/esm.run\/minimist@1.<\/span>2<\/span>.<\/span>8<\/span> <\/span>1<\/span>.<\/span>2<\/span>.<\/span>8<\/span><\/span>\nmle install typeorm_mod https:\/\/esm.run\/typeorm@0.<\/span>3<\/span>.<\/span>17<\/span> <\/span>0<\/span>.<\/span>3<\/span>.<\/span>17<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Installing all modules is just a matter of a few seconds. <\/p>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
Using the SQLcl custom mle<\/code> command to install ECMAScript modules from a file or from a URL is not only easy and fast, but it is also an excellent way to provide tested functionality within the database. <\/p>\n\n\n\n
Technically it should be possible to generate the PL\/SQL call specifications based on the information that is provided for IDEs to better support code completion (type definitions). I hope that Oracle will provide such a feature in one of the coming releases of SQLcl or as part of a dedicated MLE tool (similar to dbjs<\/code> which was part of the experimental version of the MLE back in 2017). Even if I do not want to provide access to all underlying functionality of an MLE module within the database or provide the functionality with the same signature, a PL\/SQL package with all call specifications would simplify the work for a wrapper PL\/SQL package that exposes just the relevant subset in a suitable way for the use in PL\/SQL or SQL.<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction In my previous blog post, I’ve shown how you can deploy an npm module from a URL and a custom ESM module from a local file into a remote Oracle Database 23c using JavaScript and SQLcl. This works well. However, for two MLE modules, I had to write 22 lines of [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":12966,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[135,149,140,13,126],"class_list":["post-12931","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-javascript","tag-mle","tag-oracle-26ai","tag-plsql","tag-sqlcl"],"yoast_head":"\nInstalling MLE Modules in the Oracle Database - Philipp Salvisberg's Blog<\/title>\n<meta name=\"description\" content=\"Using a custom SQLcl command to install ECMAScript modules via file or via URL from npm into the Oracle Database 23c as MLE modules.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing MLE Modules in the Oracle Database - Philipp Salvisberg's Blog\" \/>\n<meta property=\"og:description\" content=\"Using a custom SQLcl command to install ECMAScript modules via file or via URL from npm into the Oracle Database 23c as MLE modules.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Philipp Salvisberg's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-26T17:56:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-26T17:57:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/11\/oracle-database-23c-npm-mle.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1069\" \/>\n\t<meta property=\"og:image:height\" content=\"805\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Philipp Salvisberg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:site\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Philipp Salvisberg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/\"},\"author\":{\"name\":\"Philipp Salvisberg\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"headline\":\"Installing MLE Modules in the Oracle Database\",\"datePublished\":\"2023-11-26T17:56:09+00:00\",\"dateModified\":\"2023-11-26T17:57:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/\"},\"wordCount\":874,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/oracle-database-23c-npm-mle.png\",\"keywords\":[\"JavaScript\",\"MLE\",\"Oracle 26ai\",\"PL\\\/SQL\",\"SQLcl\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/\",\"name\":\"Installing MLE Modules in the Oracle Database - Philipp Salvisberg's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/oracle-database-23c-npm-mle.png\",\"datePublished\":\"2023-11-26T17:56:09+00:00\",\"dateModified\":\"2023-11-26T17:57:40+00:00\",\"description\":\"Using a custom SQLcl command to install ECMAScript modules via file or via URL from npm into the Oracle Database 23c as MLE modules.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/oracle-database-23c-npm-mle.png\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/oracle-database-23c-npm-mle.png\",\"width\":1069,\"height\":805,\"caption\":\"Installing MLE Modules in the Oracle Database 23c\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/11\\\/26\\\/installing-mle-modules-in-the-oracle-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installing MLE Modules in the Oracle Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\",\"name\":\"Philipp Salvisberg's Blog\",\"description\":\"Database-centric development\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\",\"name\":\"Philipp Salvisberg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"width\":400,\"height\":400,\"caption\":\"Philipp Salvisberg\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\"},\"sameAs\":[\"http:\\\/\\\/www.salvis.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Installing MLE Modules in the Oracle Database - Philipp Salvisberg's Blog","description":"Using a custom SQLcl command to install ECMAScript modules via file or via URL from npm into the Oracle Database 23c as MLE modules.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/","og_locale":"en_US","og_type":"article","og_title":"Installing MLE Modules in the Oracle Database - Philipp Salvisberg's Blog","og_description":"Using a custom SQLcl command to install ECMAScript modules via file or via URL from npm into the Oracle Database 23c as MLE modules.","og_url":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/","og_site_name":"Philipp Salvisberg's Blog","article_published_time":"2023-11-26T17:56:09+00:00","article_modified_time":"2023-11-26T17:57:40+00:00","og_image":[{"width":1069,"height":805,"url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/11\/oracle-database-23c-npm-mle.png","type":"image\/png"}],"author":"Philipp Salvisberg","twitter_card":"summary_large_image","twitter_creator":"@phsalvisberg","twitter_site":"@phsalvisberg","twitter_misc":{"Written by":"Philipp Salvisberg","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/#article","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/"},"author":{"name":"Philipp Salvisberg","@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"headline":"Installing MLE Modules in the Oracle Database","datePublished":"2023-11-26T17:56:09+00:00","dateModified":"2023-11-26T17:57:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/"},"wordCount":874,"commentCount":0,"publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/11\/oracle-database-23c-npm-mle.png","keywords":["JavaScript","MLE","Oracle 26ai","PL\/SQL","SQLcl"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/","url":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/","name":"Installing MLE Modules in the Oracle Database - Philipp Salvisberg's Blog","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/#primaryimage"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/11\/oracle-database-23c-npm-mle.png","datePublished":"2023-11-26T17:56:09+00:00","dateModified":"2023-11-26T17:57:40+00:00","description":"Using a custom SQLcl command to install ECMAScript modules via file or via URL from npm into the Oracle Database 23c as MLE modules.","breadcrumb":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/#primaryimage","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/11\/oracle-database-23c-npm-mle.png","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/11\/oracle-database-23c-npm-mle.png","width":1069,"height":805,"caption":"Installing MLE Modules in the Oracle Database 23c"},{"@type":"BreadcrumbList","@id":"https:\/\/www.salvis.com\/blog\/2023\/11\/26\/installing-mle-modules-in-the-oracle-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.salvis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Installing MLE Modules in the Oracle Database"}]},{"@type":"WebSite","@id":"https:\/\/www.salvis.com\/blog\/#website","url":"https:\/\/www.salvis.com\/blog\/","name":"Philipp Salvisberg's Blog","description":"Database-centric development","publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.salvis.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515","name":"Philipp Salvisberg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","width":400,"height":400,"caption":"Philipp Salvisberg"},"logo":{"@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg"},"sameAs":["http:\/\/www.salvis.com\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/12931","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/comments?post=12931"}],"version-history":[{"count":24,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/12931\/revisions"}],"predecessor-version":[{"id":12965,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/12931\/revisions\/12965"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media\/12966"}],"wp:attachment":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media?parent=12931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/categories?post=12931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/tags?post=12931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}