SSC-EWI-OR0013

NLS parameter is not supported.

Severity

Medium

Description

NLS parameter is not currently supported for the following functions:

  • TOCHAR

  • TODATE

  • TONUMBER

  • TOTIMESTAMP

  • CAST

Example Code

Input Code:

IN -> Oracle_01.sql
SELECT TO_NUMBER('-AusDollars100','9G999D99', ' NLS_NUMERIC_CHARACTERS = '',.''NLS_CURRENCY= ''AusDollars''') "Amount" FROM DUAL;

Output Code:

OUT -> Oracle_01.sql
SELECT
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0013 - NLS PARAMETER ' NLS_NUMERIC_CHARACTERS = '',.''NLS_CURRENCY= ''AusDollars''' NOT SUPPORTED ***/!!!
 TO_NUMBER('-AusDollars100','9G999D99', ' NLS_NUMERIC_CHARACTERS = '',.''NLS_CURRENCY= ''AusDollars''') "Amount" FROM DUAL;

Recommendations

  • TO_NUMBER is converted to a user-defined function (UDF/Stub), so you can modify it to emulate the behavior of the parameter.

  • If you need more support, you can email us at snowconvert-support@snowflake.com

Last updated