drop procedure if exists cursorproc
//
create procedure cursorproc(IN p_in INT, OUT p_out VARCHAR(30))
begin
   
   declare l_emp_name VARCHAR(30);
   declare cur_1 cursor for select emp_name from emps where emp_id = p_in;
   
   open cur_1;
   fetch cur_1 into l_emp_name;
   close cur_1;
   
   set p_out = l_emp_name;
   
end;
//