declare
cursor stu_cur is
select stuname,stuscore,stubody from students where stuprofess=&pro;
stu_rec stu_cur%rowtype;
null_stubody exception;
begin
open stu_cur;
fetch stu_cur into stu_rec;
while stu_cur%found
Loop
if stu_rec.stubody is null
then
close stu_cur;
raise null_stubody;
end if;
insert into temp values(stu_rec.stuname,stu_rec.stuscore);
fetch stu_cur into stu_rec;
end loop;
close stu_cur;
exception
when null_stubody then
open stu_cur;
loop
fetch stu_cur into stu_rec;
exit when stu_cur%notfound;
if stu_rec.stubody is not null
then
insert into temp values(stu_rec.stuname,stu_rec.stuscore);
end if;
end loop;
close stu_cur;
commit;
end出现了下面这种问题该怎么解决啊ORA-06550: 第 36 行, 第 0 列:
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
; <an identifier>
<a double-quoted delimited-identifier>
符号 ";" 被替换为 "end-of-file" 后继续。
cursor stu_cur is
select stuname,stuscore,stubody from students where stuprofess=&pro;
stu_rec stu_cur%rowtype;
null_stubody exception;
begin
open stu_cur;
fetch stu_cur into stu_rec;
while stu_cur%found
Loop
if stu_rec.stubody is null
then
close stu_cur;
raise null_stubody;
end if;
insert into temp values(stu_rec.stuname,stu_rec.stuscore);
fetch stu_cur into stu_rec;
end loop;
close stu_cur;
exception
when null_stubody then
open stu_cur;
loop
fetch stu_cur into stu_rec;
exit when stu_cur%notfound;
if stu_rec.stubody is not null
then
insert into temp values(stu_rec.stuname,stu_rec.stuscore);
end if;
end loop;
close stu_cur;
commit;
end出现了下面这种问题该怎么解决啊ORA-06550: 第 36 行, 第 0 列:
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
; <an identifier>
<a double-quoted delimited-identifier>
符号 ";" 被替换为 "end-of-file" 后继续。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货