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