Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Looping through files in a folder, How to

emssJan 24 2013 — edited Jan 25 2013
Looking 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.
This post has been answered by BluShadow on Jan 25 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2013
Added on Jan 24 2013
11 comments
1,936 views