APEX_WEB_SERVICE.MAKE_REST_REQUEST BASIC AUTHENTICATION RESULTS IN ORA-29267 ORA-29273 (Doc ID 2280378.1)

Last updated on JULY 11, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - 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.

Symptoms

When invoking a rest service (POST) in Application Express to call a webservice that requires basic authentication the following error occurs :

ERROR
-----------------------
ORA-29273: HTTP request failed
ORA-29267: illegal call


The issue can be reproduced with the following steps:

1. For example :

Output: NULL 

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.


Cause

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