MSCEWI3126

Unusable object because its built-in custom type is not supported

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

This error appears to indicate whether an object with a built-in custom type is being used.

Example Code

Input Code

CREATE OR REPLACE PROCEDURE proc01 is
   var1 DBMS_SQL.VARCHAR2_TABLE;
   var2 CTX_CLS.DOC_TAB;
BEGIN 
   varX := var1.property;
   varY := var2(1);
END; 

Output Code

CREATE OR REPLACE PROCEDURE PUBLIC.proc01 ()
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
   DECLARE
      var1 VARIANT /*** MSC-WARNING - MSCEWI3125 - BUILT-IN PACKAGE'S CUSTOM TYPE 'DBMS_SQL.VARCHAR2_TABLE' CHANGED TO VARIANT ***/;
      var2 VARIANT /*** MSC-WARNING - MSCEWI3125 - BUILT-IN PACKAGE'S CUSTOM TYPE 'CTX_CLS.DOC_TAB' CHANGED TO VARIANT ***/;
   BEGIN
      varX := null /*var1.property*/ /*** MSC-ERROR - MSCEWI3126 - UNUSABLE OBJECT var1, BUILT-IN CUSTOM TYPES ARE NOT SUPPORTED ***/;
      varY := null /*var2(1)*/ /*** MSC-ERROR - MSCEWI3126 - UNUSABLE OBJECT var2, BUILT-IN CUSTOM TYPES ARE NOT SUPPORTED ***/;
   END;
$$;

Recommendations

• No end-user actions are required.

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