Build an ORDS API Resource Module, GET request with JavaScript fetch, display in HTML

Really trying to optimize SEO with that title 👆🏼! Recap 💡 All the code you’ll see in this post can be found in my moviestreamjs github repository.💡 This post is a continuation of a previous one, which can be found here. In this post, I’ll: If you are coming from the previous related post, then … Read more

Create a view from a JSON Collection and REST-enable it with ORDS

The DBMS_CLOUD PL/SQL Package You can use this PL/SQL procedure (in the DBMS_CLOUD package) along with the file_uri_list URL (seen in the code below) to create and then add JSON documents to a JSON Collection (good info on JSON Collections in the Oracle database). In this example, we call this collection Movie_Collection. 👆🏻 This is … Read more

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 what my configuration…

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. … Read more

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

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 … Read more