Hi,
I've a batch program that load data from a file like:

00000013|FERRAN|JULIAN|GONZALEZ|1|
00000014|FRANCESC|NARVAEZ|PAZOS|1|
00000015|INMACULADA|MAYOL|BELTRAN|2|

I used the sqlldr command in this way:

sqlldr userid=U/P control=$SCRIPTS/CTRL.WCT data=$DATA/FILE log=$LOGS/FILE.LOG bad=$AUXS/FILE.BAD discard=$AUXS/FILE.DIS SKIP=1

Everythings works fine, but I notice that sometimes the rows on the file are more than the rows on the final DB table.
Sometimes occurs error on the precess.. wich kind of error I don't know.. basically I would like to know when the process reach the end of the document...
Thanks.

U must have newline character inside of rows. So just replace that character to have entire lines on your spool file.