Hi
When you are declaring table the table, make use of numeric data type properly. It can be like below
create table temp1
(
weight numeric(3,2),
height numeric (3,2),
bmi numeric(7,7)
);
Generally weight and height have decimal values. So when you are inserting data into the table that you have declared (i'm refering to the table syntax you have writen), we will get the below error
Arithmetic overflow error converting numeric to data type numeric.
I think the problem is with table declaration