APEX

Hi to all!

I would like to implement a solution for storing files uploaded via apex user interface to servers file system. As well I would like this files to be retrievable by apex users. I designed the following solution:

For upload:
1. Through file browse item user chooses file to be uploaded
2. File goes to custom table (as BLOB)
-- so far i would use apex Upload\Download files tutorial
3. File(BLOB) would then have to be written to file system to some directory and file id would have to be written to some db table which holds pointers to files on file system
4. delete file(blob) from custom table (from step 2)

For download:
1. user chooses link from some report region(based on table giving file pointers to files residing on file system)
2. file identified with chosen file pointer is then inserted into blob column of some custom table in db
3. from custom table with download procedure fie is finally presented to user
4. delete file(blob) from custom table (from step 2)

Using apex tutorial for Upload\Download files it is straitforward to get the files from db table or into db table using blobs. But i have not seen any example of using BFILE or migrating files from db to file system and vice versa.

So some Q arise:
a) How can I implement step 3 under For upload section above
b) How can I implement step 2 under For download section above
c) Is there any way to directly upload file to file system via apex user interface or to directly download file from file system via some report region link column?

Please help!!!

Regards Marinero

Message was edited by:
marinero