Category: OCI
-
401 Unauthorized invalid_token – troubleshooting Oracle Cloud IAM JWTs with ORDS
Symptoms You are able to request an access token from OCI IAM. Yet, when you issue the subsequent request to your target resource (an ORDS endpoint), you receive the following message (error=”invalid_token”):ย Actions you’ve taken YET…you still receive this error=”invalid_token”ย message, it is quite possible that you have not made the JWK URL publically accessible in…
Written by
-
Configuring OCI IAM Domain JWTs to use with ORDS OAuth2.0 protected APIs
Table of Contents Intended Audience/Purpose Does this describe you? Creating a Domain Configure Client Access Adding an Integrated Application to the Domain Adding the application Configuring OAuth Resource server configuration Client Configuration Issuing a POST request to obtain a JWT Gathering the required values for the request Setting up Postman Requesting the JWT ORDS configuration…
Written by
-
An ORDS GET request to retrieve CGI Environment variables from the PRINT_CGI_ENV PL/SQL procedure
ALERT: This is going to seem extremely out of context! But this post actually loosely relates to the ORDS Pre-hook functions section of our docs. I’m in the process of (1) working on a presentation and (2) updating this section of the docs as well (productivity trifecta for the win!), hence why we are here.…
Written by
-
ORDS 24.3 Release Highlights
Overview There’s plenty to talk about in this release. However, I’m most excited about the performance improvements, ORDS sample applications, and documentation changes. Read on to get the whole story. Enhancements API Performance REST API responses from either AutoREST or customer based modules could see as much as a 30% improvement in response times. About…
Written by
-
Setting up SSH to GitHub git clone into your Oracle Cloud Linux Ubuntu VM with VNC
I’m trying to be as succinct as possible. I just accomplished this but couldn’t find anything that explicitly walked me through how to do it. Here are some assumptions: REMINDER: You are signed in to a Linux machine! The commands you will follow (in GitHub or here) WILL NEED TO BE FOR LINUX! What happened?…
Written by
-
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…
Written by
-
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…
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
-
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…
Written by
-
Python and the Oracle Autonomous Database: Three Ways to Connect
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…
Written by