PAVKATA

CREATE OR REPLACE PROCEDURE EMPL_UPD
  (v_employee_id employee.employee_id%TYPE,
  v_employee_phone employee.employee_phone%TYPE,
v_employee_name employee.employee_name%TYPE,
v_role_id employee.role_id%TYPE)
AS
 BEGIN
  UPDATE employee SET employee_phone = v_employee_phone,
                    employee_name =  v_employee_name,
                    role_id = v_role_id
                    WHERE employee_id = v_employee_id;
            END;


    BEGIN
    EMPL_UPD(10,'+375866756569','DINKATA DINEV',6);
    END;