Some one on the forum asked for an example of how to bulk upload files. Here is an example I used a couple years ago of processing a zip file and uploading the individual files into a table. Then we made an application to manage the file and followed "Create a Procedure to Download Documents" to download.
Here's the sql for the table and sequence:
create table docs(doc_id number,blob_content blob,file_name varchar2(2000));
create sequence doc_id_seq;