create or replace procedure p_get_kind_fee_lx(v_fee number) is
begin
for id in (select t.user_id,t.service_kind,t.fee_date from tb_fee_kind_t t where t.service_kind in(8,9) and t.fee_date=to_char(add_months(sysdate,-1),'yyyymm'))
loop
if id.service_kind=9 then
select nvl(sum(t.fee1+t.fee2+t.fee3+t.fee4+t.fee11+t.fee12+t.fee13+t.fee14),0)
into v_fee
from bf_gather_fee_his_t t
where t.user_id=id.user_id
and t.fee_date=id.fee_date
and t.service_kind=9
and t.fee_kind=170;
else
select nvl(sum(t.fee1+t.fee2+t.fee3+t.fee4+t.fee11+t.fee12+t.fee13+t.fee14),0)
into v_fee
from bf_gather_fee_his_t t
where t.user_id=id.user_id
and t.fee_date=id.fee_date
and t.service_kind=8
and t.fee_kind=183;
end if;
update tb_kind_fee_t t set t.lx_fee=v_fee where t.user_id=id.user_id and t.fee_date=to_char(add_months(sysdate,-1),'yyyymm');
end loop;
commit;
end p_get_kind_fee_lx;为什么在执行时有这样的错误:Compilation errors for PROCEDURE XY_JSB.P_GET_KIND_FEE_LXError: PLS-00403: 表达式 'V_FEE' 不能作为 SELECT/FETCH 语句的 INTO 目标
Line: 12
Text: into v_feeError: PLS-00403: 表达式 'V_FEE' 不能作为 SELECT/FETCH 语句的 INTO 目标
Line: 28
Text: into v_fee该怎么解决?
begin
for id in (select t.user_id,t.service_kind,t.fee_date from tb_fee_kind_t t where t.service_kind in(8,9) and t.fee_date=to_char(add_months(sysdate,-1),'yyyymm'))
loop
if id.service_kind=9 then
select nvl(sum(t.fee1+t.fee2+t.fee3+t.fee4+t.fee11+t.fee12+t.fee13+t.fee14),0)
into v_fee
from bf_gather_fee_his_t t
where t.user_id=id.user_id
and t.fee_date=id.fee_date
and t.service_kind=9
and t.fee_kind=170;
else
select nvl(sum(t.fee1+t.fee2+t.fee3+t.fee4+t.fee11+t.fee12+t.fee13+t.fee14),0)
into v_fee
from bf_gather_fee_his_t t
where t.user_id=id.user_id
and t.fee_date=id.fee_date
and t.service_kind=8
and t.fee_kind=183;
end if;
update tb_kind_fee_t t set t.lx_fee=v_fee where t.user_id=id.user_id and t.fee_date=to_char(add_months(sysdate,-1),'yyyymm');
end loop;
commit;
end p_get_kind_fee_lx;为什么在执行时有这样的错误:Compilation errors for PROCEDURE XY_JSB.P_GET_KIND_FEE_LXError: PLS-00403: 表达式 'V_FEE' 不能作为 SELECT/FETCH 语句的 INTO 目标
Line: 12
Text: into v_feeError: PLS-00403: 表达式 'V_FEE' 不能作为 SELECT/FETCH 语句的 INTO 目标
Line: 28
Text: into v_fee该怎么解决?
create or replace procedure p_get_kind_fee_lx(v_fee number) is
begin ->create or replace procedure p_get_kind_fee_lx is
v_fee number;
begin