oracle - 类似于 Oracle PL/SQL block 中的 finally Block (JAVA)

Question

在 Java 中，finally block 在所有条件下都执行。

Oracle PL/SQL 中是否有任何类似的函数，只要过程完成执行，即使使用了 return 语句也会执行？

Answer 1

FINALLY 没有等价物，但您可以使用嵌套的 PL/SQL block 来模拟它；

DECLARE
  -- Your variables.
  return_early BOOLEAN := FALSE;
BEGIN
  -- Do something

  DECLARE
    -- Local variables in "try" block
  BEGIN 
    -- Equivalent of "try" block
    -- Do something that may raise an exception
    IF some_condition THEN
      return_early := TRUE;
      -- you could also use "GOTO end_try;" rather than surrounding the
      -- following statements in an "ELSE" statement
    ELSE
      -- Do something else that may raise an exception
    END IF;
  EXCEPTION
    WHEN your_exception THEN
      -- Equivalent of "catch" block
  END;
  <<end_try>>
  -- Handle "finally" here, after end of nested block.
  -- Note: you can only see variables declared in this outer block
  --       not variables local to the nested PL/SQL block.
  IF return_early THEN
    RETURN;
  END IF;

  -- Continue and do more stuff.
END;
/