SSC-EWI-OR0031

SYS_CONTEXT parameter is not supported.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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]

Last updated