Re: pl/sql - looping thru all files in a directory
From: Oracle Enterprise Internet Tools Product Management <no_replies_at_uk.oracle.com>
Date: Mon, 17 Jan 2000 20:44:34 -0000
Message-ID: <85vv5m$jiv$1_at_inet16.us.oracle.com>
Date: Mon, 17 Jan 2000 20:44:34 -0000
Message-ID: <85vv5m$jiv$1_at_inet16.us.oracle.com>
I did this once for a customer by using the 'at' command on NT to pipe a
directory listing to a control
file and then used UTL_FILE to manipulate the files from there.
-- Regards Jason ____________________________________________________________________________ __ [Quoted] Jason Pepper - Enterprise Internet Tools Product Management ____________________________________________________________________________ __ Opinions are mine and do not necessarily reflect those of Oracle Corporation Mike Guerrero <m1guerre_at_mail.sdsu.edu> wrote in message news:387D5CEE.2DC4_at_mail.sdsu.edu...Received on Mon Jan 17 2000 - 21:44:34 CET
> I have done quite a bit using the UTL_FILE built in package. I can do
> just about all the file i/o that I need to do. In every case however,
> the file name is known.
>
> In a previous project I was given the file names. Now I am told that
> all the files reside in a directory and the I need to loop all files in
> that directory.
>
> In PL/SQL, how can I loop through all the files in a directory (ex.
> c:\data} and process each file. If I have 5 files in my directory I
> want to loop through each file until the processing is done.
>
> I guess that I need to be able to get a directory listing in PL/SQL.
> Does anyone have any ideas?
>
> Thanks.