I'm guessing this is a table issue, not a SQL Loader issue. For example,
could you insert this number directly into the table via SQL*Plus?

Try setting NLS_NUMERIC_CHARACTERS=",." and retrying the insert in
SQL*Plus. I'm thinking once you succeed at inserting it directly into the
table, then SQL Loader will have no issue as well.

--Tom

On Fri, 28 Apr 2006, srinivasan Venkat wrote:

> My test.txt contains
>
> 345.456,78
--
http://www.freelists.org/webpage/oracle-l