ORDS, RESTful Services, and $URI

thatjeffsmith ORDS 5 Comments

Someone asked: I see reference to a ‘$URI’ in an ORDS GET Handler example, can you explain what this is? Yes. Or, I can with the help of some of our DOCS. The appropriate section would be: Columns in result sets whose first character is $ are given special treatment, they are assumed to denote columns that must be transformed …

Auto REST with ORDS: An Overview and What’s Next?

thatjeffsmith ORDS 0 Comments

In the current issue of Oracle Magazine, you can read all about how to get started with the Auto REST feature of Oracle REST Data Services…or in other words, how to automatically make Tables and Views available via REST APIs. A table or view is very easy to consider as a resource in the REST model. What ORDS does is …

Parameters and Binds for your RESTful Services

thatjeffsmith ORDS 0 Comments

I have a very simple, and not very elegant stored procedure. CREATE OR REPLACE PROCEDURE ADD_EMP ( P_EMP_NAME IN SIMPLE_EMP.name%TYPE, P_EMP_SALARY IN SIMPLE_EMP.SALARY%TYPE, P_OUT_ID OUT SIMPLE_EMP.id%TYPE, P_OUT_TOTAL OUT INTEGER ) AS BEGIN INSERT INTO SIMPLE_EMP (name, SALARY) VALUES (P_EMP_NAME, P_EMP_SALARY) RETURN id INTO P_OUT_ID;   SELECT COUNT(id) INTO P_OUT_TOTAL FROM SIMPLE_EMP;   EXCEPTION WHEN OTHERS THEN HTP.print(SQLERRM); END; Sidebar: Like, …

oracle rest data services modules

Working with RESTful Services, BLOBs, and Media Types

thatjeffsmith ORDS 2 Comments

Let’s say you have some files, stored as BLOBs, in your database, and you want to make them available via REST. So of course you install Oracle REST Data Services, and now you have two options: REST Enable the table or Deploy a custom RESTful service With the first option, I get an ‘automatic’ REST endpoint for my resource, which …

REST Enabling Your Tables: Insert Rows via POST

thatjeffsmith ORDS 9 Comments

One of the coolest features of Oracle REST Data Services v3.0 and higher, is the ability to REST enable your Oracle tables and views. You get a full REST api on your table – INSERT, UPDATE, DELETE, Select with or without predicates and sorting, and getting metadata. You can also batch load records. I’ve talked about the SELECT and GET …

Creating an Oracle REST Data Services User with the ‘SQL Developer’ Role

thatjeffsmith ORDS 17 Comments

Want to publish some RESTful services using SQL Developer and Oracle REST Data Services (ORDS)? You’re in luck! View > REST Data Services > Development. Before you can do this, a few things. you’ll need to install and run ORDS you’ll need to REST enable a schema you’ll need to have created an ORDS user with the ‘SQL Developer’ role …