Re: Automated rounding ???

From: TurkBear <noone_at_nowhere.com>
Date: Wed, 20 Jun 2001 12:47:35 -0500
Message-ID: <u8o1jtcjvvjt25g35nl32fijd86s2rpomg@4ax.com>

Perhaps the older DB dump was when the column was defined as number(8,2)[ or some other value] - In other words with a precision parameter - without one, I believe Oracle assumes Integer and will round ( you can 'tell' it to Trunc, but rounding is the default)

Andreas Koch <akoch_at_rbg.informatik.tu-darmstadt.de> wrote:

>Hi,
>
>I just encountered a strange problem with one customes database...
>
>a value entered into a column declared as "number" is automatically
>rounded to a whole number. This can be "ported" via dump-file,
>and no triggers or procedures affect this entry.
>
>The problem was probably caused by some im/exporting action on
>several installed DBs...
>
>Replacing the DB with an old dumpfile solves the problem.
>
>But what causes this?

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Wed Jun 20 2001 - 12:47:35 CDT