2023

Details about the releases of Snowflake SnowConvert for Oracle during 2023

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

Release 3.0.257 - September 13th, 2023

SnowConvert Core 22.2.63

Fixes and improvements:

• Fix returning values in procedures with output parameter

• Improve output parameter equivalent transformation

• Fix translation related to partition by list on tables

• Improve the variable assignment in functions

• Fix return statement that is transformed in order to support output parameters with original and equivalent values

• Optimize the preprocess code stage

Release 3.0.251 - September 7th, 2023

SnowConvert Core 22.2.48

Added:

• Parse LITERAL and INNER as identifiers

• Support for OraAggregateClause when it is the body of a function

• Support for STRING type

Release 3.0.244 - August 30th, 2023

SnowConvert Core 22.2.30

Added:

• Parse FROM clause with VERSIONS BETWEEN

• Support DECLARE CURSORS defined with CTE

Fixes and improvements:

• Fix parsing error in collection method with index

• Improve detection of built-in table/view references and report of MSCEWI3118

Release 3.0.238 - August 23rd, 2023

SnowConvert Core 22.2.9

Fixes and improvements:

• The qualified table/view name is being changed in queries

Release 3.0.225 - August 16th, 2023

SnowConvert Core 22.0.47

Added:

• Generate new Elements csv report for conversions and assessments

Fixes and improvements:

• Parse MINING, AT, RANGE, LARGE, FULL, OUTER, ATTRIBUTE, OPERATOR as an identifier

Release 3.0.221 - August 9th, 2023

SnowConvert Core 22.0.32

Added:

• Parsing for Identifiers: MINING, AT, RANGE, LARGE, ROWNUM, FULL, OUTER, ATTRIBUTE, OPERATOR

• Transformation for FORALL referenced sub-query as an expression

Fixes and improvements:

• Reduced the number of built-in functions marked with Pending Functional Review EWI

Release 3.0.218 - August 3rd, 2023

SnowConvert Core 22.0.23

Added:

• Transformation for XMLQUERY.

• Transformation for the IS [ NOT ] EMPTY expression

Fixes and improvements:

• Improve EWI mechanism for better consistency.

• Add EWI for unsupported Table Collection Expression.

• Parsing for XmlQuery function.

• Add parsing support for the JSON_VALUE function

Release 3.0.209 - July 26th, 2023

SnowConvert Core 21.0.165

Added:

• Parsing of nested calls supported.

Fixes and improvements:

• Gregorian to Julian date precision improvement.

• Fix issues related to FORALL transformation.

Release 3.0.206 - July 19th, 2023

SnowConvert Core 21.0.153

Added:

• Generate new Object References csv report for conversions and assessments

• Generate new Missing Object References csv report for conversions and assessments

• Added Support for Create Type Body Syntax

Fixes and improvements:

• Adding new columns and reordering existing columns on the Issues.csv report

• Remove generation of HtmlReport for all conversions and assessments

• Parsing Errors on Returning Into, partition_extension_clause, Q string, VALIDATE, and ROLLUP Identifiers

• Conditional Compilation Parsing Error

• Fix Built-In Package Assignment conversion error

• Resolve Labeled Statements conversion error

• Improve problematic Dynamic SQL identification

• Init cursor single quotes cause a compilation error

• Fix concurrency conversion issue with FORALL transformation

Release 3.0.198 - July 12th, 2023

SnowConvert Core 21.0.129

Fixes and improvements:

• Solved parsing error on Return Into Clause

• Solved parsing error on Partition Clause

• Solved parsing error on Q Literal

• Solved parsing error on Validate Clause

• Solved parsing error on Rollup Clause

Release 3.0.180 - July 5th, 2023

SnowConvert Core 21.0.107

Fixes and improvements:

• Update the license mechanism to a more secure compliant mechanism

• Improve consistency in conversion for Materialized Views

• Count of Materialized Views that reference multiple objects added to the Assessment Report

• Deprecate Output Parameters' EWI (MSCEWI1078)

• Parse CLOB Cast, IS EMPTY expression and Flashback query

• Count of nested cursors and cursors inside queries added to the Assessment Report

• Include conversion settings in the Assessment Report to view the selected conversion language such as JavaScript and Snowflake Scripting

• Parse SAVEPOINT as an identifier

• Improve exception handling

• Parse the CREATE TYPE element spec

Release 3.0.112 - June 8th, 2023

SnowConvert Core 21.0.43

Fixes and improvements:

• The object conversion rate in packages is not 100% with only low EWIs present

• The object conversion rate in views is not 100% with only low EWIs present

• The object conversion rate in procedures is not 100% with only low EWIs present

• The object conversion rate in materialized views is not 100% with only low EWIs present

• Multiple exceptions are thrown when using simple expressions in procedure calls

Release 3.0.99 - May 24th, 2023

SnowConvert Core 20.4.20

Fixes and improvements:

• Fix inconsistencies in reporting MSCEWI1020

Release 3.0.81 - May 10th, 2023

SnowConvert Core 20.2.8

Fixes and improvements:

• Add MSCCP0006 EWI to Oracle Loop

• Fix duplicated MSCCP0004 issue in the Issues report

• LazyColumn serialization fix

• Add MSCCP0005 EWI to fetch bulk operations

Release 3.0.71 - May 3rd, 2023

SnowConvert Core 18.4.127

Fixes and improvements

• Removes UDFs from not supported functions, they are marked now only with the MSCEWI1073

• Preserve column names when transforming INSERT in forall statement

Release 3.0.63 - April 26th, 2023

SnowConvert Core 18.4.111

Fixes and improvements

• Fix Parsing Error in Lock Table

• Fix for performance issue when parsing nested Selects with left join

• Fix for parsing error when NOCOPY is used without OUT parameters

Release 3.0.56 - April 12th, 2023

SnowConvert Core 18.4.67

Added

• Count for Temporary Tables in Assessment.docx

• Add EWI to invalid subqueries

Fixes and improvements

• Support for multiple ForAll pattern-based transformations in a procedure

• Inconsistency between the EWIs number in .csv file and output code

• Replacing branding Mobilize.Net by Snowflake

Release 3.0.31 - March 28th, 2023

SnowConvert Core 18.4.1

Added

• Transformation of SQL Plus Command SPOOL.

Fixes and improvements

• Added a count feature in the assessment report of Materialized Views that reference multiple elements.

• Fixed issue with the count of Procedures. This fix ensures that the count accurately reflects Top Level Procedures and Package Procedures in the migration, excluding those that are nested.

• Enhanced the transformation of qualified names with schemas.

Release 3.0.19 - March 13th, 2023

SnowConvert Core 18.2.70

Added

• Add count for Dynamic SQL section in Assessment report.

• Update the subqueries section of the assessment template to count invalid subquery patterns.

Assessment of SQL*Plus Commands

• ACCEPT

• APPEND

• ARCHIVE LOG

• BREAK

• CHANGE

• COMPUTE

Release 3.0.10 - February 27th, 2023

SnowConvert Core 18.2.40

Added

• A breakdown of cursor usage patterns in assessment report.

Support for SQL*Plus commands

• Parsing of ATTRIBUTE command.

• Parsing of BTITLE command.

• Assessment of ATTRIBUTE command

• Assessment of BTITLE comMand

Fixes and improvements

• Improved error handling for the process of collecting information for reports.

Release 3.0.5 - February 14th, 2023

SnowConvert Core 18.2.11

Added

• Added transformation of OPEN FOR statement.

• Change default database name behavior to NONE for CLI and UI.

• Count table-valued functions and multi-statement functions in Assessment.

Support for FORALL statement

• DELETE statement using a collection of records with fields with the same name as the table's columns being deleted.

• Translation when a package contains a collection of records.

• Default transformation for unknown patterns.

Fixes and improvements

• Parsing of LOG ERRORS clause in Update and Delete statements.

• Enhanced the EWI View count in the Issues report.

• Improved counters for tables with BLOB/CLOB datatypes.

Release 2.0.300 - January 30th, 2023

SnowConvert Core 15.0.23

Added

• Include a count of both table-value and multi-statement functions in the assessment report.

Assessment of SQL*Plus Commands

• SET

• CLEAR

• SPOOL

• REMARK

• HOST

• COLUMN

• DEFINE

• PROMPT

• SHOW

• START

• WHENEVER ERROR

Parsing of SQL*Plus Commands

• SET

• CLEAR

• SPOOL

Support for FORALL statement

• FORALL using a cursor variable with a dynamic SQL query.

• MERGE statement that uses a single collection of records

• DELETE statement using a collection of records with fields with the same name as the table's columns being deleted.

• UPDATE statement with LOOP, FORALL, and FETCH BULK COLLECT INTO operation.

• INSERT statement with a parametrized cursor.

Fixes and improvements

• COMMIT and ROLLBACK transformation improved.

• COMMIT and ROLLBACK documentation improved

• Improve encoding handling infrastructure.

Security

• Vulnerability reduction patch included.

Release 2.0.288 - January 17th, 2023

SnowConvert Core 13.0.110

Added

Support for FORALL statement

• Transform FORALL with INSERT INTO that uses a collection of Records.

• Transform FORALL using a cursor variable with a dynamic SQL query.

• Transform FORALL with INSERT INTO using the ROW directly that matches the table's structure.

• Match Pattern when a package contains a collection of records. Then the collection is used in procedures

• Match Pattern when there are multiple FORALL statements in the same procedure.

Parsing of SQL*Plus Commands

• SHOW

• Add count of Loops and Cursors to Assessment report.

• Removed the deprecated conversion parameters --snowcript and --disableSnowScript from the CLI. Their functionality is now replaced with the parameter --PLTargetLanguaje.

Fixes and improvements

• Add EWI for parameterized cursors when the same record is used in FOR and FETCH statements.

• Fix conversion errors.

Release 2.0.274 - January 3rd, 2023

SnowConvert Core 13.0.70

Added

Parsing of SQL*Plus Commands

• DEFINE

• COLUMN

• WHENEVER OSERROR

• WHENEVER SQLERROR

FORALL pattern match

• Merge statement that uses a single collection of records.

• SELECT BULK COLLECT INTO without LOOP

• Transformation added for %Type attribute.

• EWI is added when the same parameterized cursor is used in fetch and for operations in the same procedure.

Fixes and improvements

• Fix the issue with bindings when a variable has %TYPE attribute as a data type.

• Fix conversion errors.

• Fix case inconsistencies in record fields.