Hi all,

I need to open and process a series of files in a unix directory. Each file contains an xml document that I parse and apply to my database.

I have tried using UTL_FILE but I don't know the name of the file that I wish to open.

Is there a way of performing an 'ls' in my directory from PL/SQL so that I can get the file names and then use UTL_FILE.

OR

Is there a totally different way of solving this problem.

Thanks in advance.
Tim