Hi,
I am using Oracle APEX 4.2.5 and on Oracle 11g R2. I am getting data in webservice from SAP system.
Now SAP is sending a PDF file in XSTRING format. Using this data, I need to create a PDF and download it for user in APEX application.
Can you please advice on how to do it?
So far, I have created a table with BLOB column. And have updated it manually with XSTRING data. And used below code to download it but it is not showing any data in it.
owa_util.mime_header( 'application/pdf', FALSE );
-- set the size so the browser knows how much to download
htp.p('Content-length: ' || v_length);
-- the filename will be used by the browser if the users does a save as
htp.p('Content-Disposition: attachment; filename="'||v_filename);
-- close the headers
owa_util.http_header_close;
-- download the BLOB
wpg_docload.download_file( Lob_loc );
@"Patrick Wolf", @"Denes Kubicek"