FTP file using PL/SQL: file size 0
289531Oct 11 2006 — edited Oct 12 2006Hi,
I'm using the approach explained in
http://www.oracle-base.com/articles/9i/FTPFromPLSQL9i.php
I have written a procedure that get the last n files into an external directory location.
The problem is that some of the files arrived to the external directory with size 0 while they are not empty files on the original servers.
These empty files are randomly created, i.e. on one run a file can have size 0 while on the next run can be ftp'd properly. Sometimes 1 file is created with size 0 and another times 3.
I would appreciate any help.
Many thanks.