plsql/cursors处理异常并返回执行流程

发布于 2024-12-22 02:58:39 字数 524 浏览 1 评论 0原文

我正在尝试执行游标并希望它完成循环，即使存在一些异常。

我想做的是“捕获”所有异常，并可能记录一些内容或不执行任何操作，然后返回到流程。代码如下所示：

 FOR line IN my_cursor
 LOOP
 begin
        
    if<condition> then
      GOTO pass; 
    else     
     <<do_something>>
     exception
       when others then
        sys.dbms_output.put_line('say something');       
    end if;  

    <<pass>> null;
 end
 END LOOP;

脚本无法编译。

例外情况可能存在一些语法错误，但我也不太了解语义。就像我不确定处理异常后是否可以返回执行流程。

ps：DB是10g，里面没有CONTINUE。因此使用GOTO。

原文

I am trying to execute a cursor and want it to complete the loop even if there is some exception.

What I trying to do is "catch" all the exception and probably log something or do nothing and then return back to the flow . Here is how the code looks like:

 FOR line IN my_cursor
 LOOP
 begin
        
    if<condition> then
      GOTO pass; 
    else     
     <<do_something>>
     exception
       when others then
        sys.dbms_output.put_line('say something');       
    end if;  

    <<pass>> null;
 end
 END LOOP;

The script doesn't compile.

There is probably some syntax error with the exception, but I am also not aware of semantics very well. Like I am not sure if you can return back to execution flow after handling an exception.

p.s: The DB is 10g and there is not CONTINUE in it. Hence using GOTO.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

九八野马 2024-12-29 02:58:39

将要在循环中执行的代码放入其自己的块中，然后您可以使用该块异常部分来处理循环迭代期间的任何问题。

一旦处理了该迭代的异常，下一个循环迭代将开始，

例如：

for line in my_cursor
loop
   begin    
      <<do_something>>
   exception
      <<do_exception_processing>>        
   end;
end loop;

为了进一步说明这一点，在下面的示例中，我声明了一个异常类型的局部变量。我循环遍历数字 1 到 10，在第二次循环迭代期间，if 语句为 true，并且处理传递到异常处理程序。处理异常后，循环的下一次迭代开始。

begin

   for i in 1 .. 10 
   loop

      declare

         my_exception exception;

      begin

         if i = 2
         then

            -- if you need to do some processing then you would enter it
            -- here and then when you want to enter the exception section 
            -- you would add the line below 

            raise my_exception;

         end if;

      exception
         when my_exception then
            dbms_output.put_line('in exception section');

      end;

   end loop;

end;

Put the code that you want to execute within the loop in it's own block and then you can use that blocks exception section to handle any problems during the loop iteration.

Once the exception for that iteration is handled, the next loop iteration will start

e.g.:

for line in my_cursor
loop
   begin    
      <<do_something>>
   exception
      <<do_exception_processing>>        
   end;
end loop;

To illustrate this further, in the example below, I have declared a local variable of type exception. I am looping through numbers 1 to 10, during the second loop iteration, the if statement is true and processing passes to the exception handler. Once the exception is handled, the next iteration of the loop begins.

begin

   for i in 1 .. 10 
   loop

      declare

         my_exception exception;

      begin

         if i = 2
         then

            -- if you need to do some processing then you would enter it
            -- here and then when you want to enter the exception section 
            -- you would add the line below 

            raise my_exception;

         end if;

      exception
         when my_exception then
            dbms_output.put_line('in exception section');

      end;

   end loop;

end;

回复收藏 0 原文

萝莉病 2024-12-29 02:58:39

FOR line IN my_cursor  
LOOP
  if not some_condition then
    begin
      do_something;
    exception     
      when others then log_my_error(); -- this should be something that uses
                                       -- an autonomous transaction
    end;
  end if;
END LOOP;

FOR line IN my_cursor  
LOOP
  if not some_condition then
    begin
      do_something;
    exception     
      when others then log_my_error(); -- this should be something that uses
                                       -- an autonomous transaction
    end;
  end if;
END LOOP;

回复收藏 0 原文

够运 2024-12-29 02:58:39

 BEGIN 
 FOR Line in My_Cursor LOOP
    IF condition THEN
 BEGIN
    do something...
 END;
    ELSE 
 BEGIN
    do something...
 END;
    END IF;
 END LOOP;
 EXCEPTION
 WHEN OTHERS THEN
 DBMS_OUTPUT.PUT_LINE('say something');
 END;

 BEGIN 
 FOR Line in My_Cursor LOOP
    IF condition THEN
 BEGIN
    do something...
 END;
    ELSE 
 BEGIN
    do something...
 END;
    END IF;
 END LOOP;
 EXCEPTION
 WHEN OTHERS THEN
 DBMS_OUTPUT.PUT_LINE('say something');
 END;

回复收藏 0 原文

~没有更多了~