Oracle REST Data Services version 18.4 and your bug fixes are now available.
How to Export Your RESTful Services
You’re using ORDS. You’ve written some web services. Now you need to control the underlying PL/SQL source. How do I get the code out? There’s a few ways. 1. Use SQL Developer On the Module, mouse right click. 2. Use SQLcl The REST command will get what you want. If you want this in a file, just use the SPOOL …
Executing PL/SQL with Array INPUTS via ORDS
Today’s question: Does ORDS support PUT/POST with Array or Cursor as part of the payload? I need to call a procedure with 1 IN parameter defined as Array or Cursor (for a list of IDs). The answer is Yes, and I’ll show with the AUTO Feature. The Underlying Code: CREATE TABLE CONTACT ( NAME VARCHAR2(30 BYTE), PHONE VARCHAR2(20 BYTE), SOMETHING …
Building a Web Service for Uploading and Downloading Files: The Video!
This video is a bit longer than most, but I’ll show you how to deploy a web service to: get a list of files from a table – stored as BLOBs get individual file details download/render the file using the mime type how to upload a file how to generate LINKs in your {json} responses how to set the HTTP …
Preventing 500 Status Codes with Oracle REST Data Services
In my Oracle REST Services Demos I always show things working exactly as planned. But what happens when your user does something your program doesn’t expect? Or what happens when you code does something you don’t expect? In the web (HTTP) world, you get a 500. 10.5.1 500 Internal Server Error The server encountered an unexpected condition which prevented it …
ORDS 18.3: X-ORDS-FORWARD and :BODY_TEXT
The forwarding bit isn’t a new feature, but we have introduced new ORDS response header variables in version 18.3 of ORDS. You can now also read in the body of your request as a CLOB vs a BLOB. This post shows how to take advantage of both features. The only thing ‘new’ here is the name of this ORDS parameter. …
ORDS: The Easy Way to Protect All Services for a REST Enabled Schema
It’s easier to run things unsecured. It’s unconscionable to run things unsecured. DON’T BE THIS GUY. So Let’s Secure My Database and my Web Services So I have a collection of REST enabled objects (tables, view, and procedures) and a SLEW of RESTful Service modules. I want ALL of them locked down. So I need to create a Role and …
Updated Oracle REST Data Services (ORDS) Slides and Video
After presenting this topic a few times over the years, I decided on a different take this Spring: I would start by introducing some requirements for a new project, and how ORDS fits into that and delivers what you need. I’ve also embedded our latest 15 minute video demonstration – enjoy! REST Enabling your Oracle Database (2018 Update) from Jeff …
Executing PL/SQL PACKAGE.PROCEDURE via REST
I don’t normally blog on a Sunday, but I’m confined to my bed/couch for the next few days, so I might as well answer another question! This from the YouTube: “Hi Jeff, Can you please share similar example where REST service is calling a package.procedure with IN and OUT parameters and we can pass IN parameters to get the result?” …
What Happens if I REST Enable a table with no Primary Key in ORDS?
When you AUTO-REST enable table in ORDS, we publish a full API for you: We auto find your Primary Key Column and use that to address particular rows (items) in your table (collection.) But..what happens if you don’t have a primary key? CREATE TABLE no_keys (letter CHAR(1), letters VARCHAR2(25), numbers INTEGER); INSERT INTO no_keys VALUES (’a’, ‘abc’, 1); INSERT …