MSCEWI3031

SYS_CONTEXT parameter is not supported.

Severity

Medium

Description

This error happens when a SYS_CONTEXT function parameter is not supported.

Example Code

Input Code:

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

Output Code:

SELECT
/*** MSC-ERROR - MSCEWI3031 - 'NLS_SORT' SYS_CONTEXT PARAMETER NOT SUPPORTED ***/
SYS_CONTEXT_STUB('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 snowconvert-support@snowflake.com