MSCEWI1083

Output parameters are not supported but their functionality is being emulated

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

Severity

Low

Description

This warning is used to inform the output parameters are not supported by Snowflake Scripting but their functionality is being emulated. It is related to the MSCEWI1082 warning.

Example Code

Input

CREATE OR REPLACE PROCEDURE proc_with_output_parameters(param1 OUT NUMBER, param2 IN OUT NUMBER)
IS
BEGIN
param1 := 123;
param2 := 456;
END;

Output

CREATE OR REPLACE PROCEDURE PUBLIC.proc_with_output_parameters (param1 NUMBER (38,18) /*** MSC-WARNING - MSCEWI1083 - OUTPUT PARAMETERS ARE NOT SUPPORTED BUT FUNCTIONALITY IS BEING EMULATED ***/, param2 NUMBER (38,18) /*** MSC-WARNING - MSCEWI1083 - OUTPUT PARAMETERS ARE NOT SUPPORTED BUT FUNCTIONALITY IS BEING EMULATED ***/)
RETURNS TABLE(
param1 NUMBER (38,18),
param2 NUMBER (38,18)
)
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
BEGIN
param1 := 123;
param2 := 456;
/*** MSC-WARNING - MSCEWI1082 - AUTO-GENERATED CODE IN ORDER TO SUPPORT OUT PARAMETERS IN SNOWFLAKE SCRIPTING ***/
LET outParametersResultSet RESULTSET :=
(
SELECT
:param1,
:param2
);
RETURN TABLE(outParametersResultSet);
END;
$$;

Recommendations

• No additional user actions are required.

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