为什么执行完过程,表中没有数据?
我有一个存储过程
create or replace procedure tttt
(begintime in date,
endtime in date)
as
lnum number;
cursor num_pay_cur is
select distinct pay_num from t_payment
where Fee_Prj_ID = '01'
and PAYMENT_TIME>=begintime
and PAYMENT_TIME<endtime;
begin
-- Test statements here
open num_pay_cur;
fetch num_pay_cur into lnum;
while num_pay_cur%found
loop
insert into watch_pay_total (pay_num) values (lnum);
fetch num_pay_cur into lnum;
end loop;
close num_pay_cur;
end;
执行完后,没有提示我输入变量值,最后也没有结果。请问高手,我错在哪里?
(在线等待)