Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FileSystemWatcher as stored procedure?

Ross MurrayApr 21 2015 — edited Apr 21 2015

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.

Comments

Hi Ray,
Sorry that the explain plan looks so bad in the output.
When the select output doesn't look good with our extension, the workaround I have been using is the SPOOL command. I find that the file output tends to be easier to read in some cases.
Can you please try adding:
spool c:\myfolder\myspoolfile.txt

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 19 2015
Added on Apr 21 2015
0 comments
687 views