| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql - looping thru all files in a directory
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
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...
> 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.
Received on Mon Jan 17 2000 - 14:44:34 CST
 |
 |