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]​

MSCEWI3076

MSCEWI3078

Last modified 3mo ago