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

From: <Joey.Dantoni_at_gmail.com>
Date: Tue, 7 Oct 2008 07:14:22 -0700 (PDT)
Message-ID: <d4745c5a-17f3-49d9-8187-e8e519f7a56a@k7g2000hsd.googlegroups.com>


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?

SQL> create table x (x char(14));

Table created.

SQL> insert into x (x) Values ('abcdefghijklm');

1 row created.

SQL> insert into x (x) Values ('abcdefghijklmn');

1 row created.

SQL> insert into x (x) Values ('abcdefghijklmnop'); insert into x (x) Values ('abcdefghijklmnop')

                          *

ERROR at line 1:
ORA-12899: value too large for column "OPS$ORACLE"."X"."X" (actual: 16,
maximum: 14) Received on Tue Oct 07 2008 - 09:14:22 CDT

Original text of this message