Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q:SQL*Loader number format
"Ralf Bender" <ralf.bender_at_arcor.de> wrote in message
news:41b87c71$0$16034$9b4e6d93_at_newsread4.arcor-online.net...
> Hello
>
> I've got a big flat file with # as separator.
> There is a number field which has negative sign at the end or nothing if
> it is a positive number:
>
> D#100,00#100,00#BET
> S#100,00-#100,00-#WISH
>
> In the database the field is a number(15,2)
>
> I try to load this file with sql-loader, but earn always errors like
> invalid number ...
>
> I try (seen at ask tom)
> column_name "to_number( :column_name, '9999999999s' )/100",
> or
> column_name "to_number( :column_name, '99999999D99MI' )",
>
> nothing works correctly. In some cases i got the positive numbers but
> not the negative ones.
>
> Is there someone who can help me to climb this little rock?
>
> thanks
> ralf
It might be choking on the commas due to NLS incompatibility Received on Thu Dec 09 2004 - 11:36:07 CST
![]() |
![]() |