sql2 1507

PROCEDURĘ update_management (company_id_in IN NUMBER) IS

BEGIN

BEGIN

____ UPDATE employee SET salary := salary * .50

WHERE company_id = company_id_in AND title = 'VICE-PRESIDENT';

EXCEPTION

» WHEN NO_DATA_FOUND THEN NULL;

END;

BEGIN

UPDATE employee SET salary := salary * .50 WHERE company_id = company_id_in AND title = 'PRESIDENT';

EXCEPTION

WHEN NO_DATA_FOUND THEN NULL;

END;

END;