UC - Download File(s) Dynamic Action (23.1)

Download of database-stored BLOBs and CLOBs with a dynamic action. Multiple files are zipped automatically.

Free Plug-in under MIT License

All UC plug-ins are released under MIT License, which essentially means it is free for everyone to use, no matter if commercial or private use.

Overview

The UC - Download File(s) dynamic action plug-in enables the downloading of one or multiple database-stored BLOBs or CLOBs. You don't have to worry about setting HTTP headers, converting CLOBs to BLOBs, or zipping the files. It's all done for you. Just specify which files to download via a SQL query, or a more dynamic PL/SQL code block. Multiple files are zipped automatically, but a single file can optionally be zipped as well.

The benefits of downloading a file using a dynamic action include:

1. You have the flexibility of using SQL to decide what file(s) to download including filtering based on page item values
2. You can have further actions defined after the download action for improved workflow
3. You can wait for the result of the file to download before continuing your next action
4. You do NOT issue a page submit or redirect, which means you can handle errors better i.e. you won't be redirected to an error page

Note: in "some cases" you may need to change your security setting "Embed in Frames" and set it to either "Allow from same origin" or "Allow" for this action to work correctly in preview mode. This is because the file will be downloaded in a hidden iFrame on the page. If your setting is set to "Deny" you may see a message in the console like: "Load denied by X-Frame-Options". We evaluated a number of techniques to download files and found that this technique has the best performance with larger files.