drop procedure if exists selectintoproc
//
create procedure selectintoproc(OUT p_out VARCHAR(10))
begin
     
   select emp_name into p_out from emps limit 1;   
   
end;
//