Hi,
I would like to create a 'Download Link' on a file that is stored as BLOB in a database table.
I know that there is a sample app 'Sample File Upload and Download'.
On Page12, there is a P12_DOWNLOAD_LINK, and it has Settings | Based On > Output of PL/SQL Code:
begin
sys.htp.p('<a href="' || apex_util.get_blob_file_src('P12_FILE_BLOB',:P12_ID,:P12_PROJECT_ID) || '">'||apex_escape.html(:P12_FILENAME)||'</a>');
end;
that is quite straightforward, but How to actually get the BLOB into P12_FILE_BLOB page item?
unfortunately P12_FILE_BLOB item has some very complex configuration.
How can I achieve this with some simple SELECT statement? (or perhaps PL/SQL)
thank you