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

ORDS Standalone: specifying a response header with jetty.xml

NOTE: This article shows how to include a jetty.xml file in your ORDS Standalone deployment, so a user-defined response header is provided with each HTTP response. I’m also requesting that all or some of what you see below make it into our docs. The following article picks up from where this one left off. NOTE: … Read more

ORDS Standalone access logs: Jetty and customizing with XML

Did you know that you can very quickly and easily enable access logging when you are running ORDS in standalone mode (i.e., when using the embedded Jetty server)? FYI: This article is an excerpt from a living document I’ve been working on dedicated to ORDS installation, configuration, and usage (from the development/developer’s perspective). And in … Read more

ORDS Configuration options: about HTTP error responses

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

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

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

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

How to kill an ORDS process

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

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

See you at Oracle Cloud World 2024

Are you going? If so, great! I’ve taken the liberty of hand-picking and listing the sessions where our team will be: The sessions I’m most excited about are the two ORDS-based sample applications. We have one that our development team created (that’s the React one) and another Python one that was mostly (with a lot … Read more