Re: ORA-12899: value too large for column with Oracle Patch 10.2.0.4
Date: Tue, 07 Oct 2008 15:50:58 +0200
DA Morgan wrote:
> What database product are you actually working with? I can't think,
> though I haven't had coffee yet, of any case in Oracle where one would
> refer to a field as <name>.<name>.<name>. Nor do I understand what
> actual: 13, maximum 7 indicates. Again this doesn't sound like Oracle.
$ sqlplus scott/tiger_at_zen1
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 7 15:48:20 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Oracle Database 10g Release 10.2.0.3.0 - Production
scott_at_ZEN1> create table x ( x varchar2(2) ) ;
scott_at_ZEN1> insert into scott.x values ('foo'); insert into scott.x values ('foo')
ERROR at line 1:
ORA-12899: value too large for column "SCOTT"."X"."X" (actual: 3, maximum: 2)
Y. Received on Tue Oct 07 2008 - 08:50:58 CDT