10g: iterating through files in directory, filenames unknown?

From: Thomas Blankschein <thomas_at_blankschein.de>
Date: Mon, 24 Mar 2008 12:53:35 +0100
Message-ID: <47e79641$0$23694$9b4e6d93@newsspool2.arcor-online.net>


an external process writes several files into a directory on a windows file system. This directory is linked to a 10g database as a DIRECTORY object, so I can access the files from within the database.

But the problem is, that the file names are not known in advance. I'm searching for some pl/sql-code to iterate through the files in the directory to get their names. Is this possible?

Thomas Received on Mon Mar 24 2008 - 06:53:35 CDT

Original text of this message