OCI & ORDS: Setting up your database REST service and securing it with OAUTH2 (no scripts required!)
Intro When building your REST APIs using Oracle Rest Data Services on an Oracle database, APEX can greatly simplify the steps to set up the REST functions we need. APEX leverages ORDS tools to wrap any SQL statement, PL/SQL function or package procedure into a REST call, enabling the client applications to interact with the database using JSON objects and common HTTP verbs/methods such as GET, PUT, POST, DELETE (I call them verbs and methods interchangeably here, but they are, strictly speaking, methods). Well, APEX allows us to wrap a SQL object with a REST call with almost no code. Almost . Because if we need to secure access to our resources using OAUTH2 we eventually need to do some additional configuration steps on the database, and this involves setting up manually some SQL scripts and running them. A few words about OAUTH2 OAUTH2 (or oAuth 2) stands for Open Standard Authorization Framework 2. It's a framework to implement the authorization service (NO...
