APEX-PLUGIN.COM

..the apex plugin directory

an initiative of
 

Latest Plugins

 

Top Rated Plugins

Persian mini calendar (5.0)10
D3 Force Network Chart (5.0)10
Pretius APEX Client Side Valid... (5.0)10
Pretius APEX Enhanced LOV item (5.0)10
MultiMarker Map (4.9)10

Add your APEX Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your Website, GitHup Repository or Blog.

You are here:
Follow us on Twitter
Item Plugin FileDownloadLink

FileDownloadLink

0
Categories: Item Plugin
Author: MirMas

Download file directly from DB server file system

FileDownloadLink plugin render download link if file exists on DB server file system or custom message if it doesn't.

Reason why using file system rather than table for storing files could be saving DB space (Oracle XE) or working with Oracle COM automation feature.

Custom attributes of this plugin are:

  • Directory name of file to download,
  • Filename of file to download,
  • MIME type of file to download,
  • Link text: The string that goes between the <A> and </A> tags,
  • Schema of download procedure,
  • Package of download procedure,
  • Name of download procedure.

As you can see you should implement download procedure with specific interface. See Special Requirements section or readme.txt from RAR. 

For upload file "directly" to file system you can use SaveToDisk process plugin
Special Requirements
User must have privilege to execute UTL_FILE package and must have read access to directory with file to download.
Write and compile download procedure with interface:

procedure DownloadFile(
P_APP_ID number,
P_DIRECTORY VARCHAR2,
P_FILENAME VARCHAR2,
P_MIMETYPE varchar2 default null
);
You can include procedure in a package.
Sample is included in RAR in file DownloadFileProcedure.sql.

Keywords
FileDownloadLink,file,system,download,directory

Oracle APEX Plugin
Company: Mirmas
Date added: 31.1.2012
Views: 31785
Votes: 0
Reviews: 6
Min. APEX Version:
4.1
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:




Download
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
 Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
0 
by MirMas
on June 7, 2015
You need to allow DownloadFile procedure to be called from URL. It's in readme.txt file from line 21 to 35.
0 
procedure cannot be found
by uzzver21
on June 3, 2015
Hi!

When I try to download file I've got message:

The requested URL /apex/WS1.DOWNLOADFILE was not found on this server where WS1 - is my scheme. Could you help me? How should I deploy DownloadFile procedure?
December 5, 2013
The Entry has been updated in the meantime!
0 
Re:Issue
by MirMas
on December 5, 2013
Readme.txt from installation package is not complete at this point. It assumes that you are using EPG. This should work if you are using APEX listener:
grant execute on "APEX_040200"."WWV_FLOW_EPG_INCLUDE_MOD_LOCAL" to APEX_PUBLIC_USER; --maybe this is not necessary
grant execute on "DownloadFile" to APEX_PUBLIC_USER;

If this don't work or you are using mod_plsql search posts and articles with: "oracle apex call stored procedure url" .
0 
Issue
by Aldo
on December 4, 2013
Hi ...

When I click the link to open the file this appears:
Forbidden
The requested operation is not allowed

The only diffrenece is that I dont have APEX_040100 user, appears like APEX_040200

Can you help me please?

Best Regards
October 16, 2012
The Entry has been updated in the meantime!
0 
My Mistake
by MirMas
on April 13, 2012
I exported this plug-in with APEX 4.1. Obviously I should select minimal APEX version as 4.1 at the beginning. All plug-in code is in FileDownloadLink.sql in RAR. You can use it to create your plug-in. If you will have time, export it and send me file.

Thanks
Miro
April 13, 2012
The Entry has been updated in the meantime!
0 
Using FileDownloadLink
by Mark Conroy
on April 12, 2012
Hi there, I tried to install the plugin with Apex 4.0.2.00.09 running on Server 2008 R2, and successfully imported it but get an error message when Installing "NOT COMPATIBLE (Your export may contain calls not supported by your application version.)."

Has the plugin been modified or a I failing to see something blindingly obvious.

Thanks
Mark
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.