MSCEWI3072

Procedural Member not supported

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

Severity

Medium

Description

A procedural member is not currently supported. Example of procedural members:

• Constant declarations.

• Cursor declarations.

• Pragma declarations.

• Variable declarations.

Example Code

Input Code:

CREATE OR REPLACE EDITIONABLE PROCEDURE PROCEDURE1
   IS
   PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
    NULL;
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.PROCEDURE1 ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
   // REGION SnowConvert Helpers Code  
   /* ** MSC-ERROR - MSCEWI3073 - PROCEDURAL MEMBER PRAGMA DECLARATION NOT SUPPORTED. ** */
   /*    PRAGMA AUTONOMOUS_TRANSACTION */
   ;
   null;
$$;

Recommendations

• No end-user actions are required.

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