Using APEX_UTIL.Get_File
I'm a newbie to APEX and am using APEX_UTIL.Get_File to open static files. The requirement specifies that the user must be prompted whether to save or open the file. We have created a "popup" page with dynamic PS/SQL:
DECLARE
l_file_id NUMBER;
BEGIN
SELECT id INTO l_file_id FROM APEX_APPLICATION_FILES
WHERE filename = 'LDSNav.pdf';
--
APEX_UTIL.GET_FILE(
p_file_id => l_file_id,
p_inline => 'NO');
END;
For some reason, the file is loaded into the page (as if we had coded p_inline => 'YES') rather than prompting the user to save or download when testing using IE. When testing in FireFox, it does not recognize the mime type and loads the file as it it were a text document.