MSCEWI3078

Unable to parse dynamic SQL statement inside Execute Immediate

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

Severity

Medium

Description

SnowConvert was not able to parse the dynamic SQL statement inside the Execute Immediate.

Example Code

Input Code

CREATE OR REPLACE PROCEDURE PROC1 AS
BEGIN
    EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML';
END;

Output Code

CREATE OR REPLACE PROCEDURE PUBLIC.PROC1 ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
   // REGION SnowConvert Helpers Code

   /*** MSC-ERROR - MSCEWI3078 - UNABLE TO PARSE DYNAMIC SQL STATEMENT ***/
   /*EXEC(`ALTER SESSION FORCE PARALLEL DML`)*/
   ;
$$;

Recommendations

• Check the dynamic SQL statement for any syntax error.

• Review the SnowConvert documentation to see if the statement is still unsupported.

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