Hello Solomon Yakobson,
following yours recommandations I rewrite the script but:
DECLARE t_task_cost_hour MUNBER;
DECLARE v_itstaff_cost_hour NUMER;
BEGIN
select task_cost_hour INTO t_task_cost_hour FROM apx_p_tasks t;
IF t_task_cost_hour = 0 THEN
select itstaff_cost_hour INTO v_itstaff_cost_hour from apx_p_itstaff v;
update apx_p_tasks
set task_cost_hour = v_itstaff_cost_hour;
END IF;
END;
/
----------------------------------------------------------------------------
ORA-06550 AND PLS-00103 AGAIN ?