I need to link Appery DB to Oracle database and use APEX to design an interface such that users can query, update the mobile App DB from Oracle as well as Oracle DB can be updated from the mobile App.
In APEX, I build REST service, in which I use the URI with GET method:
And I added the header:
When I run the query in the APEX where I insert the Database-Id, APEX shows the table/collection Outlet_Details in JSON format. However, not the entire table is shown due to, I think, the length of CLOB data type.
Now my main problem is I need to query this table/collection called Outlet_Details by a column named: _id. So when I use the following URI:
and add another header called _id
It does not return anything no matter what the _id value I insert. So my question, is the method I followed correct? If not, what is missing? and is there any reference to query and update Appery DB from different DB?