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]

Last updated