My Oracle Support Banner

REST Web Service Does Not Return Data From APEX_WEB_SERVICE.MAKE_REST_REQUEST(), It Gets Errors: ORA-20101 No report bytes were returned, and ORA-06503: PL/SQL: Function returned without value (Doc ID 2863391.1)

Last updated on MAY 04, 2022

Applies to:

Oracle Application Express (APEX) - Version 21.2 and later
APEX Application Development - Version NA and later
Information in this document applies to any platform.


1.- When attempting to call a web service using the APEX_WEB_SERVICE.MAKE_REST_REQUEST function, the following error occurs:

     ORA-20101: No report bytes were returned
     ORA-06503: PL/SQL: Function returned without value

2.- If you try to convert the data to text (XML) format, you get an error message similar to:

     A SOAP 1.2 message is not valid when sent to a SOAP 1.1 only endpoint

3.- Using a web browser, it can be sent the same web service request parameters and prove that a response is getting back with data. This confirms:
     • The web service can be reached
     • The web service is active
     • The credentials to log in to the environment are valid
     • The report exists
     • The user has security access to run the report
     • The report runs
     • Data is returned




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.