Links
Comment on page

MSCEWI1053

Object may not work.

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]