The data types of corresponding columns are not compatible

if(typ='A') then
INSERT INTO emp(empno, NAME, typ, rate, hrs)
VALUES (@empno, @NAME, @typ, @rate, @hrs);
FETCH Cur INTO @empno, @NAME, @typ, @rate, @hrs;

elseif(typ='B') then
INSERT INTO emp(empno, NAME, typ, ans, comm)
VALUES (@empno, @NAME, @typ, @ans, @comm);
FETCH Cur INTO @empno, @NAME, @typ, @ans, @comm;
end if;

error//The data types of corresponding columns are not compatible in a fullselect that includes a set operator or in the multiple rows of a VALUES clause of an INSERT or fullselect.

how and where will i cast values? in what statements?
Edit/Delete Message