MSCEWI3077
Semantic information missing for ROWTYPE attribute
Low
This warning is displayed when semantic analysis failed on the referenced table or cursor and the symbol could not be resolved.
CREATE OR REPLACE PROCEDURE ROWTYPE_DEMO AS
RECORDROWTYPE TABLE_A%ROWTYPE;
BEGIN
NULL;
END;
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;
$$;
- If the
rowtype
record stores a row table the warning can be ignored. Otherwise, if therowtype
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 torowtype
.
Last modified 3mo ago