drop procedure if exists selectintoproc
//
create procedure selectintoproc(OUT p_out VARCHAR(10))
begin
      
   declare l_emp_name varchar(30);
   
   select emp_name into l_emp_name from emps;
    
   set p_out := l_emp_name;
   
end;
//