Database Administration (MOSC)

MOSC Banner

File watcher

edited Sep 23, 2013 7:34AM in Database Administration (MOSC) 4 commentsAnswered
Hi All,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center