BEGIN
select task_cost_hour FROM apx_p_tasks;
IF task_cost_hour = 0 THEN
select itstaff_cost_hour from apx_p_itstaff;
update apx_p_tasks
set task_cost_hour = itstaff_cost_hour;
END_IF;
END;
error line 8 ora-06550 line 8 column 5
pls-0013 encoutered the sysmbol 2;" WHEN EXPECTING ONE OF THE FOLLOWING IF
Do someone help me?
thanks
mfo