APEX_WEB_SERVICE.MAKE_REST_REQUEST Returns Data in Unreadable Format (Doc ID 2179960.1)

Last updated on AUGUST 09, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 5.0 and later
Oracle Database Cloud Service - S5 - Version N/A and later
Oracle Database Cloud Service - S20 - Version N/A and later
Oracle Database Cloud Service - S50 - Version N/A and later
Information in this document applies to any platform.

Symptoms

When running a REST request using APEX_WEB_SERVICE.MAKE_REST_REQUEST response received is unreadable. This can be seen when running the request in SQL Workshop > SQL Commands
When the same request is executed via curl, the data is returned as expected.

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