Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01722 during SQL Loader load - Help!
Dodger wrote:
>
> 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
According to the error manual, this error only occurs if a character is
not a "valid numeric literal". So, what does your control file look
like? What does your table look like?
-- Ron Reidy Oracle DBA Reidy Consulting, L.L.C.Received on Sat Oct 20 2001 - 16:53:48 CDT