Hello Team,
I am trying to add download button for BLOB database column in APEX page and I am trying to follow this below link: - http://www.apexlessons.com/download-blob-file-from-database-in-oracle-apex/
And as suggested, I have created pl/sql procedure download_blob and configure Application item, Application process and added APEX Button and as suggested in link I am using Button "Action” to “Redirect to URL” and using following URL for button: -
“f?p=&APP_ID.:1:&APP_SESSION.:APPLICATION_PROCESS=DOWNLOAD_BLOB:::FILE_ID:**&P11_FILE.**”
But there is problem, if I try to pass P11_FILE parameter from APEX page then its not taking value and in debug message I observe that it is trying to download BLOB with below url (without P11_FILE parameter value): -
“f?p=&APP_ID.:1:&APP_SESSION.:APPLICATION_PROCESS=DOWNLOAD_BLOB:::FILE_ID:”
And it failed.
To verify, the APEX config, I ran test with hardcoded value of P11_FILE in url: -
“f?p=&APP_ID.:1:&APP_SESSION.:APPLICATION_PROCESS=DOWNLOAD_BLOB:::FILE_ID:1360”
Then APEX Download button worked fine and downloading file from BLOB column so can some one please help me to understand why '&P11_FILE.' parameter value is not getting pass and is there any alternate way to achieve Downloading BLOB From Database in Oracle APEX.
Thanks,