Automate Load of Multiple csv files

Hi,

I have been looking into the automated and scheduled import of csv files (or files containing insert statements) into Oracle 7.3. I see that UTL_FILE is used to open and read files. However, the file name is required. I would have multiple files sitting on a network share of which all would have to be imported and then the processed file either written to as processed or moved to another location. Is there some way to read file names using PL/SQL so that I could pass in the file name to UTL_FILE.FOPEN? Also this would have to be a scheduled job to occur regularly?

Any ideas?
Thanks,
April Received on Thu Feb 26 2004 - 16:33:45 CST