Re: ORA-12899: value too large for column with Oracle Patch 10.2.0.4
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Tue, 07 Oct 2008 21:23:34 +0200
Message-ID: <6l1r9lFa76mqU1@mid.individual.net>
>
> <snip>
>
> Perhaps this is a character set problem. The OP had a .it email, but the
> text in the OP looked German (??). Either way, probably requires a
> multibyte characterset to represent and maybe that got hosed in the
> upgrade somehow?
Date: Tue, 07 Oct 2008 21:23:34 +0200
Message-ID: <6l1r9lFa76mqU1@mid.individual.net>
On 07.10.2008 18:30, Aya the Vampire Slayer wrote:
> Joey.Dantoni_at_gmail.com <Joey.Dantoni_at_gmail.com> wa:
>> I tried to recreate your issue on 10.2.0.4 HP-Itanium. The only place >> I got the error, it was legitimate. Is there any chance your input >> data has changed?
>
> <snip>
>
> Perhaps this is a character set problem. The OP had a .it email, but the
> text in the OP looked German (??). Either way, probably requires a
> multibyte characterset to represent and maybe that got hosed in the
> upgrade somehow?
In a DATE column? Hm... I could also imagine some trigger implementation issues. Maybe there is another trigger that's firing as well. Reminds me of [1], especially item 2.
Cheers
robert
[1] http://rwijk.blogspot.com/2007/09/database-triggers-are-evil.html Received on Tue Oct 07 2008 - 14:23:34 CDT