MSCEWI1078

Output parameters are not supported by Snowflake Scripting

Severity

Medium

Description

Snowflake procedures do not support output parameters.

Example Code

Oracle:

CREATE PROCEDURE procedure1(param_output OUT NUMBER)
AS
BEGIN
    NULL;
END;

Snowflake Scripting:

CREATE OR REPLACE PROCEDURE PUBLIC.procedure1 (param_output NUMBER (38,18) /*** MSC-ERROR - MSCEWI1078 - OUTPUT PARAMETERS ARE NOT SUPPORTED BY SNOWFLAKE SCRIPTING ***/)
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
   BEGIN
      NULL;
   END;
$$;

Recommendations

  • A possible workaround for output parameters could be to declare the parameter as a variable and return the variable, however, only one variable can be returned per stored procedure.

  • If you need more support, you can email us at snowconvert-support@snowflake.com

Last updated