0 Replies Latest reply on Apr 21, 2015 5:41 PM by Ross Murray

    FileSystemWatcher as stored procedure?

    Ross Murray

      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.