declare
str varchar2(100);
type t_sor is ref curosr;
v_sor t_sor;
begin
str:='select distinct tcwfzrefer.TCWFZREFERCWCODE, tcwfzrefer.TCWFZREFERYWNAME
from tcwfzrefer A, '||sTbl1_Out||'
where A.TCWFZREFERCWCODE = '||sTbl1_Out||'.TCWLSPZSUPCODE';
open v_sor for str;
loop
fetch v_sor into ...;
exit when v_sor%notfound;
....
end loop;
close v_sor;
end;
/
str varchar2(100);
type t_sor is ref curosr;
v_sor t_sor;
begin
str:='select distinct tcwfzrefer.TCWFZREFERCWCODE, tcwfzrefer.TCWFZREFERYWNAME
from tcwfzrefer A, '||sTbl1_Out||'
where A.TCWFZREFERCWCODE = '||sTbl1_Out||'.TCWLSPZSUPCODE';
open v_sor for str;
loop
fetch v_sor into ...;
exit when v_sor%notfound;
....
end loop;
close v_sor;
end;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货