Martins Blog

Powered by: WordPress

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 Database 23c
Performance Monitoring for In-Database JavaScript in Oracle Database 23c #JoelKallmanDay
Using the Operating System’s certificate store instead of an Oracle wallet in Oracle AI Database 26ai

Before jumping into the example, it’s worth highlighting an important aspect: security. Therefore you cannot simply write to a file or open a network connection in Oracle AI Database without doing some setup work Developers wishing to perform network I/O via UTL_HTTP for example must define fine-grained access control settings. More realistically, they need to…
Python one-liners: converting markdown to HTML

This has come in handy a number of times. Assuming you have an input file in markdown format and need to convert it to HTML. This is a low-tech solution to the problem, most importantly it is available for MacOS on M1 chips without any further software installation. And yes, it’s not the only solution…
Linting MLE JavaScript Modules in Continuous Integration Pipelines

Continuous Integration (CI) is the process of automatically building and testing your application’s code each time a developer pushes a commit to a remote source-code control repository like GitLab, Jenkins, or GitHub. The use of CI is an integral part of DevOps and can be used to great effect: lead times (e.g. the time it…
Data Access using Java Stored Procedures in Oracle Database

Recently I had to troubleshoot a problem related to Java stored procedures in Oracle Database. SQL access has been a bit slow, and I wanted to create a small test case where my stored procedure accesses information in a table. To my surprise I didn’t find any suitable reference/tutorial so I thought I’d quickly write…
Vagrant Ansible Provisioner: working with the Ansible Inventory – addendum

Recently I wrote a post about one of my dream combinations, Ansible and Vagrant. After hitting the publish button I noticed that there might be a need for a part II – passing complex data types such as lists and dicts to Ansible via a Vagrantfile. I wrote a similar post for when you are…
Ansible tips’n’tricks: gather facts in an ad-hoc fashion

There are times when I really need to get some ansible_facts from a host to work out details about, say the network card, storage, or Linux Distribution to continue coding. And I don’t want to/have the patience to run add a debug step in my Ansible playbook either :) Thankfully Ansible has just the right tool for…