Try doing it in a cursour, (it's been a long day, forgive not ful code style)
crteate procedure dummbo (myval in varchar2) is
declare cursor mycursor (myval in varchar2) as
select & from whatever where onefield = myval;
arow mycursor rowtype;
begin
open cursor mycursor
fetch into arow
.....
whatever

end;