- Powered by
- WordPress
-
Calculating sums of interval expressions in Oracle Database 23c
-
Jump-start developing APEX apps using MLE/JavaScript: Containers
Support for In-Database JavaScript is one of the most exciting new features in Oracle Database 23c Free. JavaScript is the first language supported by Oracle Multilingual Engine (MLE), powered by GraalVM. Oracle APEX was one of the first platforms to support server-side JavaScript. If you want to get started developing using MLE and APEX without…
-
Using a proxy with the JavaScript fetch API and UTL_HTTP
This short post details how to use a proxy server for outgoing API requests, covering both UTL_HTTP and the In-Database JavaScript fetch() API. The code in this article was tested on Oracle Database 23ai Free, using the container image from container-registry.oracle.com.
-
Using QuickSQL to generate table DDL and sample data in Oracle Database 23ai without APEX
-
Using faker-js/Faker to generate test data respecting referential integrity in Oracle Database 23c
-
Using faker-js/SimpleFaker to produce test data in Oracle Database 23ai
After returning from an inspiring tech conference last week I had an agenda full of items to research. One of the talks I attended mentioned how simple it was for some popular open-source databases to generate sample data. Performing the same task with the Oracle Database was perceived to be quite tricky. This is only…
-
Configure PDB Lifecycle Management for ORDS 23.3
-
Working with JSON in Multilingual Engine/JavaScript in Oracle Database 23ai Free
-
MLE type mapping: passing JSON to JavaScript functions in Oracle Database 26ai
Everyone knows that JSON is very popular, and that includes its use in databases. Turns out that JavaScript is a popular way for working with JSON. Both can be used in Oracle AI Database 26ai Free. The question quickly arises: how do I pass a JSON variable from SQL or PL/SQL to a JavaScript function?…
-
Dealing securely with state changes in Multilingual Engine for Oracle AI Database 26ai
Most PL/SQL developers are aware of the ORA-04068: existing state of packages has been discarded error as explained by Connor McDonald for example in his excellent post about the topic. The article also explains how to ensure that stateful sessions are optionally terminated in case an ORA-04068 occurs using SESSION_EXIT_ON_PACKAGE_STATE_ERROR, a new-ish initialisation parameter. JavaScript,…
