Re: sqlldr problem (invalid number)
From: FC <flavio_at_tin.it>
Date: Wed, 26 Feb 2003 16:18:53 GMT
Message-ID: <NN57a.238429$0v.6669387_at_news1.tin.it>
Date: Wed, 26 Feb 2003 16:18:53 GMT
Message-ID: <NN57a.238429$0v.6669387_at_news1.tin.it>
Which version of Oracle Guido ?
If version is 9 there are some chances to manipulate the numeric value using
a BOUND FILLER field defined at the place where the minus sign occurs,
otherwise you must add to the table a specific field to keep track of minus
signes and adjust numbers using SQL, either during dataload or soon after.
I am fairly sure there are no alternatives, the minus sign is normally found
at the beginning not at the end.
[Quoted] [Quoted] If you could change the format of the file and put the minus sign in the
right place, that would be the best solution.
Bye,
Flavio
Received on Wed Feb 26 2003 - 17:18:53 CET