This is a deprecated version of the SnowConvert documentation, please visit the official site .
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;
$$;