MSCEWI3103
For Loop Format Is Currently Not Supported By Snowflake Scripting
Last updated
For Loop Format Is Currently Not Supported By Snowflake Scripting
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
High
Oracle allows different types of conditions for a FOR LOOP
. It supports boolean expressions, collections, records... However, Snowflake scripting only supports FOR LOOP
with defined integers as bounds. All other formats are marked as not supported and require additional manual effort to be transformed.
that are not supported in Snowflake FOR LOOP
:
single_expression_control
values_of_control
indices_of_control
pairs_of_control
cursor_iteration_control
is currently marked as not supported. Removing parenthesis from the expression should transform it as a CURSOR FOR LOOP.
Original:
FOR i IN (cursor_variable) LOOP NULL; END LOOP;
Should be changed to:
FOR i IN cursor_variable LOOP NULL; END LOOP;
Rewrite the FOR LOOP
condition or use a different kind of LOOP
to simulate the behavior.
If you need more support, you can email us at