File watcher
I am in the process of seeting up a file watcher, here is what I have for the file watcher piece.
BEGIN
DBMS_SCHEDULER.CREATE_FILE_WATCHER (
FILE_WATCHER_NAME =>'DAILIES_FILE_WATCHER',
DIRECTORY_PATH =>'D:\ftpdir',
FILE_NAME =>'corp.txt',
CREDENTIAL_NAME =>'DAILIESCRED',
DESTINATION =>'FIL1',
ENABLED =>'FALSE');
END;
/
My problem is that I found out last Friday its going to be 6files arriving on the server and not just a file. Can anyone help me with how I incorperate multiples files in my PL\SQL block above or do I need a something.