Re: Automate Load of Multiple csv files

April wrote:

> 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

Send a "header" file with a known file name that contains the names of files to be imported. Use DBMS_JOB to schedule reading the header file and running the UTL_FILE imports.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)