oracle rowtype

v_customer customerinfo%rowtype;
select *
into v_customer
from customerinfo
where guid = v_loan.customerguid;