Looping through files in a folder, How to
emssJan 24 2013 — edited Jan 25 2013Looking for plsql code to read through files in a folder, and pass the name of the file found to a parm.
The parm will then be used to open the table, process data to end of file, and then close the file. The file is then moved to an archive, and the next file in the folder is read, name of file passed to parm, file is opened, data is processed, and file is moved to archive....repeat until no files in folder.
I only need some help with reading through the folder to find the table. I have code on how to open, process and move a folder...it's the file in folder read loop I am trying to develop.
In summary, I am looking for some code showing how to read all tables in a folder and pass the name of the table found, until all files read.