create procedure read_address  (lastname char(15))
	returning char(15), char(15), char(20), char(15),char(2), char(5);
	define p_fname, p_city char(15);
	define p_add char(20);
	define p_state char(2);
	define p_zip char(5); 
	select fname,  address1, city, state, zipcode
		into p_fname,  p_add, p_city, p_state, p_zip
		from customer
		where lname = lastname;

	return p_fname, lastname, p_add, p_city, p_state, p_zip;

end procedure;
