DECLARE t_task_cost_hour NUMBER;
DECLARE v_itstaff_cost_hour NUMBER;
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;
/
ERRORS ... WHY?
DECLARE v_itstaff_cost_hour NUMBER;
ERROR line 2
ORA-06550 line 2 column 1:
PLS-00103 encoutered the symbol "DECLARE" when expecting one of the following...