Hi all,
When trying to download a picture for insertion into the db, I am getting the following.
The URL is accessible from a normal browser. I have reproduced this problem on both apex.oracle.com and on the Autonomous Cloud.
Is it a bug or am I do something wrong?
Unfortunately, utl_http and httpURIType don't seem to work on the Autonomous Cloud either.
All ideas are welcome.
All the best.
Niall.
declare
v_clob clob;
begin
v_clob := apex_web_service.make_rest_request('https://res.cloudinary.com/longacre/image/upload/v1570729025/niall_haedip.jpg','GET');
end;
/
ORA-22921: length of input buffer is smaller than amount requested
ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 1311
ORA-06512: at "SYS.DBMS_LOB", line 1163
ORA-06512: at "APEX_190100.WWV_FLOW_T_CLOB_WRITER", line 74
ORA-06512: at "APEX_190100.WWV_FLOW_T_WRITER", line 69
ORA-06512: at "APEX_190100.WWV_FLOW_T_WRITER", line 85
ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 1306
ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 1338
ORA-06512: at "APEX_190100.WWV_FLOW_WEB_SERVICES", line 1600
ORA-06512: at "APEX_190100.WWV_FLOW_WEBSERVICES_API", line 408
ORA-06512: at line 4
22921. 00000 - "length of input buffer is smaller than amount requested"
*Cause: The buffer length is not big enough to hold the amount of data
requested.
*Action: Verify that the number of bytes/characters specified in the
input amount parameter is not bigger than the number of bytes
specified in the input buffer length parameter. Allocate more
space for the input buffer if necessary.