oracle 以数据行传递参数

  begin

  for cur_ct_swapcontract in (select * from ct_swapcontract where datbegindate <= sysdate-1 and datenddate + numgraceperiod >= trunc(sysdate) order by datbegindate,numcontractguid ) loop

      CBILL.cp_swapmonitor_mail(cur_ct_swapcontract,sysdate);

  end loop;

  end;"

 

 

 

 

 

 

create or replace

procedure       cp_swapmonitor_mail(p_contract in ct_swapcontract%rowtype,p_date in date)

  is

begin

null;

end cp_swapmonitor_mail;