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 [e-mail]