Hello Community,
I am facing an issue while calling an external REST API from Oracle APEX.
Environment:
- Oracle APEX: 23.x
- Database: Autonomous Database on OCI
- Feature Used: Web Source Module / APEX_WEB_SERVICE
Problem:
While invoking a REST API from APEX, I am getting the following error:
ORA-29273: HTTP request failed
What I tried:
- Verified the REST endpoint is accessible from browser
- Checked request headers and payload
- Tested API using Postman (working fine)
Root Cause:
The issue was related to missing Network ACL / Wallet configuration, which prevented APEX from making outbound HTTPS calls.
Solution:
1. Created an Oracle Wallet and uploaded required certificates.
2. Configured ACL to allow outbound network access.
3. Verified APEX instance parameters.
4. Retested the REST call – working successfully.
Learning:
For external API calls from APEX, proper network access and SSL configuration is mandatory, especially on Autonomous DB in OCI.
Sharing this in case it helps others facing similar issues.
Thanks!
Jitendra Narayan Gupta