MSCEWI3104

Unusable collection variable

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

Severity

High

Description

Oracle collections are not currently supported by SnowConvert, all the collection types variables and their usages will be commented out.

Example Code

Input Code:

CREATE OR REPLACE PROCEDURE collection_variable_sample_proc
IS
    TYPE POPULATION IS TABLE OF NUMBER INDEX BY VARCHAR2(64); --Associative array
    city_population POPULATION := POPULATION();
    i  VARCHAR2(64);
BEGIN
	city_population('Smallville')  := 2000;
    city_population('Midland')     := 750000;

    i := city_population.FIRST;
    i := city_population.NEXT(1);
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.collection_variable_sample_proc ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
   // REGION SnowConvert Helpers Code

   /* ** MSC-ERROR - MSCEWI3072 - PROCEDURAL MEMBER TYPE DEFINITION NOT SUPPORTED. ** */
   /*     TYPE POPULATION IS TABLE OF NUMBER INDEX BY VARCHAR2(64) */
   ;
   /* ** MSC-ERROR - MSCEWI3104 - UNUSABLE COLLECTION VARIABLE, ITS TYPE WAS NOT TRANSFORMED ** */
   /*     city_population POPULATION := POPULATION() */
   ;
   let I;
   /* ** MSC-ERROR - MSCEWI3104 - UNUSABLE COLLECTION VARIABLE, ITS TYPE WAS NOT TRANSFORMED ** */
   /* 	city_population('Smallville')  := 2000 */
   ;
   /* ** MSC-ERROR - MSCEWI3104 - UNUSABLE COLLECTION VARIABLE, ITS TYPE WAS NOT TRANSFORMED ** */
   /*     city_population('Midland')     := 750000 */
   ;
   I = /*** MSC-ERROR - MSCEWI3104 - UNUSABLE COLLECTION VARIABLE, ITS TYPE WAS NOT TRANSFORMED ***/
 /*city_population.FIRST*/
 null;
   I = /*** MSC-ERROR - MSCEWI3104 - UNUSABLE COLLECTION VARIABLE, ITS TYPE WAS NOT TRANSFORMED ***/
 /*city_population.NEXT(1)*/
 null;
$$;

Recommendations

• No end-user action is required.

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