APEX

Hi,

I'm making a HR application which will allow for public users to upload their resumes in word, pdf, etc format.

I'd like to scan the files for viruses before they are inserted into the DB.

From my understanding, files are loaded in the wwv_flow_files view after a user submits a page with a file upload. Because of this, scanning a file before it's in the DB doesn't seem like it will be possible. I'd like to scan the file when it resides in the wwv_flow_files view and erase it, if applicable, before inserting it into the table that will hold the resume files.

I've talked to our DBA and he doesn't know how to do this. Do you have any suggestions?

Thanks,

Martin