MSCEWI3075

Labels in statements not supported

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

Severity

Medium

Description

Labels in statements not supported to reference a code block.

Example Code

Input Code:

CREATE OR REPLACE EDITIONABLE PROCEDURE PROCEDURE1 
IS
BEGIN
    -- procedure body
    EXIT loop_b;
    -- procedure body continuation
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.PROCEDURE1 ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
   // REGION SnowConvert Helpers Code  
   // procedure body
   /* ** MSC-ERROR - MSCEWI3076 - LABELS IN STATEMENTS ARE NOT SUPPORTED. ** */
   /*     EXIT loop_b */
   ;
   // procedure body continuation
$$;

Recommendations

• No end-user actions are required.

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