Links

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.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.