Re: Ora-01772 on Sqlloader
- From: Tom Fox <tom@xxxxxxxxx>
- To: srinivasan Venkat <srini.venkat.raman@xxxxxxxxx>
- Date: Fri, 28 Apr 2006 12:31:41 -0400 (EDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
