APEX_WEB_SERVICE.MAKE_REST_REQUEST in Exadata Express or Database Cloud Schema Service Fails with: ORA-29268: HTTP client error 403 - URLBlocked

(Doc ID 2390708.1)

Last updated on APRIL 24, 2018

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When calling a web service on a third party site using APEX_WEB_SERVICE, the request is failing with the following error:

 ORA-29268: HTTP client error 403 - URLBlocked

Assuming the URL to the web service is: https://foo.example.com, the you can reproduce the error with the following query:
 select apex_web_service.make_rest_request('https://foo.example.com','GET') from dual;

  Error starting at line : 1 in command -
  select apex_web_service.make_rest_request('https://foo.example.com','GET') from dual;


  Error report -
  ORA-29273: HTTP request failed
  ORA-29268: HTTP client error 403 - URLBlocked
  ORA-06512: at "SYS.UTL_HTTP", line 380
  ORA-06512: at "SYS.UTL_HTTP", line 1127
  ORA-06512: at "APEX_050100.WWV_FLOW_WEB_SERVICES", line 691
  ORA-06512: at "APEX_050100.WWV_FLOW_WEB_SERVICES", line 910
  ORA-06512: at "APEX_050100.WWV_FLOW_WEBSERVICES_API", line 245
  ORA-06512: at line 1

What is the cause of this error in Schema Service / Exadata Express Cloud Service?

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