This content has been marked as final. Show 4 replies
... the AMT column is shown as CHARACTER, while my control file designates DECIMAL EXTERNALThat's correct, numeric external means number represented in characters,not in binary format (in other words human readable).
What's your default decimal delimiter, '.' or ','? Your external numbers show '.', but when your delimiter is ',', ORA-01722 is thrown.
Thanks, I already got this question answered in a different forum, and forgot to close this one. It turns out I had hidden newline characters at the end of each line. I loaded the numbers as VARCHAR2, stripped off the final newline, and then converted to NUMBER.
I still don't know why the newline characters were there though. I created my .csv via Excel 2007, which I have done many times before with no problems.