ted trochu vazneji.
Doma nemam oracle, takze poradim postup.
dej typ parametru out na rowtype. napriklad.
p_return output mojeschema.mojetabulka%rowtype;
a v procedure dej
select *
into p_return
where id > 10;
a pak muzes vratit recordset, majici vice vet