APEX_WEB_SERVICE.MAKE_REST_REQUEST BASIC AUTHENTICATION RESULTS IN ORA-29267 ORA-29273
Last updated on JANUARY 18, 2018
Applies to:Oracle Application Express (APEX) - Version 5.0.0.00.31 to 5.1.1 [Release 5]
Oracle Database as a Service - Version N/A and later
Information in this document applies to any platform.
When invoking a rest service (POST) in Application Express to call a webservice that requires basic authentication the following error occurs :
ORA-29273: HTTP request failed
ORA-29267: illegal call
The issue can be reproduced with the following steps:
1. For example :
But the same works fine / gives output when apex.oracle.com or oracle.com is called from the request.
2. Try to call the same web service from APEX GUI with a POST.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms