dbTalk Databases Forums  

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

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss 10g: iterating through files in directory, filenames unknown? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Thomas Blankschein
 
Posts: n/a

Default 10g: iterating through files in directory, filenames unknown? - 03-24-2008 , 05:53 AM






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

Reply With Quote
  #2  
Old   
Urs Metzger
 
Posts: n/a

Default Re: 10g: iterating through files in directory, filenames unknown? - 03-24-2008 , 11:33 AM






Thomas Blankschein schrieb:
Quote:
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/...D:439619916584

hth,
Urs Metzger


Reply With Quote
  #3  
Old   
Urs Metzger
 
Posts: n/a

Default Re: 10g: iterating through files in directory, filenames unknown? - 03-24-2008 , 11:33 AM



Thomas Blankschein schrieb:
Quote:
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/...D:439619916584

hth,
Urs Metzger


Reply With Quote
  #4  
Old   
Urs Metzger
 
Posts: n/a

Default Re: 10g: iterating through files in directory, filenames unknown? - 03-24-2008 , 11:33 AM



Thomas Blankschein schrieb:
Quote:
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/...D:439619916584

hth,
Urs Metzger


Reply With Quote
  #5  
Old   
Urs Metzger
 
Posts: n/a

Default Re: 10g: iterating through files in directory, filenames unknown? - 03-24-2008 , 11:33 AM



Thomas Blankschein schrieb:
Quote:
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/...D:439619916584

hth,
Urs Metzger


Reply With Quote
  #6  
Old   
Thomas Blankschein
 
Posts: n/a

Default Re: 10g: iterating through files in directory, filenames unknown? - 03-24-2008 , 12:28 PM



Hi Urs,

Quote:
Ask Tom:
http://asktom.oracle.com/pls/asktom/...D:439619916584
Perfect, thank you!


Reply With Quote
  #7  
Old   
Thomas Blankschein
 
Posts: n/a

Default Re: 10g: iterating through files in directory, filenames unknown? - 03-24-2008 , 12:28 PM



Hi Urs,

Quote:
Ask Tom:
http://asktom.oracle.com/pls/asktom/...D:439619916584
Perfect, thank you!


Reply With Quote
  #8  
Old   
Thomas Blankschein
 
Posts: n/a

Default Re: 10g: iterating through files in directory, filenames unknown? - 03-24-2008 , 12:28 PM



Hi Urs,

Quote:
Ask Tom:
http://asktom.oracle.com/pls/asktom/...D:439619916584
Perfect, thank you!


Reply With Quote
  #9  
Old   
Thomas Blankschein
 
Posts: n/a

Default Re: 10g: iterating through files in directory, filenames unknown? - 03-24-2008 , 12:28 PM



Hi Urs,

Quote:
Ask Tom:
http://asktom.oracle.com/pls/asktom/...D:439619916584
Perfect, thank you!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.