Preventing 500 Status Codes with Oracle REST Data Services

thatjeffsmith ORDS 0 Comments

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 …

Updated Oracle REST Data Services (ORDS) Slides and Video

thatjeffsmith ORDS 0 Comments

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

thatjeffsmith ORDS 2 Comments

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?

thatjeffsmith ORDS 1 Comment

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 …

Oracle REST Data Services: GitHub all the Examples

thatjeffsmith ORDS 0 Comments

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 …