Short, concise, and to the point. What you covered in 6 minutes others would take couple of hours. If only all TH-cam video/content creators can learn from you how to explain concepts in a short amount of time.
Thanks for sharing so much valuable tutorial session, kuddos to entire team. One quick question to audience: any user case or real time projects example would be very helpful . Any security concern as there is db layer just after ords , any extra layer we should add for security or data validation. Please try to answer, anyone please.🙏
thank you for your efforts... I saw 2 topics in Oracle Apex forum for how to create and consume API's for master-detail data, is there any possibility we can create and consume API's for a master-detail data? I am struggling for it and not yet found any solution.
Is ORDS free ?, here in my company we want to develop our own API using ORDS but our management is afraid of licensing. we have checked with one of the oracle sales rep and he is suggesting to buy SOA suite. please clarify
Bloody sales people. 😒 ORDS, like APEX, is free. You can run it in production for nothing. All releases are public downloads. There are no patches hidden behind support paywalls. If you were to run it on WebLogic, you would have to pay for the WebLogic instance, but I always run it in Tomcat or in standalone mode, so there are no costs associated with ORDS.
It is either SQL*Plus (the main command line utility for Oracle), or SQLcl, the newer Java-based command line utility. You could do it from any database tool. Something like SQL Developer from Oracle would work fine. I use the command line tool to keep the videos simple.
There are a variety of ways to do this. A post can still be bound to a query to produce output. It can be bound to a stored procedure with output parameters, which are defined as ORDS out parameters. It can also be done manually using the HTP packages. There are examples of these on my website. oracle-base.com/articles/misc/articles-misc#ords
I did follow the same procedure but I’m getting “401 unauthorised “ error when I tried to test the API.. I’m sure that something is missing, donno what it is.. any help would be much appreciated
I would only expect to see that message if you have tried to enable authentication on the web service. I would suggest you remove the service and try again without enabling authentication.
Short, concise, and to the point. What you covered in 6 minutes others would take couple of hours. If only all TH-cam video/content creators can learn from you how to explain concepts in a short amount of time.
So there is no more need to build and maintain a separate technological stack for exposing my PL/SQL backend to the world? That's awesome!!!!
Great explanation Tim. Very useful information for Developers.
Thanks for sharing so much valuable tutorial session, kuddos to entire team. One quick question to audience: any user case or real time projects example would be very helpful . Any security concern as there is db layer just after ords , any extra layer we should add for security or data validation. Please try to answer, anyone please.🙏
thank you for your efforts... I saw 2 topics in Oracle Apex forum for how to create and consume API's for master-detail data, is there any possibility we can create and consume API's for a master-detail data? I am struggling for it and not yet found any solution.
Excellent and saved me a lot of hours. Thanks a lot.
Is ORDS free ?, here in my company we want to develop our own API using ORDS but our management is afraid of licensing. we have checked with one of the oracle sales rep and he is suggesting to buy SOA suite. please clarify
Bloody sales people. 😒 ORDS, like APEX, is free. You can run it in production for nothing. All releases are public downloads. There are no patches hidden behind support paywalls. If you were to run it on WebLogic, you would have to pay for the WebLogic instance, but I always run it in Tomcat or in standalone mode, so there are no costs associated with ORDS.
@@oracle-base That's very much helpful, Thank you Tim!
1:07 where are you in there? What is command-interface? Is it from Oracle?
It is either SQL*Plus (the main command line utility for Oracle), or SQLcl, the newer Java-based command line utility. You could do it from any database tool. Something like SQL Developer from Oracle would work fine. I use the command line tool to keep the videos simple.
Hi, this link is broken: Oracle REST Data Services (ORDS) : Create Basic RESTful Web Services Using PL/SQL
Missing one letter of the end of the URL. Sorry. Fixed now.
How can we set a return document in case of POST?
There are a variety of ways to do this. A post can still be bound to a query to produce output. It can be bound to a stored procedure with output parameters, which are defined as ORDS out parameters. It can also be done manually using the HTP packages. There are examples of these on my website.
oracle-base.com/articles/misc/articles-misc#ords
Why does this video doesn't have more likes?
It's a small channel, and when I look at lots of other Oracle channels, engagement is pretty low. 😉
I did follow the same procedure but I’m getting “401 unauthorised “ error when I tried to test the API.. I’m sure that something is missing, donno what it is.. any help would be much appreciated
Is someone helping you?
I would only expect to see that message if you have tried to enable authentication on the web service. I would suggest you remove the service and try again without enabling authentication.
Does it work on HTTPS protocol?
Yes. ORDS works with HTTPS and HTTP.
what is the source_type here?
You will see each example has the source_type defined. It depends on the service which is used.