MSCEWI3013

NLS parameter is not supported.

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

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 [email protected]