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

From: yossarian <>
Date: Tue, 07 Oct 2008 15:50:58 +0200
Message-ID: <48eb6943$0$11387$>

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.

Excuse me?

$ sqlplus scott/tiger_at_zen1

SQL*Plus: Release - Production on Tue Oct 7 15:48:20 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Release - Production

scott_at_ZEN1> create table x ( x varchar2(2) ) ;

Table created.

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

Original text of this message