when no_data_found异常出错?
create or replace procedure exception_test
as
vid int;
vname varchar2(20);
cursor gettest is select * from test;
begin
open gettest;
loop
fetch gettest into vid,vname ;
--insert data
-- if vYTYW > 0 then
-- end if ;
exit when gettest %notfound ;
end loop ;
EXCEPTION WHEN NO_DATA_FOUND THEN
dbms_output.put_line("no data found") ;
end;
编译时说NO_DATA_FOUND没有定义,这是怎么回事啊