MSCEWI1051

Unrecognized or unsupported parameter data type

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 has a parameter 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
BEGIN
    null;
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

   null;
$$;

Recommendations

• Look for an alternative for the used data type.

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