MSCEWI3125

Built-in packages custom types changed to variant

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

Severity

Low

Description

This warning appears to indicate whether a built-in package custom type is changed to a VARIANTdata type.

Example Code

Input Code

CREATE OR REPLACE PROCEDURE proc01 is
   var1 DBMS_SQL.VARCHAR2_TABLE;
BEGIN 
 NULL;
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 ***/;
   BEGIN
      NULL;
   END;
$$;

Recommendations

• No end-user actions are required.

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