when others then
dbms_output.put_line('students count is fine at present!!!!');

when others then
dbms_output.put_line('students count is fine at present!!!!');

CREATE OR REPLACE PROCEDURE Limit
     (p_No   IN NUMBER,
      p_dep  IN VARCHAR2)
IS
  v_Cur      Classes.Current_Students%TYPE;
  v_Max      Classes.Max_Students%TYPE;
  e_TooMany  EXCEPTION;
BEGIN
  SELECT Current_Students,
         Max_Students
  INTO   v_Cur,
         v_Max
  FROM   Classes
  WHERE  Department = 'p_dep'
         AND Course = p_No;
  
  IF v_Cur > v_Max THEN
    RAISE e_TooMany;
  END IF;
EXCEPTION
  WHEN e_TooMany THEN
    dbms_Output.Put_Line('There are currently '
                         ||v_Cur
                         ||' no of students which is higher than the limit of '
                         ||v_Max);
END;
/

exec limit(101,'HIS');

BEGIN limit(101,'HIS'); END;

*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SCOTT.LIMIT", line 6
ORA-06512: at line 1

SQL> set serveroutput on
SQL> exec limit(101,'HIS');
There are currently 99 no of students which is higher than the limit of 30

PL/SQL procedure successfully completed.

CREATE OR REPLACE PROCEDURE Limit_Violation
     (p_No   NUMBER,
      p_dep  VARCHAR2)
IS
  v_Cur  Classes.Current_Students%TYPE;
  v_Max  Classes.Max_Students%TYPE;
BEGIN
  SELECT Current_Students,
         Max_Students
  INTO   v_Cur,
         v_Max
  FROM   Classes
  WHERE  Department = p_dep
         AND Course = p_No
         AND Current_Students > Max_Students;
  
  dbms_Output.Put_Line('For department '
                       ||p_dep
                       ||' current students count is '
                       ||v_Cur
                       ||' which is a violation of max student limit of '
                       ||v_Max);
EXCEPTION
  WHEN No_Data_Found THEN
    dbms_Output.Put_Line('The total student count is normal!!');
END;
/

SQL> exec limit_violation(101,'HIS');
For department HIS current students count is 99 which is a violation of max
student limit of 30

PL/SQL procedure successfully completed.