I have a application running on apex.oracle.com where i can display images from my custom table.
However i am not able to display image for apex installed on my office server. 11gR2 and Apex 3.2.1
When i right click on image -> properties i see as below
http://testlhea:8080/apex/ADECCO.display_easy_image?p_image_id=1111724816919021
Following is the code i use to download my blob/image
create or replace procedure display_easy_image( p_id number ) as
s_mime_type varchar2(48);
n_length number;
s_filename varchar2(400);
lob_image blob;
begin
select mime_type, dbms_lob.getlength( blob_content ), filename, blob_content
into s_mime_type, n_length, s_filename, lob_image
from easy_image
where image_id = p_id;
owa_util.mime_header( nvl( s_mime_type, 'application/octet' ), FALSE );
-- Set the size so the browser knows how much it will be downloading.
htp.p( 'Content-length: ' || n_length );
-- The filename will be used by the browser if the users does a "Save as"
htp.p( 'Content-Disposition: filename="' || s_filename || '"' );
owa_util.http_header_close;
-- Download the BLOB
wpg_docload.download_file( lob_image );
end display_easy_image;
/
<img src="#OWNER#.display_easy_image?p_id=#IMAGE_ID#" alt='hello' />
I have granted execute to public , ANONYMOUS , APEX_PUBLIC_USER but still didnt work.
Please suggest how can i get this working. Is this casue of 11gR2 which are more restrective privs ?