Forum Stats

  • 3,768,552 Users
  • 2,252,809 Discussions
  • 7,874,617 Comments

Discussions

FileSystemWatcher as stored procedure?

Ross Murray
Ross Murray Member Posts: 44
edited Apr 21, 2015 1:52PM in .NET Stored Procedures

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.

This discussion has been closed.