Discussion on "APEX, ORDS, and REST Enabled SQL"

Jon Dixon · 2022-08-25T13:29:54.030Z

Introduction REST Enabled SQL allows you to run DML and DDL statements (via REST) against a remote Oracle database. REST Enabled SQL is made possible by Oracle REST Data Services (ORDS). APEX allows you to define a REST Enabled SQL Service. A REST En...

Hi, great blog. Is it possible to install ords on 11g oracle database? Do I need to install apex on remote database to work it? I would like to do this connection from a APEX on Auonomous Database to a 11g oracle database!

Jon, Thanks for the in detail information, I have followed all the steps and getting error "The URL of this remote server does not point to an REST Enabled SQL Service. Please check the details of your REST Enabled SQL Service definition." even after doing all the setups. Endpoint URL is working fine in postman but not in APEX rest enabled sql services. Any idea?

Here I am trying to connect remote database from primary database APEX

Just to confirm, you have tested REST Enabled SQL on the target instance from Postman using a REST Enabled SQL URL, e.g. example.com/ords/cndemo/_/sql Assuming this is the case, make sure the Schema you are creating your REST Source in can access the target URL. Do you have an Access Control List (ACL) setup? First try accessing using apex_web_service, as suggested here: stackoverflow.com/questions/71315360/why-isnt-my-…

Jon Dixon Thankyou for the quick response. Can you please let me know what would be the username and password in make_rest_request API and Do you have any reference links how to set up PL/SQL Network ACL for the APEX schema user?

Jon, great blog! But I'm not sure this is useful for me to create a REST service to receive as a "callback" the username, the password and other fields at the same time. I need to create a REST Service to receive the status change of an item of another web platform. The endpoint must receive this: { “user”: <user>, “password”: <password>, “idServer”: <idServer>, “idClient”: <idClient>, “idStatusChanged”: <idStatus> } And respond { “notifyResult”: true} or { “notifyResult”: false}

It's possible to use ORDS on this manner?

Thanks a lot!

For sure, you can create an ORDS endpoint that is called by the other platform. The other platform would POST the JSON you describe, perform the appropriate processing, and returns the response you describe. I discuss using ORDS for Webhooks in this post blog.cloudnueva.com/webhooks-and-ords

Jon Dixon Thanks a lot!

Great blog. Yes, REST enabled SQL is a game changer for all enterprise apps going forward.

Discussion

APEX, ORDS, and REST Enabled SQL

Responses(4)

Recent in Forum

Search Hashnode

APEX, ORDS, and REST Enabled SQL

Responses(4)

Recent in Forum