Essentially what you need to do, is create a simple java class that
can read the contents of your directory,
wrap that up in a PL/SQL Stored procedure then loop through the
directory contents.

I think your best option, to avoid DDL, is to rename the file in the
directory using a combination of Java (directory contents)
and UTL_FILE to rename the file to some "common" name you choose. You
can utilize the same methodology to move
the files after you have completed processing.

Hi all,
>> Running Oracle 9.2 on Windows.>> I know this is Oracle forum, but it’s somewhat related. This question is> for those of you who run Oracle on Windows.>> I have several “.txt” files in a directory (all different names) and> looking for the possibility to do the following using .BAT file:>> 1. Take first file>> 2. rename it>> 3. run procedure (pass it in)>> 4. move it into archive dir>> 5. delete it from original dir>> 6. GOTO 1>>>> Reason I have to do all this is because in step 3 I am using external table> to read the “.txt” file and it has to have a unique file name.>>>> Regards,>>>> Eugene Pipko>> Seattle Pacific Industries>> office: 253.872.5243>> cell: 206.304.7726>> P Please consider the environment before printing this e-mail.>>>