MSCEWI3052

Exception declaration is handled by the raise function.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

Exceptions can be defined in both languages, Oracle and Snowflake, but the RAISE function is designed to do declaration, assignment, and throw the error. This is why the Exception declaration is commented out and the warning is displayed.

Example Code

Input Code:

CREATE OR REPLACE PROCEDURE EXCEPTION_DECLARATION_SAMPLE AUTHID DEFINER IS
  NEW_EXCEPTION EXCEPTION;
  PRAGMA EXCEPTION_INIT(NEW_EXCEPTION, -63);
BEGIN

  IF true THEN
    RAISE NEW_EXCEPTION;
  END IF;

EXCEPTION
    WHEN NEW_EXCEPTION THEN
        --Handle Exceptions
END;
/

Output Code:

--Basic example with raise
CREATE OR REPLACE PROCEDURE PUBLIC.EXCEPTION_DECLARATION_SAMPLE ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
   //Helpers declaration
   var RAISE = function (code,name,message) {
      var error = new Error(message);
      Object.assign(error,{
         code : code,
         name : name,
         message : message
      })
      SQLCODE = error.code
      SQLERRM = `${error.code}: ${message}`
      throw error;
   };
   {
      /*** MSC-WARNING - MSCEWI3052 - EXCEPTION DECLARATION IS HANDLED BY RAISE FUNCTION ***/
      /*  NEW_EXCEPTION EXCEPTION*/
      ;
      /*** MSC-WARNING - MSCEWI3051 - PRAGMA EXCEPTION_INIT IS NOT SUPPORTED. ERROR CODE IS ASSIGNED IN RAISE CALL ***/
      /*  PRAGMA EXCEPTION_INIT(NEW_EXCEPTION, -63)*/
      ;
      try {
         if (true) {
            RAISE(63,"NEW_EXCEPTION","NEW_EXCEPTION");
         }
      } catch(error) {
         switch(error.name) {
            case `NEW_EXCEPTION`: {
               //Handle Exception
               break;
            }
            default: {
               throw error;
               break;
            }
         }
      }
   }
$$;

Recommendations

• If you need more support, you can email us at [email protected]