Re: ORA-12899: value too large for column with Oracle Patch

From: <>
Date: Mon, 31 Dec 2012 04:24:10 -0800 (PST)
Message-ID: <>

On Monday, 15 December 2008 15:01:12 UTC, finite9 wrote:
> On Oct 17, 10:06 am, Yves <> wrote:> Hi, > > did your solution work ? Because we are having the same problem since > we upgraded one of our databases from to (value too > large notifications on programs that haven't changed.  always > triggers).>> Yves Van WertDid anyone get this resolved? I am in the same situation, using an large in-house application suite that has worked (in this scenario) without problems on 8i, 9i (all patch levels) and We have more than 60 customers running this software. Since patching some customers to, we have experienced this issue, where they have not changed the application at all. Our developers have simulated test runs with 10,000 records where only a handful have generated ORA-12899 and the other 9000+ have gone through OK. It is not even the same field that generates the ORA-12899 despite the fact that the same rows are being processed in a batch job with the same trigger. Sometimes it is a date field, but other times, it can be a text field that holds the userid of the session, that is always a fixed length. There are several triggers of the same triggeringevent that exist on the table, but this has not been an issue in the past [pre]. We do not have any non-default NLS settings. This seems lika bug in that has not yet been resolved or even reported, as I cannot find anything useful on Metalink.--andrew

This issue appears to relate to Oracle problem 752716.1 (Oracle Bug 5868257) - see Oracle Metalink for more details. It has been fixed in patch set (and presumably Oracle 11). Received on Mon Dec 31 2012 - 13:24:10 CET

Original text of this message