drop procedure if exists whereclauseproc
//

create procedure whereclauseproc(IN p_in INT, OUT p_out VARCHAR(30))
begin

    select emp_name into p_out from emps where emp_id = p_in;

end
//