Hello
Maybe somebody had this problem before and knows what it could mean.
In the project I work for, we get a dump from another company regularly.
There are several tables with lots of attributes, most of them varchar(2),
even if they contain a date or a number, so we must use the to_number
function a lot.
We never had any problems with it until yesterday. Some (but not all) of the
fields in a column returned a sql-error (ORA-01722 invalid number) when we
tried to use to_number on it. All fields have the format 99.99. Finally, we
had to replace the '.' with a ',' but only for a few elements.
The dump is created by several batches from a oracle 8i (1.0.6) db. So this
could cause character problems, still I do not understand how it is possible
that this applies only to a few elements and others in the same column of
the same table behave differently.
I hope I could explain the problem clearly enough and I would be glad to
know if anybody encountered something like this before and could tell me how
such a thing is possible.
Thank you
fabienne
Received on Sat Jun 15 2002 - 02:37:46 CDT
