Re: Ora-01772 on Sqlloader

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