Current Setup:
- Database Server: Located in the Database Server Zone.
- Application Server: Located in the Application Server Zone, running:
- Oracle APEX 24.2
- ORDS 23.xx
- Tomcat
Problem:
We are successfully calling an external RESTful API using apex_web_service.make_rest_request
from within the database. However, for security reasons, the client does not allow API calls from the database. Instead, they want all external API calls to be made from the application server.
Question:
How can we configure or implement external API calls from the application server zone (where ORDS and Tomcat are installed), rather than from the database server?