SSC-FDM-OR0026
Type not supported in cast operation.
Description
This error happens when a type is not supported in a cast operation.
Example
Input Code:
select cast(' $123.45' as number, 'L999.99') from dual;
Output Code:
select
--** SSC-FDM-OR0026 - CAST TYPE NOT SUPPORTED **
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0011 - THE FORMAT PARAMETER ' $123.45' IS NOT SUPPORTED ***/!!!
cast(' $123.45' as NUMBER(38, 18) , 'L999.99') from dual;
Related EWIs
SSC-EWI-OR0011: The format parameter is not supported.
Recommendations
The cast is converted to a user-defined function (UDF/Stub), so you can modify it to emulate the behavior of the cast function.
If you need more support, you can email us at snowconvert-support@snowflake.com
Last updated