Hello,
Can I get some ideas how to accomplish using ORDS and Rest API
We have a schema with set of tables used by a web application , some part of the application and corresponding database tables are moved to cloud based application. Original application is still functional with limited web functionality and its related tables its original schema.
now my problem is I have to access Rest API from new cloud based application and use that data in my original application to make it functional. Most the database related transactions are written in PL/SQL in packages. Now I have to change the PL/SQL logic calling the Rest API .
What are the options for me, I am thinking of following
Call Rest API from oracle and convert the json content into oracle table data fields and store in the database - is it possible solution? if so , how?
or Change the PL/SQL code (which has joins with multiple tables and complex queries) change it in such a way to call Rest API and join with some existing tables in original schema - which I am not sure if possible.