DECLARE
  V_Deptno Dept.Deptno%TYPE;
  V_Sal Emp.Sal%TYPE;
  E_Exception EXCEPTION;
BEGIN
  V_Deptno :=&GiveDeptno;
  V_Sal :=&GiveIncreaseSal;
  UPDATE Emp
   SET
   Sal =Sal+V_Sal
   WHERE Deptno = V_Deptno;
  IF SQL%NOTFOUND THEN
    RAISE E_Exception;
  ELSE
    DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT||' rows updated.');
  END IF;
EXCEPTION
  WHEN E_Exception THEN
    DBMS_OUTPUT.PUT_LINE('Deptno Not Found. Delete is Unsuccessful.');
END;
/

Enter value for givedeptno: 10
Enter value for giveincreasesal: 200
3 rows updated.                                                                 

PL/SQL procedure successfully completed.

SQL> /
Enter value for givedeptno: 60
Enter value for giveincreasesal: 200
Deptno Not Found. Delete is Unsuccessful.                                       

PL/SQL procedure successfully completed.

SQL> ROLLBACK;

Rollback complete.