MSC-GP0002

Non-returning Function translated to Stored Procedure.

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

Severity

Low

Description

This warning added to CREATE FUNCTION is for information only when the language used inside is PLPGSQL and the returning type is void

Code Example

Input Code:

CREATE FUNCTION

CREATE FUNCTION FunctionName(id int, comment text) RETURNS void AS $$
    BEGIN
        Select AValue from ATable;
    END;
$$ LANGUAGE plpgsql;

Output Code:

CREATE PROCEDURE

/*** MSC-WARNING - MSC-GP0002 - NON-RETURNING FUNCTION TRANSLATED TO STORED PROCEDURE ***/
CREATE OR REPLACE PROCEDURE FunctionName (id int, comment text) RETURNS STRING
LANGUAGE SQL
AS $$
            BEGIN
                Select AValue from
                    ATable;
                RETURN 'SUCCESS';
            END;
        $$;

Recommendations

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