Linux

Life hack: causing utPLSQL to raise an error in case of failed tests

The wonderful Symposium 42 community is always a source of inspiration, kindness and willingness to help.…
Real productivity gains with AI: coding unit tests for your ORDS endpoints

Ever since I first heard about them, I have become a great fan of unit tests,…
Using JSON Schema to validate data submitted to the database via REST Calls

The title’s a mouthful (sorry!), but here’s the core idea: your application exposes REST endpoints through…
Augmenting JSON Relational Duality Views with generated data

A recent forum post inspired this brief article on generating summary data in JSON Relational Duality…
Handling Query Parameters in JavaScript-based ORDS Endpoints

Oracle REST Data Services (ORDS) allows you to REST-enable your Oracle Database. REST is short for…
What’s new with MLE 23.26.0 – support for PL/SQL Collections and Records Pt 3

Oracle AI Database has been released! It ships with a whole raft of cool new features,…
Retrieving the result of a PL/SQL computation in MLE/JavaScript

Recently, while working on a joint project with the APEX team, the need arose to rewrite…
JavaScript showcase: a fun playground environment for MLE/JavaScript in Oracle AI Database 26ai

I’m a huge fan of Oracle’s SQL Developer Extension for VSCode. I use it on a…
What’s new with MLE 23.26.0 – support for PL/SQL Collections and Records Pt 2

Oracle AI Database has been released! It ships with a whole raft of cool new features,…
Does the MLE SQL Driver respect Virtual Private Database policies?

An interesting question came in today and it’s a great opportunity to elaborate a little on…