2023

Details about the releases of Snowflake SnowConvert for Oracle during 2023

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:

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:

Fixes and improvements:

  • 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

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.

Last updated