SQL & PL/SQL

Hi Guys,

I have created a table test with the col value of number(38,127).

I am inserting data and then updating ,While updating I am getting the following error,I am not able to find out the problems with this.Please suggest me





Error starting at line 1 in command:
UPDATE test
SET value=361.6589651
WHERE ID=1
Error report:
SQL Error: ORA-01438: value larger than specified precision allowed for this column
01438. 00000 - "value larger than specified precision allowed for this column"
*Cause: When inserting or updating records, a numeric value was entered
that exceeded the precision defined for the column.
*Action: Enter a value that complies with the numeric column's precision,
or use the MODIFY option with the ALTER TABLE command to expand
the precision.

Sample table


CREATE TABLE test
(id NUMBER
,value NUMBER(38,127));

INSERT INTO test(id)
VALUES(1);

INSERT INTO test(id)
VALUES(2);


INSERT INTO test(id)
VALUES(3);


INSERT INTO test(id)
VALUES(4);

INSERT INTO test(id)
VALUES(5);

commit;

Then the update where the error is coming

UPDATE test
SET value=361.6589651
WHERE ID=1