Since I don't know in which seccion post about you articles/scripts I put on this (sorry if I mistake).
Our BD team is having issues with the PL/SQL code of http://www.oracle-base.com/articles/mis ... plsql.php;
they are sending files some time ago, so the issue is new.
They make a query on the DB Server; that creates a file; this file is send over FTP to a remote site; the issue is that transmitted file has fewer lines than the original one.
We came down to the DB/PL/SQL code because when we transmit this file using ftp clients (both windows; unix) from either side (BD server, remote site) the size of the file is constant and the checksums (sha1) also. But when the file is transmitted with the PL/SQL code has fewer lines out. The issue (absent content) vary from 40 lines to 663 lines.
The files is ASCII varing from few KB to 48MB; the content is a result from a query and basically it has:
phone number, bytes, cellid, timestamp.
They have used the binary transfer and ascii and the issue persists. We also have captured network packets to see if there is something at that level but nothing is wrong (obviously the issue appears but no errors or packet miss).
Does anybody have an idea (buffers, encoding).
Thanks in advance