SSC-EWI-OR0031

SYS_CONTEXT parameter is not supported.

Severity

Low

Description

This error happens when a SYS_CONTEXT function parameter is not supported. Snowflake support similar context functions, check the page to more information

Example Code

Input Code:

IN -> Oracle_01.sql

SELECT SYS_CONTEXT ('USERENV', 'NLS_SORT') FROM DUAL;

Output Code:

OUT -> Oracle_01.sql

SELECT
!!!RESOLVE EWI!!! /*** SSC-EWI-OR0031 - 'NLS_SORT' SYS_CONTEXT PARAMETER NOT SUPPORTED IN SNOWFLAKE ***/!!!
 SYS_CONTEXT ('USERENV', 'NLS_SORT') FROM DUAL;

Recommendations

• The function is converted to a user defined function(stub), so you can modify it to emulate the behavior of the SYS_CONTEXT parameter.

• If you need more support, you can email us at [email protected]