MSCEWI3013

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:

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

Output Code:

SELECT
  -- *** MSC-ERROR - MSCEWI3013 - NLS PARAMETER ' NLS_NUMERIC_CHARACTERS = '',.''NLS_CURRENCY= ''AusDollars''' NOT SUPPORTED ***
  TO_NUMBER_STUB('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