Home » SQL & PL/SQL » SQL & PL/SQL » How to loop through Unix files in a PL/SQL Package
How to loop through Unix files in a PL/SQL Package [message #270318] Wed, 26 September 2007 09:13 Go to next message
rizksaad
Messages: 1
Registered: September 2007
Junior Member
Hi,
I have multiple files in an unix directory ($FILES_IN) that have the same extension. The full names of the files are unknown.

I want to do a loop in a pl/sql package like this algorithm:

for i =all the files in the directory $FILES_IN that have the extension "MPLG"

LOOP
-process file i
END LOOP


is that possible? can someone give me the correct syntax for this part:
"for i =all the files in the directory $FILES_IN that have the extension "MPLG""

Thank you


Re: How to loop through Unix files in a PL/SQL Package [message #270334 is a reply to message #270318] Wed, 26 September 2007 10:15 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Search, scroll down there are solutions.

Regards
Michel
Previous Topic: No more data to read from socket
Next Topic: Assigning of %rowtype variable from different table
Goto Forum:
  


Current Time: Fri Dec 09 23:21:55 CST 2016

Total time taken to generate the page: 0.08083 seconds