The following HTML defines a link that calls the GET_FILE application process, passing in a FILE_ID value of 'my_image.png'. This button hard codes the image to download, but the image name could be sourced from an item on the screen.

Click the 'No Link Defined' button next to the 'Target'.į?p=&APP_ID.:1:&APP_SESSION.:APPLICATION_PROCESS=GET_FILE:::FILE_ID:my_image.png.

In the property panel, under the 'Behavior' section, select the 'Action' of 'Redirect to URL'.

Highlight the button you want to use to initiate the download.The following process associates the button with the GET_FILE application process, passing in a FILE_ID value of 'my_image.png'. If you need to add authoriszation, click on the new application process, select the authorization scheme and click the 'Apply Changes' button.Select the 'User is Authenticated (not public)' condition type.Enter the PL/SQL to perform the download.Process Point: Ajax Callback: Run this application process when requested by a page process.Shared Components > Application Processes.

Click the 'Create Application Item' button.

Session State Protection: Checksum Required - User Level.

The following APEX setup is required, whether you plan to initiate the download from a link or a button. APEX Common Setup (Application Item and Process) WHEN apex_application.e_stop_apex_engine THEN Sys.WPG_DOCLOAD.download_file(l_blob_content) ('Content-Disposition: filename='' || p_file_name || ''') ('Content-Length: ' || DBMS_LOB.getlength(l_blob_content)) Sys.OWA_UTIL.mime_header(l_mime_type, FALSE) L_blob_content documents.blob_content%TYPE Here is the code we would use to initiate the file download.ĬREATE OR REPLACE PROCEDURE get_file (p_file_name IN VARCHAR2) IS There is a separate article describing some variations of how to code the PL/SQL side of the file download process.įor this example, we are going to assume you have a table called DOCUMENTS that holds your media in a BLOB column, along with a column for the MIME type.

Download Files Using PL/SQL and a Gateway (ORDS, mod_plsql, EPG).

APEX Common Setup (Application Item and Process).

This article describes how to create a button or link to initiate a file download from an APEX application. Home » Articles » Misc » Here APEX Tips : File Download From a Button or Link

Oracle apex file browse save file name