Links

MSCEWI3072

Procedural Member not supported

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]