MSCEWI3029

DEFAULT ON CONVERSION ERROR is not supported.

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

Severity

Medium

Description

DEFAULT ON CONVERSION ERROR statement is not supported. It is removed in the converted code.

Example Code

Input Code:

SELECT TO_NUMBER('2,00' DEFAULT 0 ON CONVERSION ERROR) "Value" FROM DUAL;

Output Code:

SELECT
/*** MSC-ERROR - MSCEWI3029 - DEFAULT ON CONVERSION ERROR NOT SUPPORTED ***/
TO_NUMBER ('2,00') Value
FROM DUAL;

Recommendations

Last updated