Re: ORA-01401: inserted value too large for column

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 25 Feb 2005 10:09:39 +0000
Message-ID: <7765c89705022502097cb06efc@mail.gmail.com>

You learn something new every day. Knocking up a demo of trapping the triggering statement for a 1401 (since we've had similar questions twice recently) I stumbled across the fact that we can add 'upgrade to 10g' to my list of fixes

SQL>create table xxx (a number(2), b varchar2(5));

Table created.

SQL>insert into xxx values (12, 'abcdef'); insert into xxx values (12, 'abcdef')

                            *

ERROR at line 1:
ORA-12899: value too large for column "OPS$ACDOMAIN\N-LITCHFIELD"."XXX"."B" (actual: 6, maximum: 5)

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 25 2005 - 05:12:48 CST