display the photo obtained using the request without saving it

AndriiPrincip

  json_table      apex_json.t_values; <br/>  sCount int; <br/>  l_clob CLOB;<br/>  V_JSON64 clob; <br/>  V_SNAPSHOT blob; <br/>Begin<br/>  v_url := 'http://myURL' ; <br/>  l_clob:= apex_web_service.make_rest_request(p_url => v_url, p_http_method=> 'GET');<br/>  apex_json.parse(tv, l_clob); <br/>  V_JSON64 := apex_json.get_clob (p_values => json_table, p_path => 'snapshot', p0 => 3); <br/>  V_SNAPSHOT := iot_general.clob_base64_to_blob (p_clob => V_JSON64); <br/>  END;Declare <br/>  v_url varchar2(1000); <br/>  tv apex_json.t_values; 

I have a question about whether it is possible to display a photo that was received via a BASE 64 query. I have a link but a photo, I eat it downloaded with the help of the code

On the way out, I have a photo in V_SNAPSHOT, but how to display it when this is not saving it I cannot understand, I will be grateful for your help)

Balamurugan Natarajan

Hi AndriiPrincip,

Were you able to insert the response received into a column (blob)?

then a report can quickly display it.

Regards,

Bala

AndriiPrincip

yes i can record the data but i just want to output PHOTO and all i dont want to record

Balamurugan Natarajan

Check if this can help you https://oracle-base.com/articles/misc/html-with-embedded-images-from-plsql#encoding_images_from_blob Regards, Bala