CREATE OR REPLACE PROCEDURE empupdate (
   p_deptid    IN       NUMBER := '&DepartmentNo',
   p_empname   OUT      VARCHAR2,
   p_jobid     OUT      VARCHAR2,
   v_salary    OUT      NUMBER,
   p_per       IN 		Number:='$sal_increase'
)
AS
   v_variable   VARCHAR2 (30);
BEGIN
   SELECT salary
     INTO v_salary
     FROM employees;
   IF p_deptid=department_id
   THEN
      v_salary=v_salary+p_per
      DBMS_OUTPUT.put_line (p_empname || '' || v_salary);
   END IF;
END;