Question Locked

Hi all and thanks in advance,

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have the following table but when I insert some values, the program displays an error message it says "(101,'Smith',30000)
ERROR at line 2: ORA-01438: value larger than specified precision allows for this column"

Here are the table and insert value:

CREATE TABLE physican(
phys_Ref_no NUMBER(3) NOT NULL,
phys_name VARCHAR2(6),
phys_salary NUMBER(5,2),
PRIMARY KEY (phys_Ref_no));

INSERT INTO physician VALUES
(101,'Smith',30000);

Help me please.

3 replies

by pekunzip

You have defined phys_salary as
number(5,2) which means that field has
number length 3 with 2 digits.

Fix: change field definition as
NUMBER(7,2).

This discussion is closed to new replies.