APEX_WEB_SERVICE.MAKE_REST_REQUEST Fails To Transmit Last Byte Of P_BODY_BLOB And Returns The Error ORA-29273
(Doc ID 2466000.1)
Last updated on APRIL 02, 2019
Applies to:Oracle Application Express (APEX) - Version 5.1.3.00.05 and later
Information in this document applies to any platform.
Calling apex_web_service.make_rest_request to upload a PDF file with the p_body_blob parameter. The server sends back data in JSON format which is captured in a CLOB. This works except when the file the user is uploading is (48*n)+1 bytes in size (e.g 49, 97,145 bytes etc.) the request fails with the following errors:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-29259: end-of-input reached.
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