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;
$$;
