MSCEWI3129

TYPE attribute could not be resolved.

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

Severity

Low

Description

This warning appears when the TYPEattribute referenced item could not be resolved and the referencing item's data type could not be obtained. So the VARIANTdata type will be assigned instead.

Example Code

Input Code

CREATE OR REPLACE PROCEDURE procedure01
IS
var1 table01.col1%TYPE;
BEGIN
NULL;
END;

Output Code

CREATE OR REPLACE PROCEDURE PUBLIC.procedure01 ()
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
DECLARE
var1 VARIANT /*** MSC-WARNING - MSCEWI3129 - TYPE ATTRIBUTE 'table01.col1%TYPE' COULD NOT BE RESOLVED, SO IT WAS TRANSFORMED TO VARIANT ***/;
BEGIN
NULL;
END;
$$;

Recommendations

• Check for the referenced item data type and replace it manually in the referencing item TYPE attribute.

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