急呀!我用的是PB8.03发现以下的程序,定义的游标在DO...LOOP一直的循环,为什么?
declare select_information cursor for
select id from kh_information where personel_id=:personel_information.id
and gc_type_id=:type_id;
open select_information;
fetch select_information into :khid;
do while sqlca.sqlcode<>100
insert into temp_erea
(username,userpassword,
name,nameid,
typename,typeid,kh_id)
values (:personel_information.login_name,:personel_information.login_password,
:personel_information.name,:personel_information.id,
:type_name,:type_id,:khid );
commit;
fetch select_information into :khid;
loop
close select_information;