3 Replies Latest reply on Jul 22, 2020 12:58 PM by EJ-Egyed

routine on apex server that update a remote db

Kstore Jul 21, 2020 8:15 AM

Hello !!!

Can I create a routine on my apex server that update a remote db?

Thank's for Response ...

Bye

1. Re: routine on apex server that update a remote db

thatJeffSmith-Oracle Jul 21, 2020 9:06 AM (in response to Kstore)

Sure, a db_link or ORDS running on the remote DB would make that possible and fairly easy
Like Show 0 Likes(0)

Actions
2. Re: routine on apex server that update a remote db

Kstore Jul 22, 2020 9:37 AM (in response to thatJeffSmith-Oracle)

Excuse me ....
we must connect to an API of another application and running not in ORACLE db
so we cannot use DBLINK ma only read/write the API of the other application..

There i a way to interface APEX/ORDS with an API of other application ???

from our webservice in APEX/ORD we want to call an endpoint of an other web service.

Thank you Very Mutch ...
Like Show 0 Likes(0)

Actions
3. Re: routine on apex server that update a remote db

EJ-Egyed Jul 22, 2020 12:58 PM (in response to Kstore)

APEX has the ability to create a Web Source that you can use to interact with external APIs. Once the Web Source is defined, you will be able to reference the Web Source within the page.
Like Show 0 Likes(0)

Actions