FileDownloadLink Tweet |
![]() |
Categories:
Item Plugin
Download file directly from DB server file systemFileDownloadLink 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:
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 |
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. |


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?

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" .

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

Thanks
Miro

Has the plugin been modified or a I failing to see something blindingly obvious.
Thanks
Mark
Powered by Sigsiu.NET | ![]() |