SSC-FDM-OR0026

Type not supported in cast operation.

This FDM is deprecated, please refer to SSC-EWI-OR0045 documentation.

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;
  1. 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