oracle - How to check for a file in FTP server location and send the same file from FTP location through mail -

a text file being created in ftp server when interface runs,

i need check whether created have records,if has values must sending same text file through mail using pl/sql.

thanks million in advance :)

there exists great ftp packages build tim hall. http://www.oracle-base.com/dba/scripts.php -> miscellaneous -> ftp.pkb , ftp.pks

for email issue can use oracle package utl_mail.

you need job execute search on ftp server in order find text file.

i have loggings, prefered way of task be: 1) read ftp directory nd search text file 2) store text file name, content , sysdate in table 3) delete/rename file ftp server, not load again 4) check if content not null (from table) 5) if not null send email 6) mark data row in table, checked

hope helps.

brgds, birthe