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

From: Urs Metzger <urs_at_ursmetzger.de>
Date: Mon, 24 Mar 2008 18:33:45 +0100
Message-ID: <fs8ojr$eum$1@online.de>


Thomas Blankschein schrieb:
> Hello,
>
> 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?
>
> Thanks,
> Thomas

Ask Tom:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:439619916584

hth,
Urs Metzger Received on Mon Mar 24 2008 - 12:33:45 CDT

Original text of this message