APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Add your APEX4.0 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
Process Type Plugin SaveToDisk

SaveToDisk

7
Categories: Process Type Plugin
Author: MirMas

Save file to file system rather than into table

Plugin can be useful when you want to save DB space (Oracle XE) or when you deal with Oracle COM automation feature.

To use this process plugin you must have File Browse item on page with chosen WWV_FLOW_FILES for storage. You define destination for file (directory and filename) and maximum allowed file size. On submit plugin moves file (BLOB in fact) from WWV_FLOW_TABLES table to file on server file system. Plugin then deletes row from WWV_FLOW_TABLES. 

Custom attributes of this plugin are:

  • Name of File Browse item
  • Destination directory name,
  • Destination file name,
  • Maximum allowed file size,
  • Item with Filename,
  • Item with hash of uploaded file
  • Overwrite old file (Y/N)

 

With this process plugin you can upload files "directly" to server file system. For downloading you can use FileDownloadLink item plugin.

Special Requirements
You must have execute privilege to UTL_FILE and DBMS_CRYPTO package and read/write privilege to destination folder.

Keywords
save,file,disk,WWV_FLOW_FILES,browse,item

Oracle APEX Plugin
Company: MirMas
Date added: 4.2.2012
Views: 11591
Votes: 7
Reviews: 36
Min. APEX Version:
4.0
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 
Not a valid plugin file
by MirMas
on February 12, 2016
Can you describe your steps in more detail?
What is your APEX version?
What is exact error message?
10 
Not a valid plugin file
by MirMas
on February 12, 2016
Can you describe your steps in more detail?
What is your APEX version?
What is exact error message?
0 
Not a valid plugin file
by MirMas
on February 12, 2016
Can you describe your steps in more detail?
What is your APEX version?
What is exact error message?
0 
Not a valid plugin file
by MirMas
on February 12, 2016
Can you describe your steps in more detail?
What is your APEX version?
What is exact error message?
0 
Not a valid plugin file
by MirMas
on February 12, 2016
Can you describe your steps in more detail?
What is your APEX version?
What is exact error message?
0 
Not a valid plugin file
by MirMas
on February 12, 2016
Can you describe your steps in more detail?
What is your APEX version?
What is exact error message?
2 
Not a valid plugin file
by James
on January 5, 2016
When I try to install it says it is not a valid plugin file.
2 
Not a valid plugin file
by James
on January 5, 2016
When I try to install it says it is not a valid plugin file.
2 
Not a valid plugin file
by James
on January 5, 2016
When I try to install it says it is not a valid plugin file.
0 
File encryption
by MirMas
on June 14, 2015
I assume you want to save file in some kind of encrypted format. Good place to do that is before Blob2File procedure. You just need to encrypt BLOB before writing it to file. Check SaveToDisk.sql plugin source code. Also check Oracle documentation on DBMS_CRYPTO package.
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.