Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error :: Value larger than specified precision allows for this column.
>Subject: Error :: Value larger than specified precision allows for this
>column.
>From: Shashi Shekher shashi.shekher_at_oracle.com
>Date: 2/11/01 4:20 AM GMT Standard Time
>Message-id: <3A861301.345F1F1A_at_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
>
>
>
>
>
>
Hi Shashi,
Did you rebuild the primary key after you had modified the column ? It may
not be the cause but I would say that it's worth doing so if you haven't
already.
Regards,
Rob
Received on Mon Feb 12 2001 - 18:09:18 CST