Home » SQL & PL/SQL » SQL & PL/SQL » using UTL_file for multi-records
using UTL_file for multi-records [message #38345] Fri, 12 April 2002 09:12 Go to next message
Daniel Tsai
Messages: 8
Registered: November 2001
Junior Member
I have a folder storing many text files coming from FTP dropbox hourly. How can I use utl_file package to process them into database without knowing file names and delete them right after cmplete process? Is there any way I can get file name and pass it to procedure as a parameter?

Regards,

Daniel
Re: using UTL_file for multi-records [message #38348 is a reply to message #38345] Fri, 12 April 2002 09:27 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
You will need to use a Java stored procedure to get the directory listing and to delete the files. Here is how to get the directory listing:

http://asktom.oracle.com/pls/ask/f?p=4950:8:687450::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:439619916584
Previous Topic: Insert in Pl/sql
Next Topic: PL/SQL function in FROM clause
Goto Forum:
  


Current Time: Thu Mar 28 09:34:47 CDT 2024