Jenkins Pipeline: Loop Multiple Databases
Here is an example for using Jenkins to loop through multiple Oracle databases (pluggable databases in this case), and execute
Read more
Oracle Developement
APEX: Fetch CLOB data via AJAX callback.
In my use case, I needed to fetch data (JSON) larger than 32k into a JavaScript variable. In APEX versions
Read moreTerraforming from CSV
It is often easier to collect resource information for Terraform through spreadsheets. In this example, I’ll build a number of
Read moreTerraform Import OCI Resources
Terraform allows you to re-create a state file (terraform.tfstate) with the import command. For the import, you need to specify
Read more
Oracle Magazine: Voice Assistants
Here is a reblog of an Oracle Magazine article for which I was interviewed:https://blogs.oracle.com/oraclemagazine/hey%2c-data-experts%3a-voice-assistants-are-calling-your-name
Read more
OCI Command Line Interface (CLI) Basics
The OCI Command Line Interface (CLI), is a Python-based command line interpreter, that lets you interact with the Oracle Cloud
Read more
ORA-12545 When running Oracle inside Docker
When trying to make an http request from my Oracle database running inside a Docker container, I received the following error:
Read moreBuilding a Oracle 12.2 Docker Image
…or a 12.2…or a 11.2 image… Docker installation instructions for RHEL 7. To quickly build an Oracle database Docker image, you
Read moreReblog: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7
Here is a nice guide for a full-stack APEX configuration: http://dsavenko.me/oracledb-apex-ords-tomcat-httpd-centos7-all-in-one-guide-introduction/
Read moreQuick & Dirty: Populate number array from string.
Here is a quick way to convert a list of colon separated numbers into a number array: declare l_list_of_numbers varchar2(32767)
Read more