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
--
http://www.freelists.org/webpage/oracle-l

References:

Ora-01772 on Sqlloader
From: srinivasan Venkat

Re: Ora-01772 on Sqlloader

Other related posts: