Comment on page

MSCEWI1052

Unusable object

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]​

MSCEWI1051

MSCEWI1053