My Oracle Support Banner

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.

Symptoms

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.

Cause

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
Symptoms
Cause
Solution
References


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