Learning

ORDS Configuration options: about HTTP error responses

by

Reading docs can be hard We send you poor folks to our documentation, and sometimes, it’s a section we haven’t reviewed in quite some time! I don’t think this is specific to any one organization. But over the years, details get lost, forgotten, or stored in an obscure guide section, only to be reviewed once … Read more

Microsoft Entra OAuth2.0 JWTs and ORDS secure APIs Tutorial: Configuration and Testing

by

Since ORDS first introduced support for authenticating with JWTs, there have been many questions surrounding configuration and testing. In this example, I cover, from start to finish: If this sounds like what you are looking for, then read on. There’s a lot to cover here, so there’s no faffing about on this one. Let’s go! … Read more

New ORDS feature: handling multiple files from a multipart/form-data POST request

by

A new feature An ORDS user (or application) can now upload multiple files as part of a multipart/form-data POST request under various conditions. How can this be achieved with an ORDS endpoint? NOTE: Before you continue, it might be helpful to refresh your memory on, or learn more about multipart/form-data as a Content-Type. Details here. … Read more

How to kill an ORDS process

by

How do I “kill” an ORDS process? FYI: This was all done on a MacBook, so…this may differ on a PC or Linux machine. Apologies m’Lord… Here are the options I’ve found to “kill” an ORDS process: It looks like we’ve included in our docs how to start ORDS (with the ords serve command), but … Read more

Extending ORDS with a Java plugin

by

About this article This article is a walkthrough and overview of setting up the example Java plugin that ships with ORDS. These plugins allow you to add functionalities and capabilities above what is possible with a standard ORDS configuration. In this example, the plugin allows you to use a name as a query parameter in an HTTP … Read more

Random Access Memories: ORDS and JWTs

by

EXTRA EXTRA! ORDS now supports JSON Web Tokens (JWTs). You can find most of the details in the OAuth PL/SQL Package Reference chapter of the ORDS Developer’s Guide. ORDS JWT OAUTH parameters You’ll notice two new procedures in that package: OAUTH.CREATE_JWT_PROFILE and OAUTH.DELETE_JWT_PROFILE. After getting acquainted with them, I wanted to highlight three parameters of … Read more

Python script to retrieve objects from Oracle Cloud Bucket

by

For…reasons, I needed a way to retrieve all the .CSV files in a regional bucket in Oracle Cloud Object Storage, located at this address: https://objectstorage.us-phoenix-1.oraclecloud.com/n/dwcsprod/b/moviestream_data_load_workshop_20210709/o You can visit it; we use it for one of our LiveLabs (this one), so I’m sure it will stay live for a while 😘. Once there, you’ll see all … Read more

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

by

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

The one ORDS command you NEED to know!

by

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

by

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