drop procedure if exists whereclauseproc
//

create procedure whereclauseproc(OUT p_out VARCHAR(30))
begin

    select emp_name into p_out from emps where emp_id = 1;

end
//