Error :: Value larger than specified precision allows for this column.

From: Shashi Shekher <shashi.shekher_at_oracle.com>
Date: Sat, 10 Feb 2001 20:20:17 -0800
Message-ID: <3A861301.345F1F1A@oracle.com>

The following query is returning me errors. I dont know why. I just modified the column
status_id from number(3) to number(5) and it is the primary key on this table. There are no
triggers on this table. Has Anyone faced this kind of problem before.

insert into status_codes (status_id, description, help_id) values (9999, 'test', 1);

STATUS_ID                                                         NOT
NULL NUMBER(5)
DESCRIPTION                                                    NOT NULL
VARCHAR2(100)
HELP_ID                                                              NOT

NULL NUMBER(5) ORA-00604: error occurred at recursive SQL level 1 ORA-01438: value larger than specified precision allows for this column.

Any suggestions will be greatly appreciated.

Shashi Received on Sat Feb 10 2001 - 22:20:17 CST