set serveroutput on

declare
	cursor instruct_cur IS
		select instructor_id, count(*) total_sec
		from section
		group by instructor_id;
		
	v_name varchar2(30);
	e_too_many_sections EXCEPTION;
	
begin
	for instruct_rec IN instruct_cur LOOP
	--inner block
	--BEGIN
		if instruct_rec.total_sec >= 10 THEN
			RAISE e_too_many_sections;
		else
			select rtrim(first_name)||' '||rtrim(last_name)
				into v_name
				from instructor
				where instructor_id = instruct_rec.instructor_id;
				
			DBMS_OUTPUT.PUT_LINE('Instructor, '||v_name||', teaches '|| instruct_rec.total_sec||' sections');
		end if;
	exception
		when e_too_many_sections THEN
	DBMS_output.put_line('this instructor teaches too much');
	--END; 
	-- end inner block
	end loop;
END;

/