ORA-01438: value larger .. Which column has the error :

[3ALAYA]

Hi ..

Iam trying to do so >>

Insert into LOANS
(LOAN_CODE,LOAN _BALANCE,LENDED _TO,LONED_BY,IN TREST_PERCENTAG E,BR_CODE)
Values
(200,100000,'AL YA','BUHAIRA',2 ,101)

this is the table DESC ..



How can I know Which column has the error :

I see every thing is fine !!!!

[rski]

I guess number(2,2) (column interest_percen tage) which allows only decimal numbers and you try to put here '2'.
Am I right?

[3ALAYA]

thank you very much ,,

I have change the value of interest_percen tage (4,2)

and it worked

^_^