MSCEWI1078

Output parameters are not supported by Snowflake Scripting

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

This EWI is deprecated, for more information on this issue referred to MSCEWI1083

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 [email protected]