Links

MSCEWI3077

Semantic information missing for ROWTYPE attribute

Severity

Low

Description

This warning is displayed when semantic analysis failed on the referenced table or cursor and the symbol could not be resolved.

Example Code

Input Code:

CREATE OR REPLACE PROCEDURE ROWTYPE_DEMO AS
RECORDROWTYPE TABLE_A%ROWTYPE;
BEGIN
NULL;
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.ROWTYPE_DEMO ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
// REGION SnowConvert Helpers Code
let RECORDROWTYPE = ROWTYPE(`PUBLIC.TABLE_A`) /*** MSC-WARNING - MSCEWI3077 - SEMANTIC INFORMATION COULD NOT BE LOADED FOR TABLE_A ROWTYPE ATTRIBUTE. TABLE ROWTYPE IS ASSUMED. ***/;
null;
$$;

Recommendations

  • If the rowtype record stores a row table the warning can be ignored. Otherwise, if the rowtype stores a cursor row, you have to change the syntax to use Cursor rowtype like CURSOR_VARIABLE.ROWTYPE(). For more information check the documentation related to rowtype.
  • If you need more support, you can email us at [email protected]