MSCEWI1052
Unusable object
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Medium
Description
This error happens when the source code uses a parameter or variable that is not supported or was not recognized by the conversion tool.
Example code
Input Code (Oracle):
CREATE OR REPLACE PROCEDURE PROCEDURE_PARAMETERS(PARAM SDO_GEOMETRY)
AS
VARIABLE SDO_GEOMETRY;
BEGIN
VARIABLE := PARAM;
END;
Output Code:
CREATE OR REPLACE PROCEDURE PUBLIC.PROCEDURE_PARAMETERS (PARAM VARIANT /*** MSC-ERROR - MSCEWI1051 - UNRECOGNIZED OR UNSUPPORTED PARAMETER DATA TYPE SDO_GEOMETRY ***/)
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
// HELPER CODE
let VARIABLE;
VARIABLE = PARAM /* ** MSC-ERROR - MSCEWI1052 - UNUSABLE OBJECT PARAM, ITS DATATYPE WAS NOT TRANSFORMED ** */;
$$;
Recommendations
Look for an alternative for the used data type.
If you need more support, you can email us at [email protected]
Last updated