SSC-EWI-OR0108
The Following Assignment Statement is Not Supported by Snowflake Scripting
Severity
Medium
Some parts of the output code are omitted for clarity reasons.
Description
Some Oracle variable types do not have a direct translation in Snowflake. Currently, transformation for cursor, collection, record, and user-defined type variables; as well as placeholders, objects, and output parameters are not supported by Snow Scripting.
Changing these variables to Snowflake semi-structured data types could help as a workaround in some scenarios.
Example Code
Input Code:
Output Code:
Related EWIS
SSC-EWI-0036: Data type converted to another data type.
SSC-FDM-0024: Functionality is not currently supported by Snowflake Scripting.
SSC-EWI-0062: Custom type usage changed to variant.
Recommendations
Change the variable data type or try to simulate the behavior using Snowflake semi-structured data types.
If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated