Dear Experts,
This question is wrt to setting up Proxy Server for an APEX Application.
My current setup
1. Oracle DB ( Inside a firewall, All request to an internet web service will be blocked )
2. Application Server ( Apache Tomcat 9, v.9.0.29 ) . The application server is outside the firewall in DMZ so the APEX application can be accessed from outside.
The Firewall is opened between DB and ORDS deployed on Tomcat.
Other people can access my REST API through server deployed outside firewall - works correct.
But I am not able to use APEX_WEB_SERVICE.MAKE_REST_REQUEST as the DB is behind the firewall.
What configuration do I need to make so the request is triggered from the application server and not from the DB server?
Or
should i configure Apache Tomcat as a proxy server ( If so, can you please point me to any document or what i should search for ? )
What is the industry practice to be followed ?
Thanks in Advance.
Best Regards,
Bala