CREATE PROCEDURE sale6(in eno,out salar int(10)) BEGIN select salary into salar from employee where ssn = eno; END //