You know what SQLcl is. You know what ORDS is. How do those two things go together? Well, in ORDS 17.3 (Early Adopter/BETA!), we offer a new feature that allows you to execute ad hoc SQL and SQL scripts via HTTPS POST calls to ORDS. …
Swagger Doc for ORDS RESTful Services
We’ve just released version 17.3 of Oracle REST Data Services – as an Early Adopter (BETA). Go Download ORDS 17.3 Now. There are 2 major new features, and this post is about one of those: Swagger/OpenAPI style JSON for /metadata_catalog/ calls. Wait, why should I …
More on ORDS 3.0.10 and Auto PLSQL – PACKAGES
We released a new version of ORDS this week, and I blogged about a new feature in that release – Auto PLSQL. In that post, I briefly mentioned packages, but I wanted to take a quick moment to show that ‘live.’ So assuming you have …
Announcing ORDS 3.0.10 and a new feature – Auto PLSQL
New Oracle REST Data Services (ORDS) drop today. Per usual, mostly bug fixes And per usual, sometimes we like to sneak in new features as well, and this release is no different. You can now have ORDS automatically create POST handlers for executing your PL/SQL. …
Developing Oracle REST Data Services with SQL Developer 4.2
One of the new features in version 4.2 of SQL Developer is the ability to work with your ORDS Restful Services directly in the database tree. Here’s a video demo… Features via Screenshot Some of you don’t have access to YouTube at work (or at …
Auto REST with ORDS: An Overview and What’s Next?
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 …
Parameters and Binds for your RESTful Services: RESULTSETs
Yesterday I talked about how to grab the output returned from your stored procedure when executing via Oracle REST Data Services. The example was: INSERT a new record into a table. Return the new employee ID and the total number of employees in the table. …
Parameters and Binds for your RESTful Services
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; …
Working with RESTful Services, BLOBs, and Media Types
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 …
Password Resets No Longer Require a Thick Connection (Oracle Client) in SQL Developer
Thanks to an update in a 12c JDBC driver for Oracle Database, we can now update a password natively, without being connected to the database. Previous to version 4.2 EA2 – users would either have to be connected already OR have an Oracle Client available. …
- Page 1 of 2
- 1
- 2