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]
Last updated