Re: ORA-01722 Invalid Number on SQL Load - Help!

Follow up - Problem solved! It turns out that NLS_LANG exists in multiple registry keys.. One in the Oracle root, one in HOME0, and one in the Dev6i registry root. I'd missed the one in the Oracle root, which was set to "CANADIAN_ENGLISH"... instead of "AMERICAN"

Scott Morrow

"Dodger" <scott_at_REMOVE_THIS.answerdude.net> wrote in message news:9qso3b$hjc$1_at_news.storm.ca...
> After a fresh install of Personal Oracle 7.3.4 on a Win95 machine, and
 fresh
> creation of the database, upon attempting to load tables with SQL Loader,
> every record in every table which contains a decimal number is rejected
 with
> ORA-01722. Records without decimal numbers load correctly.
>
> Many other previously installed V7.3.4 PCs with the same database load the
> same CTL files with no problems. It should be noted that we are installing
 a
> completely new version of our associated application on a clean PC, and I
> suspect I may have missed setting up something in either INITORCL.ORA or
 the
> registry?
>
> On the failing system, NLS_LANG = "AMERICAN"
>
> Any assistance would be gratefully accepted.
>
> Scott Morrow
>
>
Received on Sun Oct 21 2001 - 15:06:24 CEST