Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> pl/sql - looping thru all files in a directory

pl/sql - looping thru all files in a directory

From: Mike Guerrero <m1guerre_at_mail.sdsu.edu>
Date: Wed, 12 Jan 2000 21:04:46 -0800
Message-ID: <387D5CEE.2DC4@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 Wed Jan 12 2000 - 23:04:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US