Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01722 during SQL Loader 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"
Thanks for the replies...
Scott Morrow
"Dodger" <scott_at_REMOVE_THIS.answerdude.net> wrote in message
news:9qsog3$hms$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 - 08:07:58 CDT