LogoLogo
SnowflakeDocumentation Home
  • Snowflake SnowConvert Documentation
  • General (Beta)
    • Getting Started
      • System Requirements
      • Download and Access
      • Best practices
      • End User License Agreement
      • Release Notes ( Beta)
    • General Issues and Troubleshooting
      • FAQ and Troubleshooting
      • Complex Pattern Issues
        • MSCCP0001
        • MSCCP0002
        • MSCCP0003
        • MSCCP0004
        • MSCCP0005
        • MSCCP0006
        • MSCCP0007
        • MSCCP0008
        • MSCCP0009
        • MSCCP0010
        • MSCCP0011
      • Conversion Issues
        • MSCEWI1001
        • MSCEWI1002
        • MSCEWI1003
        • MSCEWI1004
        • MSCEWI1005
        • MSCEWI1006
        • MSCEWI1007
        • MSCEWI1009
        • MSCEWI1010
        • MSCEWI1011
        • MSCEWI1012
        • MSCEWI1013
        • MSCEWI1014
        • MSCEWI1015
        • MSCEWI1016
        • MSCEWI1017
        • MSCEWI1018
        • MSCEWI1019
        • MSCEWI1020
        • MSCEWI1021
        • MSCEWI1022
        • MSCEWI1023
        • MSCEWI1024
        • MSCEWI1025
        • MSCEWI1026
        • MSCEWI1027
        • MSCEWI1028
        • MSCEWI1029
        • MSCEWI1030
        • MSCEWI1031
        • MSCEWI1032
        • MSCEWI1033
        • MSCEWI1034
        • MSCEWI1035
        • MSCEWI1036
        • MSCEWI1037
        • MSCEWI1038
        • MSCEWI1039
        • MSCEWI1040
        • MSCEWI1041
        • MSCEWI1042
        • MSCEWI1043
        • MSCEWI1044
        • MSCEWI1045
        • MSCEWI1046
        • MSCEWI1047
        • MSCEWI1048
        • MSCEWI1049
        • MSCEWI1050
        • MSCEWI1051
        • MSCEWI1052
        • MSCEWI1053
        • MSCEWI1054
        • MSCEWI1055
        • MSCEWI1056
        • MSCEWI1057
        • MSCEWI1058
          • Teradata
          • Oracle
          • SQL Server
        • MSCEWI1059
        • MSCEWI1060
        • MSCEWI1061
        • MSCEWI1062
        • MSCEWI1063
        • MSCEWI1064
        • MSCEWI1065
        • MSCEWI1066
        • MSCEWI1067
        • MSCEWI1068
        • MSCEWI1069
        • MSCEWI1070
        • MSCEWI1071
        • MSCEWI1072
        • MSCEWI1073
        • MSCEWI1074
        • MSCEWI1075
        • MSCEWI1076
        • MSCEWI1077
        • MSCEWI1078
        • MSCEWI1079
        • MSCEWI1080
        • MSCEWI1081
        • MSCEWI1082
        • MSCEWI1083
        • MSCEWI1084
        • MSCEWI1086
        • MSCEWI1087
        • MSCEWI1088
        • MSCEWI1089
        • MSCEWI1090
        • MSCEWI1091
        • MSCEWI1092
        • MSCEWI1093
        • MSCEWI1094
        • MSCEWI1095
        • MSCEWI1096
        • MSCEWI1097
        • MSCEWI1098
        • MSCEWI1099
        • MSCEWI1100
        • MSCEWI1101
        • MSCEWI1102
        • MSCEWI1108
      • Informative Issues
        • MSCINF0001
        • MSCINF0002
        • MSCINF0003
        • MSCINF0004
        • MSCINF0005
        • MSCINF0006
        • MSCINF0007
        • MSCINF0008
    • Review Results
      • Output Code
      • Reports
        • Assessment Report
          • Overall Conversion Summary
          • SQL Conversion Summary
          • Scripts Line Conversion Summary
          • Object Conversion Summary
          • File and Object Level Breakdown - SQL Files
          • File and Object Level Breakdown - SQL Identified Objects
          • Scripts - Files
          • Scripts - Identified Objects
          • Schemas
          • Databases & Schemas
        • Top-Level Objects Report
        • Top-Level Queries Report
        • Issues Report
        • HTML Report
        • Missing Objects Report
        • Object References Report
        • Elements Report
    • How to Use SnowConvert with Docker
  • User Guide (Beta)
    • User Guide
    • How to install the tool
      • Linux
      • Windows
      • MacOS
    • How to update the tool
    • How to request an access code
    • What is a SnowConvert Project?
    • Supported Source Platforms
    • Assessment
      • Analyzing subfolders
    • Conversion
      • Converting subfolders
      • General Conversion Settings
      • Teradata Conversion Settings
      • Oracle Conversion Settings
      • SQL Server Conversion Settings
    • How to use the SnowConvert CLI
    • Additional Parameters
      • SnowConvert for SQL
      • Spark SnowConvert
    • Command Line Interface
  • FOR SQL LANGUAGES (BETA)
    • Release Notes
      • 2024
      • 2023
    • General Issues and Troubleshooting
  • General (Legacy)
    • Getting Started
      • Download and Access
      • Installation and Licensing
      • End User License Agreement
    • Contact Us
  • Function Reference
    • Teradata
      • CHAR2HEXINT_UDF
      • CHCKNUM_UDF
      • DATEADD_UDF
      • TIMESTAMP_DIFFERENCE_UDF
      • EXTRACT_TIMESTAMP_DIFFERENCE_UDF
      • TIME_DIFFERENCE_UDF
      • DATE_TO_INT_UDF
      • INT_TO_DATE_UDF
      • FIRST_DAY_OF_MONTH_ISO_UDF
      • DAYNUMBER_OF_MONTH_UDF
      • DAYNUMBER_OF_YEAR_UDF
      • COMPUTE_EXPAND_ON_UDF
      • EXPAND_ON_UDF
      • DIFFTTIME_PERIOD_UDF
      • ROW_COUNT_UDF
      • GETQUERYBANDVALUE_UDF
      • GETQUERYBANDVALUE_UDF
      • INSTR_UDF
      • INSTR_UDF
      • INSTR_UDF
      • INTERVAL_MULTIPLY_UDF
      • INTERVAL_ADD_UDF
      • INTERVAL_TO_MONTHS_UDF
      • INTERVAL_TO_SECONDS_UDF
      • JSON_EXTRACT_DOT_NOTATION_UDF
      • JSON_EXTRACT_UDF
      • JULIAN_TO_DATE_UDF
      • MONTHS_BETWEEN_UDF
      • NULLIFZERO_UDF
      • NVP_UDF
      • PERIOD_INTERSECT_UDF
      • PERIOD_OVERLAPS_UDF
      • QUARTERNUMBER_OF_YEAR_UDF
      • ROUND_DATE_UDF
      • SUBSTR_UDF
      • SUBSTR_UDF
      • TD_DAY_OF_CALENDAR_UDF
      • TD_DAY_OF_WEEK_UDF
      • TD_DAY_OF_WEEK_COMPATIBLE_UDF
      • TD_WEEK_OF_YEAR_UDF
      • TD_DAY_OF_WEEK_COMPATIBLE_UDF
      • FIRST_DAY_JANUARY_OF_ISO_UDF
      • YEAR_BEGIN_ISO_UDF
      • TD_YEAR_BEGIN_UDF
      • LAST_DAY_DECEMBER_OF_ISO_UDF
      • YEAR_END_ISO_UDF
      • TD_YEAR_END_UDF
      • TIMESTAMP_ADD_UDF
      • DAY_OF_WEEK_LONG_UDF
      • MONTH_NAME_LONG_UDF
      • TO_BYTES_HEX_UDF
      • CENTURY_UDF
      • DAYNAME_LONG_UDF
      • DAYNAME_LONG_UDF
      • DATE_LONG_UDF
      • FULL_MONTH_NAME_UDF
      • ISO_YEAR_PART_UDF
      • JULIAN_DAY_UDF
      • MONTH_SHORT_UDF
      • ROMAN_NUMERALS_MONTH_UDF
      • SECONDS_PAST_MIDNIGHT_UDF
      • WEEK_OF_MONTH_UDF
      • YEAR_PART_UDF
      • YEAR_WITH_COMMA_UDF
      • INSERT_CURRENCY_UDF
      • WRAP_NEGATIVE_WITH_ANGLE_BRACKETS_UDF
      • TRANSLATE_CHK_UDF
      • WEEK_NUMBER_OF_QUARTER_COMPATIBLE_UDF
      • WEEK_NUMBER_OF_QUARTER_ISO_UDF
      • WEEK_NUMBER_OF_QUARTER_COMPATIBLE_UDF
      • WEEKNUMBER_OF_MONTH_UDF
  • For Teradata
    • Introduction
    • Getting Started (LEGACY)
      • Training and Support
      • Code Extraction
      • Using SnowConvert
      • Review Results
        • Assessment.csv Report
        • Assessment.docx Report
        • Elements Report
        • Issues Report
        • Lineage Report
        • Output code
        • TopLevelObjects Report
    • Command Line Interface
      • Renaming feature
    • Code Extraction
    • Processing the code
      • Preprocess tasks
    • SQL Translation Reference
    • Issues and Troubleshooting
      • General Issues
      • MSCEWI2001
      • MSCEWI2002
      • MSCEWI2003
      • MSCEWI2004
      • MSCEWI2005
      • MSCEWI2006
      • MSCEWI2007
      • MSCEWI2008
      • MSCEWI2009
      • MSCEWI2010
      • MSCEWI2011
      • MSCEWI2012
      • MSCEWI2013
      • MSCEWI2014
      • MSCEWI2015
      • MSCEWI2016
      • MSCEWI2017
      • MSCEWI2018
      • MSCEWI2019
      • MSCEWI2020
      • MSCEWI2021
      • MSCEWI2022
      • MSCEWI2023
      • MSCEWI2024
      • MSCEWI2025
      • MSCEWI2026
      • MSCEWI2027
      • MSCEWI2028
      • MSCEWI2029
      • MSCEWI2030
      • MSCEWI2031
      • MSCEWI2032
      • MSCEWI2033
      • MSCEWI2034
      • MSCEWI2035
      • MSCEWI2036
      • MSCEWI2037
      • MSCEWI2038
      • MSCEWI2039
      • MSCEWI2040
      • MSCEWI2041
      • MSCEWI2042
      • MSCEWI2043
      • MSCEWI2044
      • MSCEWI2045
      • MSCEWI2046
      • MSCEWI2047
      • MSCEWI2049
      • MSCEWI2050
      • MSCEWI2051
      • MSCEWI2052
      • MSCEWI2053
      • MSCEWI2054
      • MSCEWI2055
      • MSCEWI2056
      • MSCEWI2057
      • MSCEWI2058
      • MSCEWI2059
      • MSCEWI2060
      • MSCEWI2061
      • MSCEWI2062
      • MSCEWI2063
      • MSCEWI2064
      • MSCEWI2065
      • MSCEWI2066
      • MSCEWI2067
      • MSCEWI2068
      • MSCEWI2069
      • MSCEWI2070
      • MSCEWI2071
      • MSCEWI2072
      • MSCEWI2073
      • MSCEWI2074
      • MSCEWI2075
      • MSCEWI2076
      • MSCEWI2077
      • MSCEWI2078
      • MSCEWI2079
      • MSCEWI2080
      • MSCEWI2081
      • MSCEWI2082
      • MSCEWI2083
      • MSCEWI2084
      • MSCEWI2085
      • MSCEWI2086
      • MSCEWI2087
      • MSCEWI2088
      • MSCEWI2089
      • MSCEWI2090
      • MSCEWI2091
    • Release Notes
      • 2024
      • 2023
      • 2022
      • 2021
      • 2020
      • Roadmap
    • Considerations
  • For Oracle
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output Code
        • Assessment Report
        • Issues Report
        • Top-Level Objects Report
    • Command Line Interface
    • Code Extraction
    • Processing the code
      • Preprocess tasks
    • Issues and Troubleshooting
      • General Issues
      • MSCEWI3001
      • MSCEWI3002
      • MSCEWI3003
      • MSCEWI3004
      • MSCEWI3005
      • MSCEWI3006
      • MSCEWI3007
      • MSCEWI3008
      • MSCEWI3009
      • MSCEWI3010
      • MSCEWI3011
      • MSCEWI3012
      • MSCEWI3013
      • MSCEWI3014
      • MSCEWI3015
      • MSCEWI3016
      • MSCEWI3017
      • MSCEWI3018
      • MSCEWI3019
      • MSCEWI3020
      • MSCEWI3021
      • MSCEWI3022
      • MSCEWI3023
      • MSCEWI3024
      • MSCEWI3025
      • MSCEWI3026
      • MSCEWI3027
      • MSCEWI3028
      • MSCEWI3029
      • MSCEWI3030
      • MSCEWI3031
      • MSCEWI3032
      • MSCEWI3033
      • MSCEWI3034
      • MSCEWI3035
      • MSCEWI3036
      • MSCEWI3037
      • MSCEWI3038
      • MSCEWI3039
      • MSCEWI3040
      • MSCEWI3041
      • MSCEWI3042
      • MSCEWI3043
      • MSCEWI3044
      • MSCEWI3046
      • MSCEWI3047
      • MSCEWI3048
      • MSCEWI3049
      • MSCEWI3050
      • MSCEWI3051
      • MSCEWI3052
      • MSCEWI3053
      • MSCEWI3054
      • MSCEWI3055
      • MSCEWI3056
      • MSCEWI3057
      • MSCEWI3058
      • MSCEWI3059
      • MSCEWI3060
      • MSCEWI3061
      • MSCEWI3062
      • MSCEWI3063
      • MSCEWI3064
      • MSCEWI3065
      • MSCEWI3066
      • MSCEWI3067
      • MSCEWI3068
      • MSCEWI3069
      • MSCEWI3070
      • MSCEWI3071
      • MSCEWI3072
      • MSCEWI3073
      • MSCEWI3074
      • MSCEWI3075
      • MSCEWI3076
      • MSCEWI3077
      • MSCEWI3078
      • MSCEWI3079
      • MSCEWI3080
      • MSCEWI3081
      • MSCEWI3082
      • MSCEWI3083
      • MSCEWI3084
      • MSCEWI3085
      • MSCEWI3086
      • MSCEWI3087
      • MSCEWI3088
      • MSCEWI3089
      • MSCEWI3090
      • MSCEWI3091
      • MSCEWI3092
      • MSCEWI3093
      • MSCEWI3094
      • MSCEWI3095
      • MSCEWI3096
      • MSCEWI3097
      • MSCEWI3098
      • MSCEWI3099
      • MSCEWI3100
      • MSCEWI3101
      • MSCEWI3102
      • MSCEWI3103
      • MSCEWI3104
      • MSCEWI3105
      • MSCEWI3106
      • MSCEWI3107
      • MSCEWI3108
      • MSCEWI3109
      • MSCEWI3110
      • MSCEWI3111
      • MSCEWI3112
      • MSCEWI3113
      • MSCEWI3114
      • MSCEWI3115
      • MSCEWI3116
      • MSCEWI3117
      • MSCEWI3118
      • MSCEWI3119
      • MSCEWI3120
      • MSCEWI3121
      • MSCEWI3122
      • MSCEWI3123
      • MSCEWI3124
      • MSCEWI3125
      • MSCEWI3126
      • MSCEWI3127
      • MSCEWI3128
      • MSCEWI3129
      • MSCEWI3130
      • MSCEWI3131
      • MSCEWI3132
      • MSCEWI3133
      • MSCEWI3135
    • Release Notes
      • 2023
      • 2022
      • 2021
      • 2020
      • Roadmap
    • SQL Translation Reference
  • FOR SQL SERVER
    • Introduction
    • Getting Started (LEGACY)
      • Training and Support
      • Arrange the Source Code
      • Review Results
        • Output Code
        • Assessment Report
        • Issues Report
        • TopLevelObjects Report
      • Using SnowConvert
    • Command Line Interface
    • Code Extraction
    • Translation Reference
    • Issues and Troubleshooting
      • General Issues
      • MSCEWI4001
      • MSCEWI4002
      • MSCEWI4003
      • MSCEWI4004
      • MSCEWI4005
      • MSCEWI4006
      • MSCEWI4007
      • MSCEWI4008
      • MSCEWI4009
      • MSCEWI4010
      • MSCEWI4011
      • MSCEWI4012
      • MSCEWI4013
      • MSCEWI4014
      • MSCEWI4015
      • MSCEWI4016
      • MSCEWI4017
      • MSCEWI4018
      • MSCEWI4019
      • MSCEWI4020
      • MSCEWI4021
      • MSCEWI4022
      • MSCEWI4023
      • MSCEWI4024
      • MSCEWI4025
      • MSCEWI4026
      • MSCEWI4027
      • MSCEWI4028
      • MSCEWI4029
      • MSCEWI4030
      • MSCEWI4031
      • MSCEWI4032
      • MSCEWI4033
      • MSCEWI4034
      • MSCEWI4035
      • MSCEWI4036
      • MSCEWI4037
      • MSCEWI4038
      • MSCEWI4039
      • MSCEWI4040
      • MSCEWI4041
      • MSCEWI4042
      • MSCEWI4043
      • MSCEWI4044
      • MSCEWI4045
      • MSCEWI4046
      • MSCEWI4047
      • MSCEWI4048
      • MSCEWI4049
      • MSCEWI4050
      • MSCEWI4051
      • MSCEWI4052
      • MSCEWI4053
      • MSCEWI4054
      • MSCEWI4055
      • MSCEWI4056
      • MSCEWI4057
      • MSCEWI4058
      • MSCEWI4059
      • MSCEWI4060
      • MSCEWI4061
      • MSCEWI4062
      • MSCEWI4063
      • MSCEWI4064
      • MSCEWI4065
      • MSCEWI4066
      • MSCEWI4067
      • MSCEWI4068
      • MSCEWI4069
      • MSCEWI4070
      • MSCEWI4071
      • MSCEWI4072
      • MSCEWI4073
      • MSCEWI4074
      • MSCEWI4075
    • Release Notes
      • 2023
      • 2022
      • 2021
      • Roadmap
  • For IBM DB2
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
      • MSCEWI5001
      • MSCEWI5002
      • MSCEWI5003
      • MSCEWI5004
      • MSCEWI5005
      • MSCEWI5006
      • MSCEWI5007
      • MSCEWI5008
      • MSCEWI5009
      • MSCEWI5010
      • MSCEWI5011
      • MSCEWI5012
      • MSCEWI5013
      • MSCEWI5014
      • MSCEWI5015
      • MSCEWI5016
      • MSCEWI5017
      • MSCEWI5018
      • MSCEWI5019
      • MSCEWI5020
      • MSCEWI5021
      • MSCEWI5022
    • Release Notes
      • 2022
  • For PostgreSQL
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
      • MSC-PG0000
      • MSC-PG0001
      • MSC-PG0002
      • MSC-PG0003
      • MSC-PG0004
      • MSC-PG0005
      • MSC-PG0006
      • MSC-PG0007
      • MSC-PG0008
      • MSC-PG0009
      • MSC-PG0010
      • MSC-PG0011
      • MSC-PG0012
      • MSC-PG0013
      • MSC-PG0014
      • MSC-PG0015
      • MSC-PG0016
      • MSC-PG0017
      • MSC-PG0018
      • MSC-PG0019
      • MSC-PG0020
      • MSC-PG0021
      • MSC-PG0022
      • MSC-PG0023
      • MSC-PG0024
      • MSC-PG0025
      • MSC-PG0026
      • MSC-PG0027
      • MSC-PG0028
    • Release Notes
      • 2022
  • For Greenplum
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
      • MSC-GP0000
      • MSC-GP0001
      • MSC-GP0002
      • MSC-GP0003
    • Release Notes
      • 2022
  • For Amazon RedShift
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
      • MSC-RS0004
      • MSC-RS0005
      • MSC-RS0011
      • MSC-RS0012
      • MSC-RS0013
      • MSC-RS0014
    • Release Notes
      • 2022
  • For Google BigQuery
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
      • General Issues
      • MSC-BQ0001
      • MSC-BQ0002
      • MSC-BQ0003
      • MSC-BQ0004
      • MSC-BQ0005
      • MSC-BQ0006
      • MSC-BQ0007
      • MSC-BQ0008
      • MSC-BQ0009
      • MSC-BQ0010
      • MSC-BQ0011
      • MSC-BQ0012
      • MSC-BQ0013
      • MSC-BQ0014
      • MSC-BQ0015
      • MSC-BQ0016
    • Release Notes
      • 2022
  • For Apache Hive
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
    • Release Notes
      • 2022
  • For Vertica
    • Introduction
    • Getting Started (LEGACY)
      • Using SnowConvert
      • Review Results
        • Output
        • Reports
    • Command Line Interface
    • Translation Reference
    • Issues and Troubleshooting
    • Release Notes
      • 2022
  • for Spark (Scala)
    • Snowpark Migration Accelerator for Spark Scala
  • FOR SPARK (PYTHON)
    • Snowpark Migration Accelerator for PySpark
  • Databricks workloads
    • Getting started
      • DBC files explode
Powered by GitBook
On this page
  • Issues Code
  • Issues Severity
  • Low
  • Medium
  • High
  • Critical
  • Need more support?
  1. For Oracle

Issues and Troubleshooting

In this section, you will find information about Errors, Warnings, and Issues on the SnowConvert.

PreviousPreprocess tasksNextGeneral Issues

Last updated 1 year ago

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

Before we get too far down the troubleshooting road, recall that we highly recommend that you go through in order to get the most out of SnowConvert.

Conversions of any large quantity of code will likely have a few errors and warnings. When using any of our tools, you can count on us to be your partner in resolving any errors you may encounter.

Below is a list of specific conversion issues for Oracle that you may see when you perform conversion with SnowConvert along with a severity level for each. Some suggested solution paths based on the severity level will follow the list of codes.

Take a minute to read through the list and the troubleshooting tips to help diagnose some of the error codes you have encountered. If you have a question that cannot be answered here, please reach out! You can drop us an email at . This is a living list, so it will grow and change as SnowConvert evolves. Updates to issue and error handling will appear on this page, and will also appear in the .

Issues Code

Here is the list of issue codes that exist in the SnowConvert for the Oracle platform. A detailed description of each issue code with its respective severity level can be seen in the following table.

Code
Description
Severity

The create sequence 'start with' statement value can not be LIMIT VALUE

Medium

Foreign key mismatch

Medium

OUTER JOIN syntax changed

Low

Syntax not supported

High

The format may be needed

Low

Timestamp output format

Low

Different output

Low

Unknown format

Low

JSON_TABLE not supported

High

XMLTABLE not supported

High

Format parameter not supported

Medium

Call specification not supported

Medium

NLS Parameter not supported

Medium

NLSSORT not supported

Medium

NLSSORT transformed

Low

Xml not supported

Medium

DBTIMEZONE removed

Low

Snowflake does not support occurrence parameter

Low

USING NCHAR_CS not supported

Low

Negative values not supported for function

Medium

SQL implicit cursor values may differ

Low

Siblings not supported

Low

RANK AGGREGATE function not supported

High

Table properties not required

Low

Synonyms not supported

Low

Rowid not supported

Medium

Rownum not supported

Medium

Multiset operator not supported

Medium

The default value on conversion error, not supported

Medium

Keep statement used to indicate that only the first or last values of the aggregate function will be returned is not supported

Medium

Not suitable function found to replace the input parameter for SYSCONTEXT

Medium

The specified parameter for the function is not supported

Medium

PLDeclaration in WITH statement not supported

Medium

Package Procedure/Function declaration heading not necessary

Low

The table collection expression is not supported

High

Arithmetic types not supported

Medium

Using index constraint state removed

Low

Search clause removed

Low

Cycle clause removed

Low

Statements and keywords removed from the column definition

Low

Enable or disable constraint state removed

Low

Model clause removed

Low

Create table statements removed

Low

Sequence option removed

Low

Missing dependencies objects

Low

Alter Table syntax is not applicable in Snowflake

Medium

TO_NCHAR transformed to TO_VARCHAR

Low

Function language not supported.

High

Package member not supported

Medium

Call to User Defined function not supported inside queries

High

PRAGMA EXCEPTION_INIT Not Supported

Low

Exception declaration is handled by the raise function

Low

User defined function was transformed to Snowflake procedure

Low

Package constant declaration

Low

Wrapped element not supported

Medium

Object versioning is not supported

Low

Nested Procedure or Function not supported

Medium

Date format session parameter

Low

Alter session configuration is not supported

Medium

Default value for SYSDATE is CURRENT_TIMESTAMP

Low

Column was transformed from DATE to TIMESTAMP

Low

NLS_NUMERIC_CHARACTERS session parameter not supported

Medium

Query using WITH TIES clause is missing ORDER BY

Low

Snowflake default calendar is Gregorian. It is not necessary to specify as a parameter

Low

NOCYCLE property is not supported

Medium

Add to stack of errors is not supported, boolean argument was removed

Low

Multiple Constraint Definition in a single statement is not supported in Snowflake

Medium

The create sequence 'start with' statement value exceeds the max value allowed by Snowflake.

Medium

CURRVAL property is not supported in Snowflake

Medium

Binary Operation Not Supported

Medium

Set Quantifier Not Supported

Low

Procedural Member not supported

Medium

Create Database Link Not Supported

Low

Create Index Not Supported

High

Labels in statements not supported

Medium

Built In Package Not Supported

Medium

Semantic information missing for ROWTYPE attribute

Low

Unable to parse dynamic SQL statement inside Execute Immediate

Medium

INSTR function converted to REGEXP_INSTR

Low

Create Type Not Supported

High

Snowflake Non-Ansi Outer Join has some functional differences compared to Oracle

Low

Cannot Convert Nested Type Attribute Expression

Medium

Unsupported format used for Trunc function

Low

Snowflake does not have a PURGE clause inside the DROP TABLE statement

Low

CASCADE CONSTRAINTS modified inside DROP TABLE statement to CASCADE

Low

Window frame output may not be equivalent

Low

Ordering of the Outer Joins failed

Low

Condition with unknown table name for outer join with (+)

Low

REGEXP_LIKE_UDF match parameter may not behave correctly

Low

Non-Ansi Outer Join has an invalid Between predicate

Low

LENGTHB transformed to OCTET_LENGTH results may vary due to memory management of DBMS

Low

Number datatype negative scale was removed from output

Low

Number datatype smaller precision was increased to match scale

Low

ROWID pseudocolumn is not supported in Snowflake

Medium

Operation Between Interval and Date Type not Supported

Medium

Interval Literal Not Supported In Current Scenario

High

Procedure Properties are Not Supported in Snowflake Procedures

Low

The Not Null constraint is not supported in variable declarations inside procedures in Snowflake

Low

Exception declaration code exceeds the Snowflake Scripting exception number limits

Low

For Loop with multiple conditions is currently not supported by Snowflake Scripting. Only first condition is used

Low

Specific For Lopp clause is currently not supported by Snowflake Scripting

Low

For Loop with float number as bound may not behave correctly in Snowflake Scripting

Low

For Loop format is currently not supported by Snowflake Scripting

High

Unusable collection variable

High

Additional work is needed for BFILE column usage. BUILD_STAGE_URL function is a recommended workaround

Low

Parametrized Cursor is not supported by Snowflake Scripting

High

Label declaration not supported

Low

The following assignment statement is not supported by Snowflake Scripting

Medium

Expressions as arguments of using clause are not supported by Snowflake Scripting

Medium

For update clause is not supported by Snowflake Scripting

Low

Transaction control statement requires additional intervention

Medium

DBMS_RANDOM.VALUE Built-In Package precision is lower in Snowflake

Low

The error logging clause in DML statements is not supported by Snowflake

Medium

Snowflake merge statement may have some functional differences compared to Oracle

Low

Check UDF implementation DBMS_OUTPUT.PUTLINE

Low

Operations between Intervals are not supported

Medium

Day format works differently between Oracle and Snowflake.

Low

Built-In views are not supported

Medium

Supplemental logging clause commented out

Low

Unnecessary built-in packages parameters

Low

Package Variable Assignment transformation

Low

Database Link connections not supported

Medium

Default Value Not Found For Parameter

Medium

Built-in package custom type changed to VARIANT

Low

Unusable object because its built-in custom type is not supported

Medium

Column alias removed

Low

Boolean cursor attribute is not supported

Medium

TYPE attribute could not be resolved

Low

For Loop and Fetch into variable cannot be used on the same cursor

Medium

COMMIT and ROLLBACK statements require the appropiate setup to work as intended

Low

COMMIT and ROLLBACK option were removed because Snowflake does not require them

Low

Cursor variable has already been assigned

Medium

Data Retention Period May Produce No Results

Low

Issues Severity

In this section, you can find an explanation of the severities.

Low

Warnings for source code that there was no direct conversion to Snowflake. The code has been converted to a functionally equivalent output but should still be reviewed.

Medium

Errors that produce a functional or runtime difference. The user may have to invest a low amount of manual effort to complete the conversion.

High

Errors that produce a functional or runtime difference. The user may have to invest a high amount of manual effort to complete the conversion.

Critical

Parsing errors or errors that cause significant conversion exceptions in SnowConvert. If the source code is correct, a significant intervention will be required.

Need more support?

As has been mentioned previously in this article, please reach out to us if you need more support. Snowflake wants to be your partner in the conversion process, so let us know how we can help. You can email us at . If you have a contract for support with Snowflake, reach out to your sales engineer and they can direct your support needs.

HERE
our training labs
snowconvert-support@snowflake.com
release notes
snowconvert-support@snowflake.com
MSCEWI3098
MSCEWI3001
MSCEWI3002
MSCEWI3003
MSCEWI3004
MSCEWI3005
MSCEWI3006
MSCEWI3007
MSCEWI3008
MSCEWI3009
MSCEWI3010
MSCEWI3011
MSCEWI3012
MSCEWI3013
MSCEWI3014
MSCEWI3015
MSCEWI3016
MSCEWI3017
MSCEWI3018
MSCEWI3019
MSCEWI3020
MSCEWI3021
MSCEWI3022
MSCEWI3023
MSCEWI3024
MSCEWI3025
MSCEWI3026
MSCEWI3027
MSCEWI3028
MSCEWI3029
MSCEWI3030
MSCEWI3031
MSCEWI3032
MSCEWI3033
MSCEWI3034
MSCEWI3035
MSCEWI3036
MSCEWI3037
MSCEWI3038
MSCEWI3039
MSCEWI3040
MSCEWI3041
MSCEWI3042
MSCEWI3043
MSCEWI3044
MSCEWI3045
MSCEWI3046
MSCEWI3047
MSCEWI3048
MSCEWI3049
MSCEWI3050
MSCEWI3051
MSCEWI3052
MSCEWI3053
MSCEWI3054
MSCEWI3055
MSCEWI3056
MSCEWI3057
MSCEWI3058
MSCEWI3059
MSCEWI3060
MSCEWI3061
MSCEWI3062
MSCEWI3063
MSCEWI3064
MSCEWI3065
MSCEWI3066
MSCEWI3067
MSCEWI3068
MSCEWI3069
MSCEWI3070
MSCEWI3071
MSCEWI3072
MSCEWI3073
MSCEWI3074
MSCEWI3075
MSCEWI3076
MSCEWI3077
MSCEWI3078
MSCEWI3079
MSCEWI3080
MSCEWI3081
MSCEWI3082
MSCEWI3083
MSCEWI3084
MSCEWI3085
MSCEWI3086
MSCEWI3087
MSCEWI3088
MSCEWI3089
MSCEWI3090
MSCEWI3091
MSCEWI3092
MSC
EWI3093
MSCEWI3094
MSCEWI3095
MSCEWI3096
MSCEWI3097
MSCEWI3099
MSCEWI3100
MSCEWI3101
MSCEWI3102
MSCEWI3103
MSCEWI3104
MSCEWI3105
MSCEWI3106
MSCEWI3107
MSCEWI3108
MSCEWI3109
MSCEWI3110
MSCEWI3111
MSCEWI3112
MSCEWI3113
MSCEWI3114
MSCEWI3115
MSCEWI3116
MSCEWI3117
MSCEWI3118
MSCEWI3119
MSCEWI3120
MSCEWI3122
MSCEWI3123
MSCEWI3124
MSCEWI3125
MSCEWI3126
MSCEWI3127
MSCEWI3128
MSCEWI3129
MSCEWI3130
MSCEWI3131
MSCEWI3132
MSCEWI3133
MSCEWI3135