Author: Chris
-
The one ORDS command you NEED to know!
ords config list –include-defaults That’s it. Goodbye! I’m kidding, there’s more. But if you don’t feel like reading anymore, bookmark this post and return when you’re ready. Assuming you have ORDS installed, you too can execute the ords config list –include-defaults command to reveal almost all the configuration settings for your ORDS installation. Here is…
Written by
-
ORDS, JavaScript, the Fetch API, and HTML
I found JavaScript and HTML code here and here and “remixed” it to work with one of my sample ORDS APIs. Here is the result: Impressive, no? Care to try it out? Read on friend! References I’ll front load with all the necessary stuff. That way, you can bounce if you don’t feel like reading.…
Written by
-
Tinkering: a SQL script for the ORDS_ADMIN.ENABLE_SCHEMA procedure
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…
Written by
-
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…
Written by
-
Podman container is unhealthy with Oracle database images
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…
Written by
-
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.…
Written by
-
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…
Written by
-
ORDS, SQLcl, APEX via YUM and DNF
TL;DR BREAKING NEWS!! APEX packages with ORDS and SQLcl now available in Oracle Linux YUM servers and through ULN The deets Here is what you need to know. We are releasing three new APEX (a.k.a. “The Artist formerly known as Oracle Application Express”) packages for the following repositories: NoARCH RPMs One more update! These RPMs…
Written by
-
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…
Written by
-
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…
Written by