is
n_Status int;--状态
v_n number;
begin
select count(*) into v_n from acctstat
where billingcyclid=sz_billingcyclid
if v_n>0 then
n_Status int;--状态
v_n number;
begin
select count(*) into v_n from acctstat
where billingcyclid=sz_billingcyclid
if v_n>0 then
先看一下PL/SQL的文档就知道了.