![]() To generate a zip file, you just need to pass SQL query and you will get a zip file. So, I have added new function get_zip to my open source package apex_util_wrap. Then I thought, why can't I create a wrapper functions on top of APEX_ZIP APIs to make developers task further easy. If you are using this functionality in multiple places in your application, then you may have to repeat the code, which looks more or less same, in several places. WHEN value_error THEN - if there is no file added so far, then apex_zip.finish raises VALUE_ERROR - do nothing NULL ,p_file_name => case when mime_type like 'image%' then 'images/'||l_file.file_nameĪpex_zip.finish(p_zipped_blob => l_zip_file) Now I want to give end user to download the files he has selected and put them in a zip file to download on his machine. I have created an external table to view the content of the oracle directory and I'm able to download a single file. move all images to images folder - all other files will be directly under the zip folder I have an Oracle Directory that read the content of a directory on the server. ScreenShots:Software program Description:Every large corporation that desires to handle. BEGIN - zip all the files uploaded to current application "Static Application Files" FOR l_file IN(
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |