oracle游标出现符号"end-of-file"在需要下列之一时.declarecursorcurstu5(varsnameinvarchar2:='张华')isselects#,addrfromstu5wheresname=varsname;

Question

oracle游标出现符号 "end-of-file"在需要下列之一时.
declare
cursor cur_stu5 (var_sname in varchar2:='张华' )
is select s#,addr from stu5 where sname=var_sname ;

Answer 1

declare
cursor cur_stu5 (var_sname in varchar2:='张华' )
is
select s#,addr from stu5 where sname=var_sname ;
begin
null
end;
少了begin...end游标不完整.