Oracle Error Message
SQL*Loader-00647: Integer to number conversion error
Reason for the Error
An error occurred while attempting to convert an integer to an Oracle number format.
Solution
Verify that the integer field in the data file is a valid integer. If the INTEGER(N) syntax was used, then verify that the length specified is valid.