Home » Developer & Programmer » Forms » Automatic read files from directory using Oracle Forms?
icon9.gif  Automatic read files from directory using Oracle Forms? [message #161564] Mon, 06 March 2006 01:13 Go to next message
davidgwillis
Messages: 1
Registered: March 2006
Location: Hong Kong
Junior Member
Hi,

I know there is a build-in function for Get_File_Name from oracle but this function only allow you to select single file from the dialog box. What I want to use is there another function in Oracle or SQL statement that if I specify the directory name and it will automatic retrieve all the files name from that directory? or I don't have any choice I need to use some externel function like Java or C to get it?

Thanks & Regards,

david

Report message to a moderator

Re: Automatic read files from directory using Oracle Forms? [message #161711 is a reply to message #161564] Mon, 06 March 2006 18:15 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Look at using a 'host' command to direct a listing of a directory to a temporary file, then read that file line by line using 'text_io' or 'utl_file', and do your Get_File_name using the file name found on each each line in the temporary file.

David

Report message to a moderator

Previous Topic: how to deploy forms on web (merged)
Next Topic: Oracle forms tutorial
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 05:32:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.