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 …
AUTO vs ‘Bespoke’ REST Services
The Automatic REST features in ORDS are very handy for getting started quickly with providing REST APIs to your data and stored procedures. Give me the data for an employee. Easy. REST enable the schema. REST enable the table. DO a GET on /ords/schema/table/id. But…I don’t want a ‘null’ in my JSON collection for value pair “commission_pct.” What’s an Oracle …
Oracle REST Data Services: GitHub all the Examples
You can now file bugs, sorry – submit Issues, for me on GitHub 🙂 What We’re Doing The intent is to build a nice library of How-To’s for ORDS. I’ve started with a section on PARAMETERS. ords-demo-parameters Build scripts to demonstrate working with parameters in your Oracle REST Data Services (ORDS) RESTful Services. This will demonstrate how to: Read a …
Querying the Oracle REST Data Services for your Oracle Database
So you’ve installed ORDS, you’ve REST enabled a schema, and you’ve started publishing some RESTful Services. Now, how do we go about seeing what’s what? You could browse… You could search… Or you could query the data dictionary! I’m going to look at USER_ORDS…stuff. We have _MODULES, _TEMPLATES, and _HANDLERS – most of what you’ll want is there. SELECT name, …
Yet Another REST POST (and GET!): BLOBs
I wrote recently about using REST to upload a file to your table with ORDS. I want to extend that and share more code. I want you to see how to not only load the pics, but then how to get a collection of items, with links to those items, and in this case, also links to the media (pics) …
POST Up a BLOB to an Oracle Table via REST
It seems kind of weird to do a blog post around a feature that’s fairly well documented, but this came up twice this week, so I figured I’d throw it out there. Scenario: I want to post up a record to be inserted into a table. The record will consist of a couple of regular values, but also a file, …
Bulk Load an Oracle Table from CSV via REST
I have 1,500 rows I need to shove into a table. I don’t have access to the database, directly. But my DBA is happy to give me a HTTPS entry point to my data. What do I do? Let’s look at a Low-Code solution: Oracle REST Data Services & Auto REST for tables. With this feature, you can say for …
ORDS: Returning Raw {JSON}
ORDS is nice. It auto-formats your SQL or PL/SQL results and response to JSON before returning to your client or application. But what if you’re response is ALREADY in JSON? Like this: Bad ORDS trying to convert JSON to JSON Good You telling ORDS we’re not just dealing with a CLOB, it’s actually JSON. Here’s that media post… The Media …