I am aware of the dbms_scheduler.file_watch procedure and its short-comings. In particular, I don't seem to be able to run a job when a file, already seen when it was added to the watched directory, is updated. That is, I want to be able to update a table with data from a file in a remote network directory whenever the file first appears and each time it is updated.
So I am thinking of using the .Net class FileSystemWatcher. Can anyone think of reasons why this wouldn't work, or foresee any issues I would need to deal with up front?
Thanks.