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