Set ServerOutput ON;
CREATE or REPLACE PROCEDURE Get_TLoad (Faculty_ID number, SchoolYear number) IS
ClassNum Number;

BEGIN
  SELECT Count(*) Into ClassNum
  From Offering
  Where SchoolYear = OffYear And Faculty_ID = FacSSN
  Group By CourseNo;
  DBMS_OUTPUT.PUT_LINE('Professor with ID ' || Faculty_ID || ' is teaching ' || ClassNum || ' classes in ' || SchoolYear);
End;
/

Select Get_TLoad (9002, 2017) From Dual;