Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change the base URL of a web service

Paul JorstadJan 13 2021

We have four parallell environments for Apex and Ords: Dev, Test, QA and Prod. We develop the web services in ords, and develop apps in Apex that uses those Ords endpoints. The Apex apps in Dev, should use the Ords endpoints in Dev, and so on. So when I export an Apex app from Dev to Test, I would like that to use the Ords Test endpoint. But the Rest Data Source is specified with a remote server, so that needs to change when the app is installed in Test. The question is how to do that dynamic as we use Team City to install both Apex and Ords to all environments. I have tried to run a post-update script that changes APEX_200200.WWV_REMOTE_SERVERS.BASE_URL, but that does not work, I get a ORA-29263: HTTP protocol error. The Apex app in test works fine when exported and installed normally, but it then points to Ords Dev.
Any ideas of how to handle this?
Apex 20.2 and Ords 20.3

Comments
Post Details
Added on Jan 13 2021
5 comments
1,279 views