Variables Access in Exception Block.

Answered

Follow

0

Chris Shortt

• February 26, 2021 09:38

How hard could it possibly be to expose all declared variables to the exception block?

Would be extremely handy. Please and thank-you.

• Comment actions Permalink

  Official comment

  

  Niklas Schmidtmer

  • March 01, 2021 13:14

  Hi Chris,

   

  thanks for your request. Variables are local to the block in which they were defined. Let's consider this example:

  BEGIN
      DECLARE STRING myVar = 'demo';
  EXCEPTION e
      SELECT myVar;
  END;;

  This snippet throws an error as two blocks are defined here: 1) between BEGIN and EXCEPTION, and 2) between EXCEPTION and END. Variables defined in the first block are not visible in the second one.

   

  If you wish to make variables visible in a broader scope, you can use nested blocks. This example works:

  BEGIN
      DECLARE STRING myVar;
  
      BEGIN
          myVar = 'demo';
          RAISE SQLEXCEPTION 123;
      EXCEPTION e
          SELECT myVar;
      END
  END;;

   

  Best regards

   

  Niklas

• 0

  Comment actions Permalink

  

  Chris Shortt

  • March 02, 2021 07:45

  Hi Niklas,

  Ok. Not ideal, but easy enough to work with.

  Thanks.

  Chris

Please sign in to leave a comment.