MSCEWI1078
Output parameters are not supported by Snowflake Scripting
Medium
Snowflake procedures do not support output parameters.
CREATE PROCEDURE procedure1(param_output OUT NUMBER)
AS
BEGIN
NULL;
END;
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;
$$;
- 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.
Last modified 8mo ago