Oracle Database Development

Contact us

ORDS

  • Let’s talk about ORDS IX

    Let’s talk about ORDS IX

    This post is part of a series that starts with this post. Withy having looked at a bunch of things we can do with something as simple as an Auto-REST enabled view up to and including adding security, I just want to finish off with showing that having a view in the first place is…

    Read more: Let’s talk about ORDS IX

  • Let’s talk about ORDS VIII

    This post is part of a series that starts with this post. In the last post we made the service secure beyond all recognition (sebar 🙂 ) or maybe better expressed as so secure that nobody has access. In this post we’ll look at how to set up access to it to allow just those…

    Read more: Let’s talk about ORDS VIII

  • Let’s talk about ORDS VII

    This post is part of a series that starts with this post. Having gone through much of what can be done with a basic REST-service earlier in this series, it is time to look at securing the service. When you can access a service with noting noire than just the URL, then so can anyone…

    Read more: Let’s talk about ORDS VII

  • Let’s talk about ORDS VI

    This post is part of a series that starts with this post. It is time to turn to query parameters. It expands on the end point to allow slicing and dicing what we get back. Or in other words it allows projection. Or in layman terms, you can supply a where-clause expressed in jSON. You…

    Read more: Let’s talk about ORDS VI

  • Let’s talk about ORDS V

    This post is part of a series that starts with this post. In the last post we covered how to get the JSON-data returned from a REST-call converted back over to be represented as the rows and columns we are used to work with in the database. We’ll now take a look at how paging…

    Read more: Let’s talk about ORDS V

  • Lets talk about ORDS IV

    This post is part of a series that starts with this post. Having seen REST-calls from the database to get the raw JSON-response it is time to look at how it can be transformed into separate columns. This is the SQL we use to get data split up. OBJECT_ID OWNER OBJECT_NAME ——— —— ———————– 134…

    Read more: Lets talk about ORDS IV

  • Let’s talk about ORDS III

    This post is part of a series that starts with this post. Now that we have seen various ways to get data and validate the REST-service working we can move on to implement access from within an Oracle database. I find validating outside the database as the first step to be very valuable. If you…

    Read more: Let’s talk about ORDS III

  • Let’s talk about ORDS II

    This post is part of a series that starts with this post. Now that we have a restenabled view and we can get data from ut with a basic cURL call, let’s look at more ways to make that call and view the response. But before those calls, lets look at what data we actually…

    Read more: Let’s talk about ORDS II

  • Let’s talk about ORDS I

    I recently started looking into a problem at work with getting security added to our setup with views making REST-calls to work as if they were served with a database link. In that work I started from scratch adding one piece at a time to make sure I could troubleshoot it. In doing so I…

    Read more: Let’s talk about ORDS I
  • ,

    ORDS REST services work but APEX does not

    This is an odd situation, most people are probably struggling more with getting REST to work than to get installed APEX to come up with the login. I encountered an odd situation recently where REST worked, SQL Developer Web worked but APEX did not. Many attempts to install and uninstall ORDS and we were still…

    Read more: ORDS REST services work but APEX does not

Subscribe

Sign up with your email address to receive our weekly news




Latest news

Categories

Search