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>
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
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