MSCEWI1053

Object may not work.

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

Severity

Low

Description

This error happens when the conversion tool could not determine the data type of a variable. This may happen because the declaration of a variable could be missing.

Example code

Input Code (Oracle):

CREATE OR REPLACE PROCEDURE PROCEDURE_VARIABLES
AS
    VARIABLE INTEGER;
BEGIN
    VARIABLE := ANOTHER_VARIABLE;
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.PROCEDURE_VARIABLES ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
   // Snowconvert Helper region

   let VARIABLE;
   VARIABLE = ANOTHER_VARIABLE /* ** MSC-WARNING - MSCEWI1053 - OBJECT ANOTHER_VARIABLE MAY NOT WORK PROPERLY, ITS DATATYPE WAS NOT RECOGNIZED ** */;
$$;

Recommendations

• Make sure the input code has the variable declared.

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