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