create or replace function check_chair_work (first_name in varchar2, second_name in varchar2, 
patronymic in varchar2, faculty_name in chairs.faculty_name%type, phone_number out employees.mobile_phone%type)
return boolean 
is 
	result boolean := false;
	--f_code chairs.faculty_code%type;
	f_code integer;
	e_code employees.employee_code%type;

	es employees%rowtype;

	cursor contracts_per_faculty(f_code in number) return contracts%rowtype
	is
		select * from contracts where faculty_code = f_code;
		
	cpf contracts_per_faculty%rowtype;
begin
	dbms_output.put_line(faculty_name);

	select faculty_code 
	into f_code 
	from chairs 
	where trim(chairs.faculty_name) = faculty_name offset 0 rows fetch next 1 rows only;