Tinkering: a SQL script for the ORDS_ADMIN.ENABLE_SCHEMA procedure

initial-input-section-of-script-vs-code-chris-hoina-senior-product-manager-ords-oracle-rest-apis-database-tools-podman

Post-ORDS installation Once you’ve installed ORDS, you need to REST-enable your schema before taking advantage of ORDS (I used to forget this step, but now it’s like second nature). RESOURCES: I’ve discussed ORDS installation here and here. I’d check both pages if you’re unfamiliar with it or want a refresher. ORDS.ENABLE_SCHEMA / ADMIN_ORDS.ENABLE_SCHEMA While logged into your … Read more

ORDS install considerations: choosing the correct host, port, service name, and pluggable database when the database is in a podman container

The other day, I wrote about how I had to start from scratch on my podman containers 😢. I’m now at the step where I need to reinstall ORDS in these two new database containers (21c and 23c). And since I’m doing this install yet again, I figured I would point out some things I’ve … Read more

Podman container is unhealthy with Oracle database images

podman-machine-inspect-chris-hoina-senior-product-manager-ords-database-tools-oracle

Problem Description You’re working with podman containers (maybe like me – the ones from the Oracle Container Registry), and when you execute the podman ps command, you see something like this in the standard output: In this case, I already had another container with an Oracle 21c database; that one was healthy. I previously wrote up a … Read more

HELP!! parse error: Invalid numeric literal at line x, column x?! It’s not your Oracle REST API!!

A while back (yesterday), I penned a blog post highlighting the ORDS REST-Enabled SQL Service. And in that blog, I displayed the output of a cURL command. A cURL command I issued to an ORDS REST-Enabled SQL Service endpoint. Unfortunately, it was very messy and very unreadable. I mentioned that I would fix it later. … Read more

A quick ORDS REST-Enabled SQL Service example

I promise this post will connect back to an overarching theme. But for now, I want to show how you can take a SQL query and use that in combination with the ORDS REST-Enabled SQL Service to request data from a database table. The SQL query Here is the SQL query I’m using: The SQL … Read more

ETags and Oracle REST APIs

About this post I explore ETags and how they can be used in cURL commands when interacting with Oracle REST APIs. I also discuss some of the performance benefits of using ETags. This is not exhaustive, but I hope it introduces you to ETags or reminds you of their existence! But first… LATE-BREAKING NEWS!! A … Read more

User Guide: Oracle database in a Podman container, install ORDS locally, and access a SQL Worksheet on localhost

Summary The title says it all. I’ve run through this about ten times now. But I’ll show you how to start a Podman container (with a volume attached) and install ORDS on your local machine. And then, once installed, we’ll create and REST-enable a user so that the user can take full advantage of Oracle … Read more

Oracle Database REST APIs and Apple Automator Folder Actions

The plan was to create an ORACLE REST endpoint and then POST a CSV file to that auto-REST enabled table (you can see how I did that here, in section two of my most recent article). But, instead of doing this manually, I wanted to automate this POST request using Apple’s Automator application… Me…two paragraphs … Read more

Python and the Oracle Autonomous Database: Three Ways to Connect

summary-outut-from-sql-query-in-test1-python-file-chris-hoina-senior-product-manager-ords-oracle-rest-apis-autonomous-database-database-actions

Watch the deep dive videos: Part I Part II Part III Welcome back I finally had a break in my PM duties to share a small afternoon project [I started a few weeks ago]. I challenged myself to a brief Python coding exercise. I wanted to develop some code that allowed me to connect to … Read more