17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE PROCEDURE testcursor
is
yhjerror EXCEPTION;
myresult INT;
BEGIN
myresult:=1;
declare loopresult INT;
declare
--类型定义
cursor c_job
...
loopresult:=SQL%ROWCOUNT;
IF ((loopresult<>1) OR (loopresult=0)) THEN
BEGIN
myresult:=loopresult;
end;
END IF ;
end loop;
IF ((myresult<>1) OR (myresult=0)) THEN
BEGIN
RAISE yhjerror;
end;
END IF ;
end;
EXCEPTION
...
CREATE OR REPLACE PROCEDURE testcursor
is
yhjerror EXCEPTION;
myresult INT;
BEGIN
myresult:=1;
declare loopresult INT;
declare
--类型定义
cursor c_job
...
loopresult:=SQL%ROWCOUNT;
IF ((loopresult<>1) OR (loopresult=0)) THEN
BEGIN
loopresult:=myresult;
end;
END IF ;
end loop;
IF ((myresult<>1) OR (myresult=0)) THEN
BEGIN
RAISE yhjerror;
end;
END IF ;
end;
EXCEPTION
...