Re: sqlldr flaking out on ZONED and DECIMAL data
Date: Fri, 16 Mar 2001 02:07:22 GMT
Message-ID: <uzes6.39447$zV3.2901525_at_news1.frmt1.sfba.home.com>
Yes, I think that you are right about big-endian and other differences, this
is why I wanted to know exactly
what values, (and in what bytes) sqlldr is expecting to find. That way, I
could see if the problem is
that my data is wrongly structured, or if my errors are due to improper
specification in my control file.
Oracle documentation does not tell what sqlldr thinks constitutes a valid
ZONED or DECIMAL
number.
thanks for your reply
Mike
Andrew Hardy <nobody_at_spam.from.news.AdvanticaTech.com> wrote in message
news:98q0ci$4q5$1_at_sun-cc204.lut.ac.uk...
> Zoned is of the form:
> value POSITION(n) ZONED(precision, scale),
>
> Decimal is of the form:
> value POSITION(n) DECIMAL (precision, scale)
>
> but... I don't think that ZONED or DECIMAL are portable datatypes i.e. you
> may have problems taking them from one platform to another due to little
and
> big-endian differences.
>
> Andy
>
Received on Fri Mar 16 2001 - 03:07:22 CET