Re: Error while trying to INSERT RECORD -ORA-1400

You must use the update statment instead of the insert statment in the procedure give_bonus.

So replace the insert statement into:

update emp
set comm = v_bonus
where empno = empno_in;

Maikel Received on Thu Jun 19 1997 - 00:00:00 CDT