create or replace procedure GET_ADDR (
n IN varchar2, addr OUT varchar2) as
begin
	select addr from student where name like n;
end;


