Oracle Application Express (MOSC)

MOSC Banner

Using APEX_UTIL.Get_File

edited Sep 25, 2013 1:23PM in Oracle Application Express (MOSC) 5 commentsAnswered
Hi, 

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center