Links

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.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.