SSC-EWI-OR0129

TYPE attribute could not be resolved.

Severity

Low

Some parts of the output code are omitted for clarity reasons.

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:

IN -> Oracle_01.sql

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

Output Code:

OUT -> Oracle_01.sql

CREATE OR REPLACE PROCEDURE procedure01 ()
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
EXECUTE AS CALLER
AS
$$
DECLARE
var1 VARIANT !!!RESOLVE EWI!!! /*** SSC-EWI-OR0129 - 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 [e-mail]