Below you'll find a list of all posts that have been tagged as “ORDS”
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, …
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) …
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 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 …
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. No access to the database via the Listener required. Wanna play? Maybe the easiest way …
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 care about REST? The Movie Screenshots for Those that Can’t do YouTube at Work It’s …
Think building REST Services for Oracle Database is hard? Tooling around SQL Developer, browsing data, and thought to yourself, that would make a great Web Service? Now, you can quickly publish the query behind a grid to a new or existing ORDS Module. Just right-click! (well wait a second, you need ORDS installed and configured for your database. And the …
I get the impression that many of you have thought about getting more acquainted with our development tools and platforms here at Oracle. But I ALSO get the impression that many of you just haven’t had the time. So, I’m officially inviting you to participate in a series of upcoming webinars I’ll be hosting. How they ‘work’ We’ll use a …
Time to download! Mostly bug fixes. the frequent ‘connection reset’ message should be GONE entering text data in a data grid cell and the cursor doesn’t advance should be FIXED having a @ or a ; in a comment in your query should work AGAIN many, many more bug fixes – see the release notes for details SQLcl updated, more …
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 HR installed somewhere and HR is REST enabled, let’s build this package. CREATE OR REPLACE …